Question

PHP写入MySQL时候语法总是错误

使用PHP往数据库写东西，总是报错，错误如下：
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 '17-31-27)' at line 2

PHP代码如下：
$sql = "INSERT INTO users (userId, password, gender, regDate) VALUES
($userId, $pass_md5, $gender, $date)";

但是如果排除变量，硬写入数据，就没问题，PHP代码如下：
$sql = "INSERT INTO users (userId, password, gender, regDate) VALUES
('test1', '202cb962ac59075b964b07152d234b70', 'male', '2012-04-24 17-23-03')";
请问是为什么？

补充：我在用变量写入数据库之前，已经用echo把每个变量的值都显示了一遍，都不是空，把这些值直接放在SQL语句里就能写到数据库，很奇怪。

Answer 1

因为你的变量没加单引号，正确的写法是$sql = "INSERT INTO users (userId, password, gender, regDate) VALUES
(‘$userId’, '$pass_md5’, '$gender’, '$date’)";

Answer 2

因为你的变量没加单引号，正确的写法是$sql = "INSERT INTO users (userId, password, gender, regDate) VALUES
('".$userId."', '".$pass_md5."', '".$gender."', '".$date."')";
要写严格点

Answer 3

因为你的变量没加单引号，正确的写法应该是$sql = "INSERT INTO users (userId, password, gender, regDate) VALUES (‘$userId’, '$pass_md5’, '$gender’, '$date’)"; 这样就OK了