Menu
Community /Pin to ProfileBookmark
@NogDogMar 16.2010 — #The key here is that if the MySQL column is defined as a float or decimal type, you [i]must[/i] use the "." (period/full stop) character as the decimal separator, not the "," (comma) in your SQL. If you want to allow the user to input numbers using the comma, then you will need to convert it to a period before using it in your query.@NogDogMar 16.2010 — #
In cases where the user enters something like "1234,56" that should be fine. However, what if the user enters "1,234.56" or "12,345,678" or "12.345,6". (Thus the problem with different standards around the world. :rolleyes: )
Decimal number is recognized as whole number
Hello
I have a small problem. I have an input box on one page that posts a number into an int table/row in a mysql database. But if i for instance enter 0,50 the number becomes 0 in the database.
I have tried with (int) before the variable, or intval/floatval etc, but i cannot seem to get the number correct. Please help
Sign in
to post a comment8 Comments(s) ↴
0
@NogDogMar 16.2010 — #The key here is that if the MySQL column is defined as a float or decimal type, you [i]must[/i] use the "." (period/full stop) character as the decimal separator, not the "," (comma) in your SQL. If you want to allow the user to input numbers using the comma, then you will need to convert it to a period before using it in your query.0
@NogDogMar 16.2010 — #So should this be correct and working:
[CODE]$amount = (int) str_replace(',','.', $data['amount']);[/CODE][/QUOTE]
In cases where the user enters something like "1234,56" that should be fine. However, what if the user enters "1,234.56" or "12,345,678" or "12.345,6". (Thus the problem with different standards around the world. :rolleyes: )