提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  数据库

当前栏目

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

mysqlampPHP 完整版 BBS
2023-06-13 09:13:43 时间
//此页面为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>
<title>xiaoyang</title>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<scriptlanguage="JavaScript1.2"src="js/menu_comment.js"></script>
<scriptlanguage="JavaScript1.2"src="js/fw_menu.js"></script>
<scriptlanguage="JavaScript">
<!--
functionMM_reloadPage(init){  //reloadsthewindowifNav4resized
  if(init==true)with(navigator){if((appName=="Netscape")&&(parseInt(appVersion)==4)){
    document.MM_pgW=innerWidth;document.MM_pgH=innerHeight;onresize=MM_reloadPage;}}
  elseif(innerWidth!=document.MM_pgW||innerHeight!=document.MM_pgH)location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>

<bodybgcolor="#FFFFFF"text="#000000">
<divid="Layer1"style="position:absolute;left:31px;top:1px;width:560px;height:46px;z-index:10">
<scriptlanguage="JavaScript1.2">fwLoadMenus();</script></div>





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

<?  

   $sql="select*from".$table."orderbyrowDESC";
   $result=mysql_query($sql)ordie(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."whererow<"$start_row"androw>"$left_row"orderbyrowDESC";
    $result=mysql_query($sql)ordie(mysql_error());

    while($row=mysql_fetch_array($result)){

       static$i=0;
       $i++;
       if($i%2)
        $color="CCCCFF";
       else$color="FFCCFF";
    echo"<tr>";  
    echo"  <tdwidth=10%bgcolor=#".$color.">";
    echo"    <divalign=center><fontsize=2color=#3333FF>".$row["number"]."</font></div>";
    echo"  </td>";
    echo"  <tdwidth=38%bgcolor=#".$color.">";
    echo"    <divalign=center><fontsize=2color=#3333FF><a    href="look.php?id=".$row["id"]."&&table=".$table."">".$row["title"]."</a></font></div>";
    echo"  </td>";
    echo"  <tdwidth=26%bgcolor=#".$color.">";
    echo"    <divalign=center><fontsize=2color=#3333FF>".$row["userid"]."</font></div>";
    echo"  </td>";
    echo"  <tdwidth=26%bgcolor=#".$color.">";
    echo"    <divalign=center><fontsize=2color=#3333FF>".$row["date1"]."</font></div>";
    echo"  </td>    </tr>";

         }

    echo"</table>";                
    echo"<BR><divalign=center><table><tr><td><FONTSIZE=2>";
   for($i=1;$i<=$page;$i++)
   {
   echo"<ahref="".$PHP_SELF."?p=".$i."&&table=".$table."">[".$i."]</a> ";
   }
   ?>
    </FONT></td></tr>
  </table></div>
</div>
<divid="Layer6"style="position:absolute;left:409px;top:29px;width:118px;height:17px;z-index:6"></div>
<divid="Layer7"style="position:absolute;left:451px;top:28px;width:65px;height:12px;z-index:8">  
  <ahref="say.php?table=<?echo$table;?>"target="_self"onMouseOver="window.status="";returntrue"><fontsize="2"color="#FF33FF">我要发言</font></a></div>
<p> </p>
<p> </p>
</body>
</html>

相关文章