MySQL中的货币格式

Question

I am pretty new to all of this and I couldn't find an answer worded this way when searching. I have a database with currency in it, in mysql it doesn't allow me to format the field to be in currency. Is there a way in PHP to format the field to format the text into a currency format so it looked like $5,250,000 instead of 5250000.

Print "<td><center>".$row['ContractM']."</centre></td> ";}

Above is the line that I want to be in currency format, how would I go about formatting it?

Thanks for your help.

Answer 1

Here. You can do this:

$unitcost=number_format($row['ContractM']); /* Format Number */

Print "<td><center>$ ".$unitcost."</centre></td> "; /* Echo result */

If you want to include cents (two decimal places after the whole number):

$unitcost=number_format($row['ContractM'],2); /* Format Number with decimal point */

Print "<td><center>$ ".$unitcost."</centre></td> "; /* Echo result */

Better also if you declare your ContractM row in your table as INT or DOUBLE.