[RESOLVED] Format currency from access db

[mark_kccs]

Hi all

I have an access db with a currency field formatted as R100.00, R99.99 etc
(R = Rand, South Africa). When I pull the data into PHP R100.00 shows as 100 and R99.99 shows as 99.99. I need to keep the zero's after the decimal point and eventually format all values as 00000010000 or 00000009999 to send to a file which must have a grand total of all values. When I use gettype on this variable it tells me that it is an object type. I have tried using settype to see if i can use it as a string or integer with no luck. The formating for the 100 is ok as i multiply the values by 100 and then use str_pad but with 99.99 this rounds up the end result. All I can think of is to add an "IF" statement after the variable has been set to test for a decimal point and format to get what I need. Any suggestions most welcomed

Thanks

[Drakla]

How about something like this

$nums = array(100, 99.99);

foreach ($nums as $num)
{
	$num = number_format($num, 2, '', '');
	echo $num . '<br />';

$num = str_pad($num, 10, '0', STR_PAD_LEFT);
echo $num . '<br />';
}

[Roger_Ramjet]

OK, Access stores currency data types with 4 decimal places and that was a pain when importing into mysql. The solution I use when uploading currency values from access to mysql is to cast the data to a string when exporting from access, use Cstr(field) in your Access export query for that. I loose trailing zeros that way but that is OK as I store them in decimal field specified with 2 decimal places. Mysql will cast the string to a decimal data type on import and replace the decimal places. So far so good.

The problem then arises that trailing zeros are again lost when displayed in html via php. To get around that you need to use number format() , or you can use money format() if it applies: all same currency and you control the server settings for the local currency. Personally I just use number_format() to make my code independent of server settings because my stuff is multi-currency, and I also don't want to have to rely on server settings or re-write code if I move. I prepend the currency symbol for display, again because mine is multi-currency.

[mark_kccs]

Thanks Drakla, worked like a dream and thanks also Roger