BBS(php & mysql)完整版(一)
程序员文章站
2022-03-31 12:33:45
//此页面为say.php
//此页面为say.php
<?
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 "<html><div id=layer2 align=center z-index:1><br><br><br><br>";
echo" <div id=layer3 align=center z-index:2><img src=pic/3.gif width=15 height=15></div>";
echo" <div align=center>";
echo" <p><font size=2 color=#ff33cc>嘻嘻!! 请先登陆</font></p>";
echo"<p><font size=2 color=#ff33cc><a href='".$php_self."?p=1&&table=$table'>返回</a></font></p> </div> </html>";
exit();
}
else $userid=$row["userid"];
if($ok)
{
if($title==""||$content=="")
{
echo "<br> 请您添完整后提交";
}
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($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 ;
}
}
}
?>
<html>
<head>
<title>xiaoyang</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<script language="javascript1.2" src="js/menu_comment.js"></script>
<script language="javascript1.2" src="js/fw_menu.js"></script>
<script language="javascript">
<!--
function mm_reloadpage(init) { //reloads the window if nav4 resized
if (init==true) with (navigator) {if ((appname=="netscape")&&(parseint(appversion)==4)) {
document.mm_pgw=innerwidth; document.mm_pgh=innerheight; onresize=mm_reloadpage; }}
else if (innerwidth!=document.mm_pgw || innerheight!=document.mm_pgh) location.reload();
}
mm_reloadpage(true);
// -->
</script>
</head>
<body bgcolor="#ffffff" text="#000000">
<div id="layer1" style="position:absolute; left:31px; top:1px; width:560px; height:46px; z-index:10">
<script language="javascript1.2">fwloadmenus();</script></div>
<div id="layer6" style="position:absolute; left:409px; top:29px; width:118px; height:17px; z-index:6"></div>
<div id="layer5" style="position:absolute; left:86px; top:63px; width:464px; height:303px; z-index:7">
<form name="form1" method="post" action="<? echo $php_self ?>">
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#ff99ff">
<tr>
<td width="26%" height="42">
<div align="center"><font size="2" color="#ff33ff">题目</font></div>
</td>
<td width="74%" height="42">
<input type="text" name="title" size="40" value="<?echo $title ;?>" onmouseover="this.document.form1.title.focus();return true">
<input type="hidden" name="table" value="<?echo $table ;?>">
<input type="hidden" name="id1" value="<? echo $id1 ;?>">
<br>
</td>
</tr>
<tr>
<td width="26%" height="172">
<div align="center"><font size="2" color="#ff33ff">内容</font></div>
</td>
<td width="74%" height="172">
<textarea name="content" cols="40" rows="10" wrap="physical" value="<?echo $content ;?>" onmouseover="this.document.form1.content.focus()"></textarea>
</td>
</tr>
<tr>
<td width="26%">
<div align="center">
<input type="reset" name="submit2" value="重写">
</div>
</td>
<td width="74%">
<div align="center">
<input type="submit" name="ok" value="发表">
</div>
</td>
</tr>
</table>
<p> </p>
</form>
</div>
<div id="back" style="position:absolute; left:455px; top:30px; width:85px; height:3px; z-index:8">
<hr color="#ff9999" noshade>
</div>
<div id="goback" style="position:absolute; left:461px; top:23px; width:120px; height:16px; z-index:9">
<div align="center"><a href="php3.php?p=1&&table=<?echo $table ;?>" target="_self" onmouseover="window.status='' ;return true"><font size="2" color="#ff33ff">返回</font></a></div>
</div>
<p> </p>
<p> </p>
</body>
</html>
<?
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 "<html><div id=layer2 align=center z-index:1><br><br><br><br>";
echo" <div id=layer3 align=center z-index:2><img src=pic/3.gif width=15 height=15></div>";
echo" <div align=center>";
echo" <p><font size=2 color=#ff33cc>嘻嘻!! 请先登陆</font></p>";
echo"<p><font size=2 color=#ff33cc><a href='".$php_self."?p=1&&table=$table'>返回</a></font></p> </div> </html>";
exit();
}
else $userid=$row["userid"];
if($ok)
{
if($title==""||$content=="")
{
echo "<br> 请您添完整后提交";
}
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($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 ;
}
}
}
?>
<html>
<head>
<title>xiaoyang</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<script language="javascript1.2" src="js/menu_comment.js"></script>
<script language="javascript1.2" src="js/fw_menu.js"></script>
<script language="javascript">
<!--
function mm_reloadpage(init) { //reloads the window if nav4 resized
if (init==true) with (navigator) {if ((appname=="netscape")&&(parseint(appversion)==4)) {
document.mm_pgw=innerwidth; document.mm_pgh=innerheight; onresize=mm_reloadpage; }}
else if (innerwidth!=document.mm_pgw || innerheight!=document.mm_pgh) location.reload();
}
mm_reloadpage(true);
// -->
</script>
</head>
<body bgcolor="#ffffff" text="#000000">
<div id="layer1" style="position:absolute; left:31px; top:1px; width:560px; height:46px; z-index:10">
<script language="javascript1.2">fwloadmenus();</script></div>
<div id="layer6" style="position:absolute; left:409px; top:29px; width:118px; height:17px; z-index:6"></div>
<div id="layer5" style="position:absolute; left:86px; top:63px; width:464px; height:303px; z-index:7">
<form name="form1" method="post" action="<? echo $php_self ?>">
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolor="#ff99ff">
<tr>
<td width="26%" height="42">
<div align="center"><font size="2" color="#ff33ff">题目</font></div>
</td>
<td width="74%" height="42">
<input type="text" name="title" size="40" value="<?echo $title ;?>" onmouseover="this.document.form1.title.focus();return true">
<input type="hidden" name="table" value="<?echo $table ;?>">
<input type="hidden" name="id1" value="<? echo $id1 ;?>">
<br>
</td>
</tr>
<tr>
<td width="26%" height="172">
<div align="center"><font size="2" color="#ff33ff">内容</font></div>
</td>
<td width="74%" height="172">
<textarea name="content" cols="40" rows="10" wrap="physical" value="<?echo $content ;?>" onmouseover="this.document.form1.content.focus()"></textarea>
</td>
</tr>
<tr>
<td width="26%">
<div align="center">
<input type="reset" name="submit2" value="重写">
</div>
</td>
<td width="74%">
<div align="center">
<input type="submit" name="ok" value="发表">
</div>
</td>
</tr>
</table>
<p> </p>
</form>
</div>
<div id="back" style="position:absolute; left:455px; top:30px; width:85px; height:3px; z-index:8">
<hr color="#ff9999" noshade>
</div>
<div id="goback" style="position:absolute; left:461px; top:23px; width:120px; height:16px; z-index:9">
<div align="center"><a href="php3.php?p=1&&table=<?echo $table ;?>" target="_self" onmouseover="window.status='' ;return true"><font size="2" color="#ff33ff">返回</font></a></div>
</div>
<p> </p>
<p> </p>
</body>
</html>
上一篇： PHP中Session的概念
下一篇： 用Flash图形化数据(二)