广

PHP编程

  • IOS开发
  • android开发
  • PHP编程
  • JavaScript
  • ASP.NET
  • ASP编程
  • JSP编程
  • Java编程
  • 易语言
  • Ruby编程
  • Perl编程
  • AJAX
  • 正则表达式
  • C语言
  • 编程开发

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

    2018-09-28 15: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>
    <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=#3333FF><a    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 "<BR><div style="text-align:center"><table><tr><td><FONT 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>

    零七网部分新闻及文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与零七网进行文章共享合作。

    零七广告
    零七广告
    零七广告
    零七广告