php自治简单留言板代码
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if(@$_POST["ok"])
{
mysql_select_db("xiaolie");
//插入数据
$shuju = " insert into hao (name,neirong,shijian) values ('".$_POST["name"]."','".$_POST["neirong"]."','".date("Y-m-d H:m:s")."')";
$fasong = mysql_query($shuju) or die(mysql_error());
if($fasong)
{
header("location:/a2/ly.php");
}
else
{
echo "内容发表失败
返回";
}
}
else
{
/* mysql_select_db("xiaolie");
//发送查询
$fasong = mysql_query("select * from hao") or die(mysql_error());
while($nr = mysql_fetch_array($fasong))
{
echo "
第 ".$nr["id"]." 楼 | 发表用户:".$nr["name"]." | 发表时间:".$nr["shijian"]." |
".$nr["neirong"]." |
}
?>