BBS(php & mysql)完整版(三)

//此页面为php3.php
  1<html>
  2<head>
  3<title>xiaoyang</title>
  4<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
  5<script language="JavaScript1.2" src="js/menu_comment.js"></script>
  6<script language="JavaScript1.2" src="js/fw_menu.js"></script>
  7<script language="JavaScript">   
  8<!--   
  9function MM_reloadPage(init) { //reloads the window if Nav4 resized   
 10if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {   
 11document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}   
 12else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();   
 13}   
 14MM_reloadPage(true);   
 15// -->   
 16</script>
 17</head>
 18<body bgcolor="#FFFFFF" text="#000000">
 19<div id="Layer1" style="position:absolute; left:31px; top:1px; width:560px; height:46px; z-index:10">
 20<script language="JavaScript1.2">fwLoadMenus();</script></div>
 21<div id="Layer2" style="position:absolute; left:27px; top:41px; width:600px; height:15px; z-index:2">
 22<hr color="#ff9999"/>
 23</div>
 24<div id="Layer3" style="position:absolute; left:73px; top:10px; width:2px; height:330px; z-index:3; background-color: #ff9999; layer-background-color: #ff9999; border: 1px none #000000"></div>
 25<div id="Layer4" style="position:absolute; left:560px; top:10px; width:2px; height:330px; z-index:4; background-color: #ff9999; layer-background-color: #ff9999; border: 1px none #000000"></div>
 26<div id="Layer5" style="position:absolute; left:86px; top:58px; width:464px; height:273px; z-index:5">
 27<table border="0" cellpadding="0" cellspacing="1" height="20" width="100%">
 28<tr>
 29<td width="10%">
 30<div align="center"><font color="#CC33CC" size="2">人气</font></div>
 31</td>
 32<td width="38%">
 33<div align="center"><font color="#CC33CC" size="2">文章题目</font></div>
 34</td>
 35<td width="26%">
 36<div align="center"><font color="#CC33CC" size="2">作者</font></div>
 37</td>
 38<td width="26%">
 39<div align="center"><font color="#CC33CC" size="2">日期</font></div>
 40</td>
 41</tr>
 42<?   
 43  
 44$sql="select * from ".$table." order by row DESC";   
 45$result=mysql_query($sql)or die(mysql_error());   
 46$row1=mysql_num_rows($result);   
 47  
 48  
 49  
 50$row_max_page=12; //分页计算   
 51$page=ceil($row1/$row_max_page);   
 52$left_row=$row1-$p*$row_max_page;   
 53$pre_left_row=$left_row+12;   
 54$start_row=$left_row+$row_max_page+1;   
 55if($left_row<=0)   
 56{   
 57$start_row=$pre_left_row+1;   
 58$left_row=0;   
 59}   
 60  
 61  
 62  
 63$sql="select * from ".$table." where row<'$start_row' and row>'$left_row' order by row DESC";   
 64$result=mysql_query($sql)or die(mysql_error());   
 65  
 66while($row=mysql_fetch_array($result)){   
 67  
 68static $i=0;   
 69$i++;   
 70if($i%2)   
 71$color="CCCCFF";   
 72else $color="FFCCFF";   
 73echo "<tr>";   
 74echo " <td bgcolor='#".$color."' width="10%"> ";   
 75echo " <div align="center"><font color="#3333FF" size="2">".$row["number"]."</font></div>";   
 76echo " </td>";   
 77echo " <td bgcolor='#".$color."' width="38%"> ";   
 78echo " <div align="center"><font color="#3333FF" size="2"><a href='look.php?id=".$row["id"]."&amp;&amp;table=".$table."'>".$row["title"]."</a></font></div>";   
 79echo " </td>";   
 80echo " <td bgcolor='#".$color."' width="26%"> ";   
 81echo " <div align="center"><font color="#3333FF" size="2">".$row["userid"]."</font></div>";   
 82echo " </td>";   
 83echo " <td bgcolor='#".$color."' width="26%"> ";   
 84echo " <div align="center"><font color="#3333FF" size="2">".$row["date1"]."</font></div>";   
 85echo " </td> </tr>";   
 86  
 87}   
 88  
 89echo"</table>";   
 90echo "<br/><div align="center"><table><tr><td><font size="2">";   
 91for($i=1;$i&lt;=$page;$i++)   
 92{   
 93echo "<a href='".$PHP_SELF."?p=".$i."&amp;&amp;table=".$table."'>[".$i."]</a> ";   
 94}   
 95?&gt;   
 96</font></td></tr>
 97</table></div>
 98</div>
 99<div id="Layer6" style="position:absolute; left:409px; top:29px; width:118px; height:17px; z-index:6"></div>
100<div id="Layer7" style="position:absolute; left:451px; top:28px; width:65px; height:12px; z-index:8">
101<a href="say.php?table=&lt;?echo $table ;?&gt;" onmouseover="window.status='';return true" target="_self"><font color="#FF33FF" size="2">我要发言</font></a></div>
102<p> </p>
103<p> </p>
104</body>
105</html>
BBS(php &amp; mysql)完整版(三)

BBS(php & mysql)完整版(三)
