//此页面为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>
查看更多关于BBS(php & mysql)完整版(一)-PHP实例的详细内容...