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

Question

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?

Answer 1

You can use number_format() function here.

$number = 18000;

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

Hope this helps.