//此页面为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<'$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";
else $color="FFCCFF";
echo "";
echo " "; echo " ".$row["number"]." "; echo " | ";
echo " "; echo " "; echo " | ";
echo " "; echo " ".$row["userid"]." "; echo " | ";
echo " "; echo " ".$row["date1"]." "; echo " |
";
}
echo"
";
echo "
"; for($i=1;$i<=$page;$i++) { echo "[".$i."] "; } ?> |
我要発信< ;/div>
http://www.bkjia.com/PHPjc/315710.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/315710.html技術記事 //この面はphp3.phpですか? Signup/mysql.inc を含めます。 switch($part){ case 1 :$table=bbs_php;break;ケース 2 :$table=bbs_mysql;break;ケース 3 :$table=bbs_html;休憩;ケース 4 :$table=bbs_js;...