使用PHP格式化数字

Question

I'm saving numbers in MySQL using double(10,2).

The numbers are getting saved like:

456.2

232.20

764

On output, I want to force 2 decimals and add the necessary trailing zeros (currency).

Here is the function I'm using and it isn't working.

function format_currency_form($get_money) {

    $money_output = abs(number_format($get_money, 2, '.', ''));

    return $money_output;
}

(I'm using ABS because I want the value to display as a positive number regardless of its true value in the db)

Here is the code block used to output the data:

<?php echo format_currency_form($row_rs_data['trans_amount']); ?>

No errors getting thrown and no trailing zeros...

Any ideas?

Thanks

Brett

Answer 1

If you are dealing with currency try to use moneyformat

http://php.net/manual/en/function.money-format.php

money_format('%.2n', $number)

In your case the abs should be done in this way:

$number=-11.44;
$money_output = money_format('%.2n', abs($number));
echo $money_output;

If you are dealing with currencies (I think so) money_format gives you a lot of options.