Adrian P. Adrian P. - 4 months ago 25
SQL Question

PHP number_format returns 1.00

I have stored in MySQL the number as total(decimal 16,2) 1423.28

I get it display from PHP after making some calculations:

function calculate_balance($total){

//get total paid from another function
$total_paid = ...

if ($total_paid == 0){
return $total;
}else{
return $total-$total_paid
}

}

$balance = calculate_balance($total);
echo number_format($balance, 2); //returns 1.00


I have tried

number_format((float)$balance, 2);
number_format(floatval($balance), 2);


UPDATE

var_dump($balance)


and I got following output.

string(8) "1,423.28" float(152) string(6) "252.00" string(6) "247.50" string(6) "247.50" string(6) "247.50" string(6) "549.90" string(6) "495.00" float(0) string(6) "284.76" float(265)


It's working fine without
number_format()
for value under 1,000.
E.g.: if balance equal 252.00

echo $balance;


output

252.00

Answer

Your function returns 1,423.28? This is not a float, as a float does never contain a comma as a thousands-separator.

PHP interprets this as 1, because it "breaks" at the comma.

Remove the comma and you are fine!

$balance = str_replace(',', '', $balance);