PHP/Mysql division returns a float with "comma", How to return result with a "point"

Question

Please I have to made a small calculus using mysqli and php, and to return a float or a double value, so I've tried :

$notes = mysclass_sql::query("SELECT SUM(commentsNote) / COUNT(*) as c
                        FROM comments ")->fetch_object()->c;
return round( $notes , 2) ;

But this returns me a value like this 1,25 and not 1.25 even if I try using str_replace !!

I can't get out from this, please masters any help ?

http://stackoverflow.com/questions/8669212/change-decimal-separator-in-mysql — revoua, Feb 08 '13 at 22:47
On a side note, why not just use `AVG()` instead of `SUM()/COUNT(*)`? — Mr. Llama, Feb 08 '13 at 22:48
@GigaWatt will those give the same result if there are some null values for the commentsNote field? I don't know offhand, but that's probably why I'd do something like this. — octern, Feb 08 '13 at 22:53

score 0 · Accepted Answer · answered Feb 08 '13 at 22:45

0

You want to use number_format().

$notes = mysclass_sql::query("SELECT SUM(commentsNote) / COUNT(*) as c
                    FROM comments ")->fetch_object()->c;
return(number_format($notes, 2, ".", ""));

fyi, this is the first hit if you google "php comma decimal".

answered Feb 08 '13 at 22:45

octern

4,825
21
38

You shouldn't have to do this if the locale is set correctly. – dqhendricks Feb 08 '13 at 22:58

Sam Dufel · Answer 2 · 2013-02-08T22:54:56.507

0

You can try setting the locale -

setlocale (LC_ALL, "en-US");  // or "en_US", etc, depending on your server

edited Feb 08 '13 at 22:54

answered Feb 08 '13 at 22:46

Sam Dufel

17,560
3
48
51

On my system, `en-US` doesn't work but `en_US` does (and similarly for other locale strings). – octern Feb 08 '13 at 22:50
This answer makes a lot more sense than mine if you want to print all numbers in the new format. My answer is appropriate if you want to format only some specific numbers. – octern Feb 08 '13 at 22:51
*shrug, it depends on the OS. – Sam Dufel Feb 08 '13 at 22:53

PHP/Mysql division returns a float with "comma", How to return result with a "point"

2 Answers2