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

更新时间:2023-04-06 05:18:29 阅读：评论：0

//此页面为php3.php

<?

include “signup/mysql.inc”;

switch($part){

ca “1” :$table=”bbs_php”;break;

ca “2” :$table=”bbs_mysql”;break;

ca “3” :$table=”bbs_html”;break;

ca “4” :$table=”bbs_js”;

}

//echo $part;

?>

<html>

<head>

<title>xiaoyang</title>

<meta http-equiv=”content-type” content=”text/html; chart=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”)&钢筋符号word;&(parint(appversion)==4)) {

document.mm_pgw=innerwidth; document.mm_pgh=innerheight; onresize=mm_reloadpage; }}

el if (innerwidth!=document.mm_pgw || innerheight!=document.mm_pgh) location.reload();

}

mm_reloadpage(true);

// –>

</script>

</head>

$sql=”lect * from “.$table.” order by row desc”;

$result=mysql_query($sql)or die(mysql_error());

$row1=mysql_num_rows($result);

$row_max_page=12;//分页计算

$page=ceil($row1/$row_max_page);

$left_row=$row1-$p*$row_max_page;

$pre_left_row=$left_row+12;

$start_row=$left_row+$row_max_page+1;

if($left_row<=0)

{

$start_row=$pre_left_row+1;

$left_row=0;

}

$sql=”lect * from “.$table.” where row<‘$start_row’ and row>’$left_row’ order by row desc”;

$result=mysql_query($sql)or die(mysql_error());

while($row=mysql_fetch_array($result)){

static $i=0;

$i++;

if($i%2)

$color=”ccccff”;

el $color=”ffccff”;

echo “<tr>”;

echo ”<td width=10% bgcolor=#”.$color.”> “;

echo ”<div align=center><font size=2 color=#3333ff>”.$row[“number”].”</font></div>”cao妈妈;

echo ”</td>”;

echo ”<td width=38% bgcolor=#”.$color.”> “;

echo ”<div align=center><font size=2 color=#3333ff><ahref=’look.php?id=”.$row[“id”].”&&table=”.$table.”‘>”.$row[“title”].”</a></font></div>”;

echo ”</td>”;

echo ”<td width=26% bgcolor=#”.$color.”> “;

echo ”<div align=center><font size=2 color=#3333ff>”.$row[“urid”].”</font></div>”;

echo ”</td>”;

echo ”<td width=26% bgcolor=#”.$color.”> “;

echo ”<div align=center><font size=2 color=#3333ff>”.$row[“date1″].”</font></div>”;

echo ”</td></tr>”;

}

echo”</table>”;

echo “<br><div align=center><table><tr><td><font size=2 >”;

for($i=1;$i<=$page;$i++)

{

echo “<a href='”.$php_lf.”?p=”.$i.”&&table=”.$table.”‘>[“.$i.”]</a>“;

}

?>

</font></td></tr>

</table></div>

</div>

<div id=”layer6″ style=”position:absolute; left:409px; top:29px; width:118px; height:17px; z-index:6″></div>

<div id=”layer7″ style=”position:absolute; left:451px; top:28px; width:65px; height:12px; z-index:8&#六月英文8243;>

<a href=”say.php?table=<?echo $table ;?>” target=”_lf” onmouover=”window.status=”;return true”><font size=”2″ color=”#ff33ff”>我要发言</font></a></div>

<p></p>

<p></p>

</body>

</html>