php mysql完整_BBS(php & mysql)完整版(三)_php

//此页面为php3.php

include "signup/mysql.inc";

switch($part){

case "1" :$table="bbs_php";break;

case "2" :$table="bbs_mysql";break;

http://www.gaodaima.com/47220.htmlBBS(php & mysql)完整版(三)_php

case "3" :$table="bbs_html";break;

case "4" :$table="bbs_js";

}

//echo $part;

?>

xiaoyang

人气

文章题目

作者

日期

$sql="select * 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="select * from ".$table." where 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";

else $color="FFCCFF";

echo "

";

echo "  

";

echo "    

".$row["number"]."

";

echo "  

";

echo "  

";

echo "    

".$row["title"]."

";

echo "  

";

echo "  

";

echo "    

".$row["userid"]."

";

echo "  

";

echo "  

";

echo "    

".$row["date1"]."

";

echo "  

    ";

}

echo"

";

echo "

"; for($i=1;$i<=$page;$i++) { echo "[".$i."] "; } ?>

我要发言

欢迎大家阅读《BBS(php & mysql)完整版(三)_php》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~