Problem with value that contains comma

Question

Problem with value that contains comma

Navigation

#1 by (3 votes)

0

When you run this query:

mysqli_query($dbc, "insert into toons values(NULL, $toonId, '$toonName', $admin, '$dna', $bank, $money, $hp, '$inventory', $lastPlace)")

I get this error:

You have an error in your SQL syntax; check the manual that correspond to your MySQL server version for the right syntax to use near '' ',' ',' ',' 'at line 1

What's causing this?

php mysql

asked by anonymous 31.07.2015 / 21:59

1 answer

Translation of pages in php files HTTP Error 400 - "senderName invalid value" and "Must fit the patern: \ d +. \ d {2} 2"

score 3 · Answer 1

Database only accepts decimal places with . (period). If you are passing 1,99 on the money variable it is likely to give you problem not only in the bank. Uses a replace in the variable from , to . .

mysqli_query($dbc, "insert into toons values(NULL, $toonId, '$toonName', $admin, '$dna', $bank, str_replace(",", ".", $money), $hp, '$inventory', $lastPlace)")