[RESOLVED] Formatting variable in PHP

[AJArmstron]

Hello. I am programming using PHP and MySQL.

In my database I have a field formatted decimal(5,2) for money (e.g. £4.95).

In php I have made a variable $total to store a total value. However, this $total variable is formatted so £9 is displayed as 9 when I want it to be displayed as 9.00.

Can anyone please tell me how to format the variable?

Many thanks.

[halojoy]

There is a special function for this.
[man]number_format[/man]
There are option for how many decimals, period/comma seperator etc.

example

<?php

$num = 9;

// format with two decimals:  9.00
$formatted = number_format($num, 2);

echo $formatted; //  9.00

?>

[bradgrafelman]

Since this is money, you could also use [man]money_format[/man] instead:

<?php
$amnt = 9.00; // decimal amount retrieved from DB

setlocale(LC_MONETARY, 'en_GB'); // set the locale in case it wasn't already set

echo money_format('%n', $amnt); // outputs: £9.00
?>