php only show decimal place if have fraction

Question

I set int data type in mysql database but it not showing decimal place like 10.20 Then I set decimal(10,5) it show five decimal place with all number thought it not necessary like 10.00000. I want to show decimal places only if have fraction like 10.25455 = 10.25455 and 10 = 10 but it showing 10 = 10.00000 how to solve this

Answer 1

You can use PHP round function.

http://php.net/manual/en/function.round.php

PHP Code:

<?php 
 echo round(10.25455, 5); // outputs: 10.25455
 echo '<br/>';
 echo round(10.00000, 5); // outputs: 10

Answer 2

Just add 0!

echo 10.25455 + 0;
echo 10.00000 + 0;

Output:

10.25455
10

Answer 3

Use decimal as a field type. Then in PHP use round(); function.

Answer 4

There is no datatype in mysql that supports your requirement. In fact, that is not how computers work. A number is either an int or a float.

You might want to use varchar instead, and cast to the right data type in php, but it might cause performance overhead. It is indeed a weird data type requirement. If you must go this route, consider adding an extra column for flagging data type.

Answer 5

echo floatval($value);

will do the trick.