插入之前对$query进行echo 一下,把其输出的语句放到sql环境下看看能不能正常插入对了query = "insert into board
(username,title,time,info,ip,pic)
values
('username','title','data','info','ip','pic')";
这句中的values部分如果是一些变量的话,要加上$username之类,并且要判定其值的正确性,最好把它echo 出来放到mysql环境下调试
(username,title,time,info,ip,pic)
values
('username','title','data','info','ip','pic')";
这句中的values部分如果是一些变量的话,要加上$username之类,并且要判定其值的正确性,最好把它echo 出来放到mysql环境下调试
$connid = @mysql_connect("localhost","","");
mysql_select_db("tennis",$connid);
$info = nl2br($info);
/*if($pic != "none")
{
$fp = fopen($pic,"r");
$data = addslashes(fread($fp,filesize($pic)));
}*/
$data = date("Y-m-d H:i:s");
$ip = $REMOTE_ADDR;
$query = "insert into board
(username,title,time,info,ip,pic)
values
('username','title','data','info','ip','pic')";
echo $query;exit;//把这句话显示出来,放到mysql环境下去执行 if(mysql_query($query))
{
echo "ok";
}
else
{
echo "bad";
}
?>
(username,title,time,info,ip,pic)
values
('$username','$title','$data','$info','$ip','$pic')";
楼主在变量前面没加$
都说了,你要加$符号,你光放个变量名有什么用?觉得楼主是初学PHP,是吗?
一共6个值,username,title,info,ip,pic这5个根本没有
赋值进去,当然不会有内容
<?
$connid = @mysql_connect("localhost","","");
mysql_select_db("tennis",$connid);
$info = nl2br($info);
$data = date("Y-m-d H:i:s");
$ip = $REMOTE_ADDR;
$query = "insert into board
(username,title,time,info,ip,pic)
values
('$username','$title','$data','$info','$ip','$pic')";
echo $query;
exit;
if(mysql_query($query))
{
echo "ok";
}
else
{
echo "bad";
}
?>
这是我表单的代码
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>werqwer</title>
<script language="JavaScript">
function check()
{
if(window.document.board.username.value =="")
{
alert("请输入用户名");
dodument.board.username.focus();
return false;
}
else
{
alert("请输入用户名1");
}
return true;
}
</script>
</head><body>
<p>用户名:
<input name="username" type="text" id="username" size="10" maxlength="100">
</p>
<p>密码:
<input name="passwd" type="text" id="passwd">
</p>
<p>标题:
<input name="title" type="text" id="title">
</p>
<p>内容:
<input name="info" type="text" id="info">
</p>
<p>图片:
<input name="picfile" type="text" id="picfile">
<input type="submit" name="Submit" value="浏览">
</p>
<form name="form1" method="post" action="board_insert.php">
<input type="submit" name="Submit2" value="提交" onClick="check()">
</form>
<p> </p>
</body>
</html>
<form name="form1" method="post" action="board_insert.php"> //要放到这里来
<p>用户名:
<input name="username" type="text" id="username" size="10" maxlength="100">
</p>
<p>密码:
<input name="passwd" type="text" id="passwd">
</p>
<p>标题:
<input name="title" type="text" id="title">
</p>
<p>内容:
<input name="info" type="text" id="info">
</p>
<p>图片:
<input name="picfile" type="text" id="picfile">
<input type="submit" name="Submit" value="浏览">
</p>
<form name="form1" method="post" action="board_insert.php"> //这句放的地方不对
<input type="submit" name="Submit2" value="提交" onClick="check()">
</form>
<p> </p>
</body>
</html>
然后这一句也要改$query = "insert into board
(username,title,time,info,ip,pic)
values
('$username','$title','$data','$info','$ip','$pic')";改成$query = "insert into board
(username,title,time,info,ip,pic)
values
('$_POST[username]','$_POST[title]','$_POST[data]','$_POST[info]','$_POST[ip]','$_POST[pic}')";
不过,将图片存入数据库,你这么做可能不行(我也没试过)