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

【 tulaoshi.com - Web开发 】

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

html
head
titlexiaoyang/title
meta http-equiv="Content-Type" content="text/html; charset=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")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// --
/script
/head

body bgcolor="#FFFFFF" text="#000000"
div id="Layer1" style="position:absolute; left:31px; top:1px; width:560px; height:46px; z-index:10"
script language="JavaScript1.2"fwLoadMenus();/script/div





div id="Layer2" style="position:absolute; left:27px; top:41px; width:600px; height:15px; z-index:2"
  hr color="#ff9999"
/div
div id="Layer3" style="position:absolute; left:73px; top:10px; width:2px; height:330px; z-index:3; background-color: #ff9999; layer-background-color: #ff9999; border: 1px none #000000"/div
div id="Layer4" style="position:absolute; left:560px; top:10px; width:2px; height:330px; z-index:4; background-color: #ff9999; layer-background-color: #ff9999; border: 1px none #000000"/div
div id="Layer5" style="position:absolute; left:86px; top:58px; width:464px; height:273px; z-index:5"  
  table width="100%" border="0" cellspacing="1" cellpadding="0" height="20"
    tr  
      td width="10%"  
        div align="center"font color="#CC33CC" size="2"人气/font/div
      /td
      td width="38%"  
        div align="center"font color="#CC33CC" size="2"文章题目/font/div
      /td
      td width="26%"  
        div align="center"font size="2" color="#CC33CC"作者/font/div
      /td
      td width="26%"  
        div align="center"font color="#CC33CC" size="2"日期/font/div
      /td
    /tr

?  

   $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 "tr";  
    echo "  td width=10% bgcolor=#".$color." ";
    echo "    div style="text-align:center"font size=2 color=#3333FF".$row["number"]."/font/div";
    echo "  /td";
    echo "  td width=38% bgcolor=#".$color." ";
    echo "    div style="text-align:center"font size=2 color=#3333FFa    href='look.php?id=".$row["id"]."&&table=".$table."'".$row["title"]."/a/font/div";
    echo "  /td";
    echo "  td width=26% bgcolor=#".$color." ";
    echo "    div style="text-align:center"font size=2 color=#3333FF".$row["userid"]."/font/div";
    echo "  /td";
    echo "  td width=26% bgcolor=#".$color." ";
    echo "    div style="text-align:center"font size=2 color=#3333FF".$row["date1"]."/font/div";
    echo "  /td    /tr";

         }

    echo"/table";                
    echo "BRdiv style="text-align:center"tabletrtdFONT SIZE=2 ";
   for($i=1;$i=$page;$i++)
   {
   echo "a href='".$PHP_SELF."?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"  
  a href="say.php?table=?echo $table ;?" target="_self" onMouseOver="window.status='';return true"font size="2" color="#FF33FF"我要发言/font/a/div
p /p
p /p
/body
/html