Conditional formatting of a float in PHP

Question

I'm retrieving a float value from a mysql database on a php page (2.5, 3.0 etc)

I would like to format this value so that if it is actually an integer, it should show zero decimal places. (it should output 3 instead of 3.0, but output 2.5 as 2.5)

What would be the simplest way to achieve this?

Answer 1

I would try something along the lines of:

echo (intval($v) == $v) ? intval($v) : $v;

But I wonder if there's a more efficient way.

Answer 2

You could also do the formatting in your query, it is likely to be faster than doing it in php especially if you have many rows to process.

Something like:

SELECT
    CASE 
     WHEN t.myColumn % 1 = 0 
      THEN FORMAT( t.myColumn, 0 ) 
      ELSE FORMAT( t.myColumn, 2 )
    END AS `formatted`
    ...
FROM myTable t
WHERE ...

The same method does apply for php if you want to do it outside the database:

$displayValue = $myValue % 1 == 0 
    ? number_format( $myValue, 0 ) 
    : number_format( $myValue, 2 );

Answer 3

You could also use a printf if you want to control the number of digits displayed to the right of the decimal point:

  if (intval($v) == $v) printf("%d", intval($v)); else printf("%0.2f", $v);