money_format

Description

money_format() returns a formatted version of
number. This function wraps the C library
function strfmon(), with the difference that
this implementation converts only one number at a time.

Parameters

format

The format specification consists of the following sequence:

a % character

optional flags

optional field width

optional left precision

optional right precision

a required conversion character

Flags

One or more of the optional flags below can be used:

=f

The character = followed by a (single byte)
character f to be used as the numeric fill
character. The default fill character is space.

^

Disable the use of grouping characters (as defined
by the current locale).

+ or (

Specify the formatting style for positive and negative numbers.
If + is used, the locale's equivalent for
+ and - will be used. If
( is used, negative amounts are enclosed in
parenthesis. If no specification is given, the default is
+.

!

Suppress the currency symbol from the output string.

-

If present, it will make all fields left-justified (padded to the
right), as opposed to the default which is for the fields to be
right-justified (padded to the left).

Field width

w

A decimal digit string specifying a minimum field width. Field will
be right-justified unless the flag - is used.
Default value is 0 (zero).

Left precision

#n

The maximum number of digits (n) expected
to the left of the decimal character (e.g. the decimal point). It is
used usually to keep formatted output aligned in the same columns,
using the fill character if the number of digits is less than
n. If the number of actual digits is
bigger than n, then this specification is
ignored.

If grouping has not been suppressed using the ^
flag, grouping separators will be inserted before the fill
characters (if any) are added. Grouping separators will not be
applied to fill characters, even if the fill character is a digit.

To ensure alignment, any characters appearing before or after the
number in the formatted output such as currency or sign symbols are
padded as necessary with space characters to make their positive and
negative formats an equal length.

Right precision

.p

A period followed by the number of digits
(p) after the decimal character. If the
value of p is 0 (zero), the decimal
character and the digits to its right will be omitted. If no right
precision is included, the default will dictated by the current
local in use. The amount being formatted is rounded to the specified
number of digits prior to formatting.

Conversion characters

i

The number is formatted according to the locale's international
currency format (e.g. for the USA locale: USD 1,234.56).

n

The number is formatted according to the locale's national
currency format (e.g. for the de_DE locale: EU1.234,56).

%

Returns the % character.

number

The number to be formatted.

Return Values

Returns the formatted string. Characters before and after the formatting
string will be returned unchanged.
Non-numeric number causes returning NULL and
emitting E_WARNING.

Notes

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.

Note:

The LC_MONETARY category of the locale settings,
affects the behavior of this function. Use setlocale()
to set to the appropriate default locale before using this function.

Examples

Example #1 money_format() Example

We will use different locales and format specifications to
illustrate the use of this function.

// US national format, using () for negative numbers// and 10 digits for left precisionsetlocale(LC_MONETARY, 'en_US');echo money_format('%(#10n', $number) . "\n";// ($ 1,234.57)

// Similar format as above, adding the use of 2 digits of right// precision and '*' as a fill characterecho money_format('%=*(#10.2n', $number) . "\n";// ($********1,234.57)

// Let's justify to the left, with 14 positions of width, 8 digits of// left precision, 2 of right precision, withouth grouping character// and using the international format for the de_DE locale.setlocale(LC_MONETARY, 'de_DE');echo money_format('%=*^-14#8.2i', 1234.56) . "\n";// Eu 1234,56****

// Let's add some blurb before and after the conversion specificationsetlocale(LC_MONETARY, 'en_GB');$fmt = 'The final value is %i (after a 10%% discount)';echo money_format($fmt, 1234.56) . "\n";// The final value is GBP 1,234.56 (after a 10% discount)

In Rafael M. Salvioni function localeconv(); returns an invalid array in my Windows XP SP3 running PHP 5.4.13 so to prevent the Warning Message: implode(): Invalid arguments passed i just add the $locale manually. For other languages just fill the array with the correct settings.

return $currency.$thecash.".00"; // writes the final format where $currency is the currency symbol.
}
?>

now call the function as convertcash($row['price'], 'Rs '); // that's the price from the database I called using an Indian Rupees prefix where the price has to be a plain number format, say something like 454234.

Double check that money_format() is defined on any version of PHP you plan your code to run on. You might be surprised.

For example, it worked on my Linux box where I code, but not on servers running BSD 4.11 variants. (This is presumably because strfmon is not defined - see note at the top of teis page). It's not just a windows/unix issue.

Improvement to Rafael M. Salvioni's solution for money_format on Windows: when no currency symbol is selected, in the formatting, the minus sign was also lost when the locale puts it in position 3 or 4. Changed $currency = ''; to: $currency = $cprefix .$csuffix;

This is a handy little bit of code I just wrote, as I was not able to find anything else suitable for my situation.
This will handle monetary values that are passed to the script by a user, to reformat any comma use so that it is not broken when it passes through an input validation system that checks for a float.

It is not foolproof, but will handle the common input as most users would input it, such as 1,234,567 (outputs 1234567) or 1,234.00 (outputs 1234.00), even handles 12,34 (outputs 12.34), I expect it would work with negative numbers, but have not tested it, as it is not used for that in my situation.

This worked when other options such as money_format() were not suitable or possible.

$first = strlen($bits[0]); // gets part before first comma (thousands/millions)
$last = strlen($bits[1]); // gets part after first comma (thousands (or decimals if incorrectly used by user)

if ($last <3){ // checks for comma being used as decimal place
$convertnum = str_replace(",",".",$convertnum);
}
else{ // assume comma is a thousands seperator, so remove it
$convertnum = str_replace(",","",$convertnum);
}

$_POST[$fieldinput] = $convertnum; // redefine the vlaue of the variable, to be the new corrected one
}