add.php文件中:<form action="add.php" method="post" >
用户:<input type="text" name="user" size=10/><br>
标题:<input type="text" name="title" /><br>
内容:<textarea name="content"/></textarea><br>
<input type="submit" name="submit" value="发表留言啦"/>
</form>
<?php
include("connect.php");
if($_post['submit']){
$sql="insert into message (id,user,title,content,lastdate)values('',$_post[user],$_post[title],$_post[content],now()";
//$result=mysql_query($sql,$a)or die (mysql_error());
mysql_query($sql);
echo "succeed!";
}else{
echo "failed!";
}?>connect.php文件中:
<?php
$a= @ mysql_connect("localhost","root","")or die ("连接错误");
mysql_select_db("newdb",$a);
mysql_query("set names 'GBK'"); //用GBK中文编码
?>
为什么留言版不能提交数据到数据库newdb中呢?而且一开始还未在表单里写内容就出现了“failed!”谢谢解答!!!
用户:<input type="text" name="user" size=10/><br>
标题:<input type="text" name="title" /><br>
内容:<textarea name="content"/></textarea><br>
<input type="submit" name="submit" value="发表留言啦"/>
</form>
<?php
include("connect.php");
if($_post['submit']){
$sql="insert into message (id,user,title,content,lastdate)values('',$_post[user],$_post[title],$_post[content],now()";
//$result=mysql_query($sql,$a)or die (mysql_error());
mysql_query($sql);
echo "succeed!";
}else{
echo "failed!";
}?>connect.php文件中:
<?php
$a= @ mysql_connect("localhost","root","")or die ("连接错误");
mysql_select_db("newdb",$a);
mysql_query("set names 'GBK'"); //用GBK中文编码
?>
为什么留言版不能提交数据到数据库newdb中呢?而且一开始还未在表单里写内容就出现了“failed!”谢谢解答!!!
if($_post['submit']) $_POST要大写
-->if($_POST['submit'])2.sql语句错了.
=============================
$sql="insert into message (id,user,title,content,lastdate)values('','{$_post['user']}','{$_post['title']}','{$_post['content']}',now())";
一眼扫下来就两个错误,lz再好好检查下。
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,now()' at line 1
你的sql 语句没加''
参考1楼所写的sql语句,把post 改成大写在试试
$sql="insert into message (id,user,title,content,lastdate)values('','$_POST[user]','$_POST[title]','$_POST[content]',now()";
$sql="insert into message (id,user,title,content,lastdate)values
('','{$_post['user']}','{$_post['title']}','{$_post['content']}',now())";
('','{$_POST['user']}','{$_POST['title']}','{$_POST['content']}',now())";
if($_POST['submit']){
$sql="insert into message(id,user,title,content,lastdate)values" .
"('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
mysql_query($sql);
echo "succeed!";
}else{
echo "failed!";
}
echo $sql="insert into message(id,user,title,content,lastdate)values" .
"('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
/*mysql_query($sql);
echo "succeed!";
}else{
echo "failed!"; */
}
这样可以判定是否能接受post过来的内容了