Reputation: 18103
So i have some fields coming from the form. Here you can type 0.3 and it will insert 0.3 in to the database. Do you type 0,3 it will just insert "0".
$product['protein']; // 0,3
So to this above how can i replace a comma with a dot ?
Upvotes: 19
Views: 62072
Reputation: 29
$product['protein'] = str_replace(',', '.', str_replace('.', '', $product['protein']));
Upvotes: 2
Reputation: 50976
Try PHP's function str_replace():
$product['protein'] = str_replace(',', '.', $product['protein']);
Which should be a good fit.
You could think to use number_format():
number_format($value, $numberOfDecimals, $charaForDecimalPoint, $charForThousandsSeparator)
but in your case it wouldn't apply, due to the fact that your starting value ("0,3") wouldn't be recognized as a number. In fact, the decimal point for a numeric value must be a dot(".").
Use number_format only if your starting value is a true number.
Upvotes: 53
Reputation: 365
$product['protein'] = str_replace(",",".",$product['protein'])
For more info on the str_replace function visit: http://uk.php.net/str_replace
Upvotes: 5