<?
include “signup/mysql.inc”;
if($id1){
$sql=”select * from $table where id=’$id1′”; //显示回复题目
$result=mysql_query($sql)or die(mysql_error());
$row=mysql_fetch_array($result);
$title=”RE:”.$row[“title”];
}
$ip=$REMOTE_ADDR;
$sql=”select * from user_stus where ip=’$ip'”; //查询当前用户名
$result=mysql_query($sql)or die(mysql_error());
$row=mysql_fetch_array($result);
if(!$row) //判断用户是否登陆
{
echo “
“;
echo”
“;
echo”
echo”
嘻嘻!! 请先登陆
“;
echo”
返回
“;
exit();
}
else $userid=$row[“userid”];
if($ok)
{
if($title==””||$content==””)
{
echo “
请您添完整后提交”;
}
else{
$id=time(); //提交文章
$date1=date(“Y/m/d”);
$title=htmlspecialchars($title);
$content=htmlspecialchars($content);
$sql=”select * from “.$table;
$result=mysql_query($sql)or die(mysql_error());
$row1=mysql_num_rows($result);
$row1++;
if($id1){
$sql=”insert into bbs_re (id,userid,date1,title,content)values(‘$id’,’$userid’,’$date1′,’$title’,’$content’)”;
mysql_query($sql)or die(mysql_error());
$sql=”select * from “.$table.” where id=’$id1′”;
$result=mysql_query($sql)or die(mysql_error());
$lin=mysql_fetch_array($
来源gao!daima.com搞$代!码网
result);
for($i=1;$i<6;$i++)
{
$re=”r”.$i;
if(!$lin[“$re”])
break;
}
$sql=”update “.$table.” set “.$re.”=’$id’ where id=’$id1′”;
}
else
$sql=”insert into “.$table.” (id,userid,date1,title,content,row)values(‘$id’,’$userid’,’$date1′,’$title’,’$content’,’$row1′)”;
$result=mysql_query($sql)or die(mysql_error());
if($result)
{
header(“Location:php3.php?p=1&&table=$table”);
exit ;
}
}
}
?>
<form name="form1" method="post" action="”>
题目
|
<input type="text" name="title" size="40" value="” onmouseover=”this.document.form1.title.focus();return true”> <input type="hidden" name="table" value="”> <input type="hidden" name="id1" value="”>
|
内容
|
<textarea name="content" cols="40" rows="10" wrap="physical" value="” onmouseover=”this.document.form1.content.focus()”> |
|
|
以上就是BBS(php & mysql)完整版(一)的详细内容,更多请关注gaodaima搞代码网其它相关文章!