Question

php 不能插入数据到数据库是什么原因?

<?php
$user=$_post['user'];
$title=$_post['title'];
$content=$_post['content'];
if(!get_magic_quotes_gpc){
$user=addslashes($user);
$title=addslashes($title);
$content=addslashes($content);}
$conn=new mysqli("localhost","root","cs64191230","demon");
if(mysqli_connect_errno()){
echo 'ERROR:Could not connect to database'.mysqli_connect_error();
exit;}
$query="INSERT INTO message ( `id` ,`user`, `title` ,`content`,`lastdate`) VALUES ('', '$user','$title', '$content','now()')" ;
$result=$conn->query($query);
if($result){
echo $db->affected_rows."数据发布成功.";}
else
{
echo "ANnerror has occurred";
}
$conn->close();
?>

Answer 1

这一句：$query="INSERT INTO message ( `id` ,`user`, `title` ,`content`,`lastdate`) VALUES ('', '$user','$title', '$content','now()')" ;

ID如果设置的是自动增加的 ，那么就无需指定id 了，改为
$query="INSERT INTO message ( `user`, `title` ,`content`,`lastdate`) VALUES ('$user','$title', '$content','now()')" ;

Answer 2

楼上正解！