PHP数据通过SQL传输一直传输不成功

Question

$sql="INSERT INTO account2(id, username, password, email, province, city, district) VALUES ('null','$username','$password','$email','$province','$city','$district')";初学者，想问一下这个存在什么问题吗，数据一直传不到数据库，而把'null','$username','$password','$email','$province','$city','$district'改成常数后又可以？

Answer 1

题主打印下sql语句放到Navicat执行看看报什么具体错误。如果id值自增字段，应该是设置为null，而不是字符串'null'

$sql="INSERT INTO account2(id, username, password, email, province, city, district) VALUES ('null','$username','$password','$email','$province','$city','$district')";
die($sql);//

特别字符串值，如果内容包含引号会导致sql语句出错，要注意转义，一个单引号变2个
https://blog.csdn.net/czh500/article/details/90721286