//此页面为look.php <? include "signup/MySQL.inc"; $sql="select * from ".$table." where id='$id'"; $result=mysql_query($sql)or die(mysql_error()); $row=mysql_fetch_array($result); $number=++$row["number"]; $sql="update $table set number='$number' where id='$id'"; mysql_query($sql)or die(mysql_error()); ?> <html> <head> <title>xiaoyang</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <? include "js/menuhead.php" ?> <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"> <? include "js/menu.php"; ?> <div id="Layer6" style="position:absolute; left:409px; top:29px; width:118px; height:17px; z-index:1"></div> <div id="Layer5" style="position:absolute; left:63px; top:61px; width:464px; height:303px; z-index:2"> <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#FFCCFF"> <tr> <td width="22%" height="17"> <div align="center"><font color="#FF3399" size="2">题目</font></div> </td> <td width="78%" height="17"> <div align="center"><font size="2" color="#9966FF"><?echo $row["title"] ;?></font> </div> </td> </tr> <tr> <td width="22%" height="24"> <div align="center"><font color="#FF3399" size="2">作者</font></div> </td> <td width="78%" height="24"> <div align="center"><font size="2" color="#9966FF"><?echo $row["userid"] ;?></font> </div> </td> </tr> <tr> <td width="22%"> <div align="center"><font color="#FF3399" size="2">内容</font></div> </td> <td width="78%"> <div align="left"><font size="2" color="#9966FF"><? $file=explode("n",$row["content"]); $num=count($file); for($i=0 ;$i<$num;$i++) echo " ".$file[$i]."<BR>";?></font></div> </td> </tr> </table> <? for($j=1;$j<6;$j++) //显示回复内容 { $re="r".$j; if($row["$re"]) { $id2=$row["$re"]; $sql="select * from bbs_re where id='$id2'"; $result=mysql_query($sql)or die(mysql_error()); $row8=mysql_fetch_array($result); echo "<BR>"; echo " <table width=100% border=1 cellspacing=0 cellpadding=0 bordercolor=#FFCCFF> <tr>"; echo " <td width=22% height=17> <div align=center><font color=#FF3399 size=2>题目</font></div>"; echo " </td> <td width=78% height=17>"; echo " <div align=center><font size=2 color=#9966FF>".$row8["title"]."</font> </div> </td> </tr> <tr>"; echo "<td width=22% height=24>"; echo "<div align=center><font color=#FF3399 size=2>作者</font></div></td>"; echo " <td width=78% height=24>"; echo "<div align=center><font size=2 color=#9966FF>".$row8["userid"]." </font> </div></td> </tr><tr>"; echo " <td width=22%><div align=center><font color=#FF3399 size=2>内容</font></div>"; echo "</td> <td width=78%>"; echo "<div align=left><font size=2 color=#9966FF>"; $file=explode("n",$row8["content"]); $num=count($file); for($i=0 ;$i<$num;$i++) echo " ".$file[$i]."<BR>"; echo "</font></div>"; echo " </td> </tr> </table>"; } } ?> <BR><BR> </div> <div id="back" style="position:absolute; left:455px; top:30px; width:85px; height:3px; z-index:3"> <hr color="#ff9999" noshade> </div> <div id="goback" style="position:absolute; left:461px; top:23px; width:120px; height:16px; z-index:2"> <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> <div id="Lay" style="position:absolute; left:70px; top:30px; width:85px; height:3px; z-index:4"> <hr noshade color="#ff9999"> </div> <div id="Laye" style="position:absolute; left:78px; top:23px; width:120px; height:16px; z-index:1"> <div align="center"><a href="say.php?id1=<? echo $id."&&table=".$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实例的详细内容...