论坛php mysql_BBS(php & mysql)完整版(三)

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

发布时间：2016-06-17 来源： 点击:

次

//此页面为php3.php

include "signup/mysql.inc";

switch($part){

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

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

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)完整版(三)"希望对你有所帮助.本文来自网络，转载请注明出处：http://www.weixuecn.cn/article/1427.html