BBSphp & mysql完整版三 -pc6资讯

您的位置：首页 → 网页设计 → PHP实例 → BBSphp & mysql完整版三

BBSphp & mysql完整版三 时间：2004/11/7 3:27:00来源：本站整理作者：蓝点我要评论(0)

//此页面为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 "  ";

    echo "  ";

    echo "      ";



         }



    echo"

人气	文章题目	作者	日期
"; echo " ".$row["number"]." "; echo "	"; echo " ".$row["title"]." "; echo "	"; echo " ".$row["userid"]." "; echo "	"; echo " ".$row["date1"]." "; echo "

";

echo "

";

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

   {

   echo "[".$i."] ";

   }

   ?>

我要发言

文章评论

查看所有0条评论>>

热门文章 没有查询到任何记录。