insert.php:
<?php
$connect=mysql_connect("localhost","lzj","");
mysql_select_db("web_db");
$subject=$_POST["subject"];
$author=$_POST["author"];
$email=$_POST["email"];
$contents=$_POST["contents"];
$date=date("Y-m-d H:i:s");
$query="insert into guestbook values(,'$subject','$author','$email','$date','$contents')";
mysql_query($query);
?>
<?php
$connect=mysql_connect("localhost","lzj","");
mysql_select_db("web_db");
$subject=$_POST["subject"];
$author=$_POST["author"];
$email=$_POST["email"];
$contents=$_POST["contents"];
$date=date("Y-m-d H:i:s");
$query="insert into guestbook values(,'$subject','$author','$email','$date','$contents')";
mysql_query($query);
?>
mysql> grant select,insert on guestbook to lzj@localhost;
Query OK, 0 rows affected (0.17 sec)
$query="insert into guestbook(字段名……) values(,'$subject','$author','$email','$date','$contents')";
mysql_query($query);看看是不是这个问题。。
??????
什么问题?
是打错了吧!!
$query="insert into guestbook values(NULL,'$subject','$author','$email','$date','$contents')";
µÚ¶þ²½¼ì²é¸÷ÏîÊÇ·ñÓÐÖµÒÔ±ã½øÐвåÈë¡£
µÚÈýÄãµÄÊý¾Ý¿â±íÖÐÊÇ·ñ¸÷×Ö¶ÎÔÊÐí¿ÕÖµ´æÔÚinsert.php:¸Ä³ÉÏÂÃæµÄ¿´¿´£º
<?php
$connect=mysql_connect("localhost","lzj","")or die("Êý¾Ý¿âÁ¬½Ó´íÎó".mysql_error());
mysql_select_db("web_db",$connect)or die("ÎÞ·¨Ñ¡ÔñÊý¾Ý¿â".mysql_error());
$subject=$_POST["subject"];
$author=$_POST["author"];
$email=$_POST["email"];
$contents=$_POST["contents"];
$date=date("Y-m-d H:i:s");
echo $subject;
echo $author;
echo $email;
echo $contents;
//¿´¿´ÒÔÉϸ÷ÏîÓÐûÓÐÖµ¡£
if(!isempty($subject)&&!isempty($author)&&!isempty($email)&&!isempty($contents)&&!isempty($date)){
$query="insert into guestbook values(,'$subject','$author','$email','$date','$contents')";
mysql_query($query);
}
else
{
echo "Êý¾Ý²ÎÊý´íÎó";
exit;
}
?>
-------------------------------------
不是
query="insert into guestbook values(,'$subject','$author','$email','$date','$contents')";改为:
$query="insert into guestbook (subject,author,email,date,contents) values('$subject','$author','$email','$date','$contents')";就行了,
谢谢
$query="insert into guestbook (subject,author,email,date,contents) values('$subject','$author','$email','$date','$contents')";
mysql_query($query);
也许你的字段名不是这样的,你自己按对应改一下
第一步检查数据库连接是否成功.
第二检查数据库的选择是否成功.
第三步检查数据库中是否允许插入空值.
第四步检查如果在不允许空值的情况下是否出现了空值.
所以程序改成如下的试试看:
<?php
$connect=mysql_connect("localhost","lzj","")or die("无法连接数据库".mysql_error());
mysql_select_db("web_db",$connect)or die("无法选择数据库".mysql_error());
$subject=$_POST["subject"];
$author=$_POST["author"];
$email=$_POST["email"];
$contents=$_POST["contents"];
$date=date("Y-m-d H:i:s");
echo $subject;
echo $author;
echo $email;
echo $contents;//看看以上各荐是否有值
if(!isempty($subject)&&!isempty($author)&&!isempty($email)&&!isempty($contents)&&!isempty($date)){
$query="insert into guestbook values(,'$subject','$author','$email','$date','$contents')";
mysql_query($query);
}
else
{
echo "存在空值或者其它参数错误.";
exit;
}
?>