PHP + Mysql 插入数据问题
代码如下
<?php
$con = mysql_connect('localhost', 'root', 'password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dbtravel", $con);
$sql="INSERT INTO dbform
VALUES
('$_POST[firstname]','$_POST[middlename]','$_POST[lastname]','$_POST[street]','$_POST[city]','$_POST[country]','$_POST[zipcode]','$_POST[telephone]','$_POST[mobile]','$_POST[email]','$_POST[url]','$_POST[comments]','$_POST[newsopt]',curdate(),now());";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
执行插入错误代码如下:
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 ','ccc','garden','beijing','china','730107','12931028','19283091283','opopo' at line 3