php操作MySQL的简单HTML表单

php操作MySQL的简单HTML表单

$db=mysql_connect("localhost", "root", "") or
die ("sorry,unable to connect to database");
//连接数据库
mysql_select_db("test",$db)or die ("unable to select database");
//选择数据库
?>
if($_POST['submit']=="输入信息"){
$name = $_POST['name'];
$address = $_POST['address'];
$position = $_POST['position'];
if($_POST['name']==""||$_POST['address']==""||$_POST['position']==""){
echo " 添加失败，请把信息填写完整
";
}else{
$sql="INSERT INTO employees (name,address,position) VALUES ('$name','$address','$position')";
//向数据库发出 SQL 命令
$result=mysql_query($sql);
echo "记录插入成功！!
";
}
}
?>


你复制回去试试。

把这段代码INSERT INTO employees (name,address,position)
VALUES ('VALUES ('$name','$address','$position')";
连接符号漏了中间用.连接

提示什麼错误信息？
$sql="INSERT INTO employees (name,address,position)
VALUES ('$name','$address','$position')";
改成这样试试
$sql="INSERT INTO employees (name,address,position)
VALUES ('".$name."','".$address."','".$position."')";

$sql="INSERT INTO employees (name,address,position)
VALUES ('$name','$address','$position')";
==>
$sql="
INSERT INTO `employees` (`name`,`address`,`position`)
VALUES ('{$name}','{$address}','{$position}')
";