如何将18000变为18,000.00作为输出？ Mysql和php

I have data 18000 in my database and the datatype is decimal but the length of decimal is empty. How do I make it into 18,000.00 as an output?

You can use number_format() function here.

$number = 18000;

$formatted_number = number_format($number, 2, '.', ','); // Gives 18,000.00

Hope this helps.

Try FORMAT function in mysql.

Query

SELECT FORMAT(18000, 2);

Result

18,000.00