PHP Format Decimal Data Type As Percent with % Character

Asked Apr 18 '16 at 01:31

Active Apr 18 '16 at 01:48

Viewed 1,248 times

I am trying to format a number column (Data type Decimal) so it displays as a percentage, example - 95%.

My MySql column is pct_list_sold and with a data type of Decimal(7,3).

So numbers in the cell are, as an example, 0.945665, 0.944905, 0.943350 and hence, displays as 0.950, 0.950 and .943

I am trying to format the numbers in PHP to 95%, 95% and 94% with the following:

<td style="text-align: right;"><?php echo round($row['$pct_list_sold'] * 100) . '%';?></td>

All the cells return a display of 0%.

I also tried the following from an example in a post here that returned an error:

<td style="text-align: right;"><?php echo round($row['$pct_list_sold'] * 100), . '%' ?></td>

edited Apr 18 '16 at 01:48

asked Apr 18 '16 at 01:31

Dan O'Shea

try http://www.w3schools.com/php/func_string_sprintf.asp it is more flexible – daremachine Apr 18 '16 at 01:36
and in round you need second parameter "precision" http://php.net/manual/en/function.round.php – daremachine Apr 18 '16 at 01:41
Nothing in the sprintf link gives a return of a % number. – Dan O'Shea Apr 18 '16 at 01:59
Precision is optional, and has nothing to do with wanting to format a decimal data type to % in PHP. – Dan O'Shea Apr 18 '16 at 02:00
I tried sprintf and even though it is reformatted, I get 0.00% in all cells. – Dan O'Shea Apr 18 '16 at 02:17
sorry i dont fully understand your question? you have number 0.944905 and you want it display as 94%? So whats problem is use ??? – daremachine Apr 18 '16 at 02:34
or – daremachine Apr 18 '16 at 02:40
Yes, I was looking for this "%.2f%% is what I was looking for. http://stackoverflow.com/questions/14525393/format-percentage-using-php. But you helped me figure it out and I thank you. Below was my final code that worked. Thanks again. echo sprintf("%.2f%%", $row['pct_list_sold'] * 100) – Dan O'Shea Apr 18 '16 at 03:15

0 Answers0