php无法写入,写入错误

来源:百度知道 编辑:UC知道 时间:2024/09/22 03:10:59
错误提示:
注册用户失败: 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 'user(name,password,email,tel,address) values('小红','c4ca4238a0

代码
<?php
//初始化session
session_start();
// 包含数据库连接文件和头文件
require ('dbconnect.php');
include ('head.php');
?>
<?php
// 取得网页的参数
$name=$_POST['name'];
$password=$_POST['password'];
$email=$_POST['email'];
$tel=$_POST['tel'];
$address=$_POST['address'];

// 加密密码
$password=md5($password);

// 连接数据库,注册用户
$sql="insert into user(name,password,email,tel,address) values('$name','$password','$email','$tel','$address')";
mysql_query($sql,$conn) or die ("注册用户失败: ".mysql_error());

// 获得注册用户的自动id,以后使用此id才可登录
$result=mysql

不是说sql语句有语法错误吗,要仔细检查一下才行,
光看你提供的资料看不出来,你看表的结构啊那些等等。

$sql="insert into user(name,`password`,email,tel,address) values('$name','$password','$email','$tel','$address')";

`password` 要加`号,因为password是mysql的函数,`可以转义它
建议书写格式:
$sql="insert into user(`name`,`password`,`email`,`tel`,`address`) values('{$name}','{$password}','{$email}','{$tel}','{$address}')";

sql语法出错,应该是这条有错$result=mysql_query("select last_insert_id()",$conn);
改$result=mysql_query("select last_insert_id from user",$conn);

$sql="insert into user(name,password,email,tel,address) values('$name','$password','$email','$tel','$address')";
改成:
$sql="insert into user values('$name','$password','$email','$tel','$address')";
如果'$name'前面有id,那么就: