Menu
Community /Pin to ProfileBookmark
@NogDogApr 08.2013 — #
Moving up to either the MySQL[b]i[/b] extension or the PDO extension (instead of using the deprecated MySQL extension) can help you avoid that sort of problem by making use of prepared statements. It also automatically takes care of any escaping.
Parse Error Inserting IP on the datae base
Why do I get this parse error message when I try to insert an ip into the data base.
[QUOTE]
Parse error: syntax error, unexpected T_DNUMBER
Below is my code
[code=php]
$ip2=219.90.90.2;
$ip2=mysql_real_escape_string($ip2);
mysql_query(“INSERT INTO table_name(ip_string)
VALUES($ip2)”);
Now if I try to put single or double quote like this
[code=php] $ip2=’219.90.90.2′
the error will be gone, but it will not insert into the data base
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogApr 08.2013 — #Ok I solve it I put a quote in my sql statement. Sometimes I am really forget full of these syntax/rules..[/QUOTE]
Moving up to either the MySQL[b]i[/b] extension or the PDO extension (instead of using the deprecated MySQL extension) can help you avoid that sort of problem by making use of prepared statements. It also automatically takes care of any escaping.
[code=php]
$sql = "INSERT INTO table_name(ip_string) VALUES(?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('s', $ip2); // handles all quoting/escaping issues for you
$stmt->execute();
[/code]