Question

mysql无法写入数据

$conn=mysql_connect("localhost","root","")or die("数据库打开错误");
mysql_select_db("bbs",$conn)or die("数据库连接错误");
mysql_query("set names 'GBK'");
--------------------------------------------

include("conn.php");
if($_POST['submit']){

$sql="INSERT INTO yizhuren (id,user,title,content,lastdate) " .
"values('id','$_POST[user]','$_POST[title]','$_POST[content]'now())";
mysql_query($sql);
echo "发布成功";
}
?>
<form action="add.php" method="post">

用户:<input type="text" sise="10" name="user" /><br>
标题:<input type="text" name="title" /><br/>
内容:
<textarea name="content">
</textarea><br/>
<input type="submit" name="submit" value="发布留言"/>
网页显示发布成功,但数据库里没有数据

Answer 1

你的
$sql="INSERT INTO yizhuren (id,user,title,content,lastdate) " .
"values('id','$_POST[user]','$_POST[title]','$_POST[content]'now())";
这句不对
应该这样
$user = $_POST[user];
$title = $_POST[title];
$content = $_POST[content];
$now = now();
$sql="INSERT INTO yizhuren (id,user,title,content,lastdate) values('id','$user','$title','$content','$now')";