Question

php 连接 mysql 的插入语句报错

mysql_query("INSERT INTO student_card (name,number,phone,qq,email) VALUES ('$_POST[name]','$_POST[number]','$_POST[phone]','$_POST[qq]','$_POST[email]'") or die(mysql_error());
这是原语句
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
这是报错语句

insert into student_card (name,number,phone,qq,email) values ("中文",2,4,4,5);
这是手动输入,成功.

Answer 1

最后面少了一个)括号

mysql_query("INSERT INTO student_card (name,number,phone,qq,email) VALUES ('$_POST[name]','$_POST[number]','$_POST[phone]','$_POST[qq]','$_POST[email]')") or die(mysql_error());

追问

已经哭瞎了，，，，，果然复制粘贴不可靠 以后都要手打 血的教训啊
谢拉兄弟