Question

php 留言板 写入不到数据库

<?
if( isset($_POST["Submit"]) ){
include('houtai/conn.php');
echo $sql = "insert into huiyuan (liuyanbiaoti,gongsimingcheng,lianxiren,lianxidianhua,lianxidizhi,email,neirong)
values('$_POST[lybt]' , '$_POST[gsmc]' , '$_POST[lxr]' , $_POST[lxdh] , '$_POST[lxdz]', '$_POST[em]', '$_POST[nr]')";
//执行SQL语句
mysql_query($sql,$conn);
//跳转到列表
header("Location:message.php");
break;
}
?>

Answer 1

post获取变量，应写为：$_POST['key']或$_POST["key"]
数据库insert 语句中，插入一个值的写法为：values('value')，在php中对应的写法为: values("'".$_POST['key']."'")

Answer 2

<?
include('houtai/conn.php');
if( isset($_POST["Submit"]) ){$sql = "insert into huiyuan (liuyanbiaoti,gongsimingcheng,lianxiren,lianxidianhua,lianxidizhi,email,neirong)
values('$_POST[lybt]' , '$_POST[gsmc]' , '$_POST[lxr]' , $_POST[lxdh] , '$_POST[lxdz]', '$_POST[em]', '$_POST[nr]')";
mysql_query($sql);
//跳转到列表
header("Location:message.php");
break;
}
?>

Answer 3

把id也放入sql语句试试看

Answer 4

数据库连接对吗