cents not showing in money_format

dotty

Can anyone tell me why cents show as .00 while using the following code I found at PHP.net?

<?php
setlocale(LC_MONETARY, 'en_US');
echo money_format('%i', $row_cust['price']) . "\n";  

?>

:queasy:

devinemke

are you running this code on a Windows machine? if so, the money_format function does not exist. from the manual:

Note: The function money_format() is only defined if the system has strfmon capabilities. For example, Windows does not, so money_format() is undefined in Windows.

dotty

My PC is windows but the server is UNIX

I did see this

Note: The function money_format() is only defined if the system has strfmon capabilities. For example, Windows does not, so money_format() is undefined in Windows.

on the PHP.net site - but thought it was referring to the server machine.

57D
. My price is a variable named: $row_cust['price'] and the value comes from a hidden field with the following value <?php echo $row_cust['quantity']*7.50; ?> so when I used money_format the value for cents always showed as .00

I've just tried using

 echo sprintf('US %01.2f', $row_cust['price']);

and this did the same - showed the cents as .00

I'd imagine that having it pre-formatted in mySql would be ideal - if it is possible??

🙂

devinemke

Originally posted by dotty
My PC is windows but the server is UNIX

which machine are you running this code on? the windows machine or the unix machine?

dotty

Unix - I'm testing directly online

I'm beginning to think that my problem has something to do with my settings in mySql cos the unformatted price in the price field has no cents but the email responder, which takes the inputted info and sends it in a text email with no currency format, shows the cents.

The settings I have are - MEDIUMINT - length/values 9 default 0

dotty

I've solved it!

I had set the insert field to 'integer' so it was just entering the numbers before the decimal point. - And I realised that the parameters in mysql need to be DECIMAL :o

Thank you devinemke for your help!🙂