php使mysql显示错误_php维护MySQL数据库显示错误

$host='localhost';

$user_name='root';

$password='';

$name=$_POST['user_name'];

$city=$_POST['city'];

if(empty($name) || trim($name)=='')

{

echo '请填写用户名!返回';

exit;

}

$conn=mysql_connect($host,$user_name,$password);

if(!$conn)

{

die('数据库连接失败:'.mysql_error());

}

mysql_select_db('test');

$sql="insert into users set id=7,name'".$name."',city='".$city."',created_time=NOW()";

mysql_query($sql) OR die("
ERROR:".mysql_error()."
SQL:".$sql);

mysql_close($conn);

echo '数据插入成功，打开13-7.php查看数据';

?>

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 ''1',city='Beijing',created_time=NOW()' at line 1

SQL:insert into users set id=7,name'1',city='Beijing',created_time=NOW()

展开