广

PHP编程

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

    基于mysql的论坛(4)

    2018-10-04 14:39:37 次阅读 稿源:互联网
    零七广告
    ## index.php
    <html>
    <head>
    <title>论坛</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    </head>

    <frameset cols="125,*" rows="*" border="0" frameborder="0">  
      <frame src="left.php" name="left" scrolling="AUTO" frameborder="YES" bordercolor="#000000">
      <frame src="right.htm" name="main" scrolling="AUTO">
    </frameset>
    <noframes><body bgcolor="#FFFFFF">

    </body></noframes>
    </html>
    ## left.php
    <?php
    $fp=fopen("file/counter.txt","r");
    $counter=fgets($fp,8);
    fclose($fp);
    $counter=$counter+1;
    $fp=fopen("file/counter.txt","w");
    fputs($fp,$counter);
    fclose($fp);
    require("config.inc.php");
    $sql="select * from boardinfo";
    $sql_result=mysql_query($sql);
    $sql_row=mysql_fetch_array($sql_result);
    ?>
    <html>
    <head>
    <title>版面列表</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <link href="css/new.css" rel=stylesheet>
    </head>

    <body background="image/bg.gif" bgcolor="#FFFFFF">
    <table width="100%" border="0" cellspacing="2" cellpadding="0">
      <tr>
        <td align="center"> </td>
      </tr>
      <tr>
        <td align="center"><a href="apply.php" target="main">注册用户</a></td>
      </tr>
      <tr>
        <td align="center"><font color="#666666">---------</font></td>
      </tr>
    <?php
    do
    {
    echo"<tr>";
    echo"<td align="center"><a href="list.php?board=$sql_row[name]" target="main">$sql_row[chinesename]</a></td>";
    echo"</tr>";
    }while($sql_row=mysql_fetch_array($sql_result));
    ?>
    <tr>
        <td align="center"><font color="#006666">---------</font></td>
      </tr>
      <tr>
        <td height="11">
          <script src=file/X86tree.js></script>
          <script language=javascript>
            img_t1="image/t1.gif";
            img_t2="image/t2.gif";
            tree=new TreeView(0,0,640,300);
            tree.AddImage(0,"image/dot.gif");
            tree.AddImage(1,"image/close.gif");
            tree.AddImage(2,"image/open.gif");

            m1=new Nodes("m1",tree.ImageList,"论坛转向",0,2,"");
            m1.Add(new Node("站点首页",1,0,"<a href='http://www.jlbusiness.com' target='_top'>"));                                                              m1.Add(new Node("论坛首页",1,0,"<a href='right.htm' target='main'>"));
        tree.Add2(m1);

            doc2=new Nodes("doc2",tree.ImageList,"论坛功能",0,2,"-");
                doc2.Add(new Node("帖子查询",1,0,"<a href='query.php' target='main'>"));
                doc2.Add(new Node("精华区域",1,0,"<a href='good.php' target='main'>"));
                    doc2.Add(new Node("察看留言",1,0,"<a href='vmlogin.php' target='main'>"));
                    doc2.Add(new Node("修改资料",1,0,"<a href='modify_l.php' target='main'>"));
                    doc2.Add(new Node("察看资料",1,0,"<a href='userinfo.php' target='main'>"));
                    doc2.Add(new Node("察看积分",1,0,"<a href='viewscore.php' target='main'>"));
                    doc2.Add(new Node("论坛管理",1,0,"<a href='manage.htm' target='main'>"));
            tree.Add2(doc2);

            tree.Show();
            doc2.Close();
            m1.Close();
    </script>
        </td>
      </tr>
      <tr>
        <td align="center"> <b><font color="#006666">--------</font><br>
          <?php echo "$counter"?></b></td>
      </tr>
    </table>
    </body>
    </html>
    ## list.php
    <?php
    require("func.php");
    if(empty($board)){
        $board="computer";
    }
    $sql="select * from boardinfo where name='$board'";
    $sql_result=mysql_query($sql);
    $sql_row=mysql_fetch_array($sql_result);
    $chinesename=$sql_row[chinesename];
    setcookie ("jl_forum[chinesename]",$chinesename);
    $sql="select name from user where slaveboard='$board'";
    $sql_result=mysql_query($sql);
    ?>
    <html>
    <head>
    <title>List</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <link rel="stylesheet" type="text/css" href="css/index.css">
    <script language="javascript">
    function openwin(board,id){                window.open("read.php?board="+board+"&id="+id,"","height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
    }
    function post(board){                window.open("post.php?board="+board,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
    }
    </script>
    </head>

    <body bgcolor="#FFFFFF" background="image/bg.gif">
    <?php include "header.php";?> <br>
    <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
      <tr>  
        <td height="22" width="23%" bgcolor="#eeeeee">版面:<?php
    echo $chinesename;
    ?></td>
        <td height="22" width="41%" bgcolor="#eeeeee">版主:<?php
    while ($sql_row=mysql_fetch_array($sql_result))
    {
    echo "$sql_row[name]"." ";
    }
    # 选择出留言纪录;
    $sql="select * from $board where slaveid=0";
    $temp=mysql_query($sql);
    $sum=mysql_num_rows($temp);
    $totalpage=ceil($sum/$pagesize);
    if ($sum==0) {
        $totalpage=1;
    }
    # 分页
    if($page<1 or empty($page)){
        $page=1;
    }
    elseif ($page>$totalpage){
             $page=$totalpage;
    }
    $offset=($page-1)*$pagesize;
    $sql="select * from $board where slaveid=0 order by id desc limit $offset,$pagesize";
    $sql_result=mysql_query($sql);
    ?> </td>
        <td height="22" width="13%" bgcolor="#eeeeee">贴子总数:<?php echo $sum; ?></td>
        <td height="22" width="12%"><a href='javascript:post("<?php echo $board;?>")'><img src="image/newtopic.jpg" width="93" height="21" border="0" alt="发新贴子"></a></td>
        <td height="22" width="11%">  
          <div align="center"><a href="<?php echo "$php_self?board=$board&page=$page";?>">刷新浏览</a></div>
        </td>
      </tr>
    </table>
    <br>
    <table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
      <tr bgcolor="#995100" align="center">
        <td width="6%"><font color="#FFFFFF">回应</font></td>
        <td width="67%" bgcolor="#995100"><font color="#FFFFFF">主 题</font></td>
        <td width="20%"><font color="#FFFFFF">时 间</font></td>
        <td width="7%"><font color="#FFFFFF">人气</font></td>
      </tr>
      <tr bgcolor="#FFCC99">
        <td colspan="5" height="2"> </td>
      </tr>
      <?php
    while ($sql_row=mysql_fetch_array($sql_result))
    {
    echo"<tr>";
    echo"<td width="6%" bgcolor="#FFF5DD" align="center">";
    if ($sql_row[renum]!=0)
          {
           echo "<font color="#FF0000">[+$sql_row[renum]]</font>";
          }
    else
    {
    echo "[0]";
    }
      echo"</td>";
      echo"<td bgcolor="#E8FDEE" width="56%"><font face="宋体"><a href='javascript:openwin("$board",$sql_row[id])' title="作者:$sql_row[writer] 大小:$sql_row[size]字节">$sql_row[title]</a></font></td>";
      echo"<td width="18%" bgcolor="#FFF5DD" align="center">$sql_row[writetime]</td>";
      echo"<td width="6%" bgcolor="#E8FDEE" align="center">$sql_row[hits]</td>";
      echo"</tr>";
    }
    ?>
      <tr bgcolor="#FFCC99">
        <td colspan="5" align="center" height="2"> </td>
      </tr>
    </table>
    <div align="right">
    <form method="post" action="<?php echo $php_self;?>">
        共<b><?php echo $totalpage;?></b>页 第<b><?php echo $page;?></b>页·<?php
    if ($page!=1){
         $back=$page-1;
            echo"<a href="$php_self?board=$board&page=1">首页</a> <a href="$php_self?board=$board&page=$back">上一页</a>";
    }
    if ($page==1){
           echo"首页 上一页";
    }
    if($page!=$totalpage){
        $next=$page+1;
            echo" <a href="$php_self?board=$board&page=$next">下一页</a> <a href="$php_self?board=$board&page=$totalpage">尾页</a>";
    }
    if($page==$totalpage){
            echo" 下一页 尾页";
    }
    ?>·  
        <input type="submit" name="goto" value="转到">
        <input type="text" name="page" size="2">
        页  
      </form>
    </div>
    <?php include "footer.php";?>
    </body>
    </html>
    ## login.php
    <?php
    require "func.php";
    if ($name==$admin_name and $password==$admin_password) {
        setcookie ("jl_admin[name]",$name);
        setcookie ("jl_admin[password]",$name);
        redirect2("admin.php");
    }
    else {
        show_error(1);
    }
    ?>
    ## manage.php
    <?php
    require "func.php";
    if (check_admin_password()) {
        switch ($job){
            case "setgood":
                set_good($jl_forum[board],$id);
                break;
            case "setnogood":
                set_no_good($jl_forum[board],$id);
                break;
            case "delete":
                del_doc($jl_forum[board],$id);
                break;
        }
    echo "<h2>操作成功!</h2><br>";
    ?>
    <html><head><title>o,k</title></head><body>
    <form method="POST">
          <input type="button" value=" 关 闭 " name="B1" onclick="window.close()">
    </form>
    </body>
    </html>
    <?php
    }
    else {
        show_error(1);
    }
    ?>
    ## manage_list.php
    <?php
    require("func.php");
    if (check_admin_password()) {
    $board=$jl_forum[board];
    $sql="select * from boardinfo where name='$board'";
    $sql_result=mysql_query($sql);
    $sql_row=mysql_fetch_array($sql_result);
    $chinesename=$sql_row[chinesename];
    setcookie ("jl_forum[chinesename]",$chinesename);
    $sql="select name from user where slaveboard='$board'";
    $sql_result=mysql_query($sql);
    ?>
    <html>
    <head>
    <title>List</title>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <link rel="stylesheet" type="text/css" href="css/index.css">
    <script language="javascript">
    function openwin(board,id){                window.open("manage_read.php?board="+board+"&id="+id,"","height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
    }
    function post(board){                window.open("post.php?board="+board,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
    }
    </script>
    </head>

    <body bgcolor="#FFFFFF" background="image/bg.gif">
    <?php include "header.php";?> <br>
    <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#D8D8E8" bordercolordark="#D8D8E8">
      <tr>  
        <td height="20" width="27%" bgcolor="#d8dde9">版面:<?php
    echo $chinesename;
    ?>(管理)</td>
        <td height="20" width="31%" bgcolor="#d8dde9">版主:<?php
    while ($sql_row=mysql_fetch_array($sql_result))
    {
    echo "$sql_row[name]"." ";
    }
    # 选择出留言纪录;
    $sql="select * from $board where slaveid=0";
    $temp=mysql_query($sql);
    $sum=mysql_num_rows($temp);
    $totalpage=ceil($sum/$pagesize);
    if ($sum==0) {
        $totalpage=1;
    }
    # 分页
    if($page<1 or empty($page)){
        $page=1;
    }
    elseif ($page>$totalpage){
             $page=$totalpage;
    }
    $offset=($page-1)*$pagesize;
    $sql="select * from $board where slaveid=0 order by id desc limit $offset,$pagesize";
    $sql_result=mysql_query($sql);
    ?> </td>
        <td height="20" width="15%" bgcolor="#d8dde9">贴子总数:<?php echo $sum; ?></td>
        <td height="20" width="12%"><a href='javascript:post("<?php echo $board;?>")'><img src="image/newtopic.jpg" width="92" height="21" border="0" alt="发新贴子"></a></td>
        <td height="20" align="center" width="15%"><a href="<?php echo "$php_self?board=$board&page=$page";?>">刷新浏览</a></td>
      </tr>
    </table>
    <br>
    <table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolorlight="#CCCCCC" bordercolordark="#CCCCCC">
      <tr bgcolor="#995100" align="center">
        <td width="6%"><font color="#FFFFFF">回应</font></td>
        <td width="67%" bgcolor="#995100"><font color="#FFFFFF">主 题</font></td>
        <td width="20%"><font color="#FFFFFF">时 间</font></td>
        <td width="7%"><font color="#FFFFFF">人气</font></td>
      </tr>
      <tr bgcolor="#FFCC99">
        <td colspan="5" height="2"> </td>
      </tr>
      <?php
    while ($sql_row=mysql_fetch_array($sql_result))
    {
    echo"<tr>";
    echo"<td width="6%" bgcolor="#FFF5DD" align="center">";
    if ($sql_row[renum]!=0)
          {
           echo "<font color="#FF0000">[+$sql_row[renum]]</font>";
          }
    else
    {
    echo "[0]";
    }
      echo"</td>";
      echo"<td bgcolor="#E8FDEE" width="56%"><font face="宋体"><a href='javascript:openwin("$board",$sql_row[id])' title="作者:$sql_row[writer] 大小:$sql_row[size]字节">$sql_row[title]</a></font></td>";
      echo"<td width="18%" bgcolor="#FFF5DD" align="center">$sql_row[writetime]</td>";
      echo"<td width="6%" bgcolor="#E8FDEE" align="center">$sql_row[hits]</td>";
      echo"</tr>";
    }
    ?>
      <tr bgcolor="#FFCC99">
        <td colspan="5" align="center" height="2"> </td>
      </tr>
    </table>
    <div align="right">
    <form method="post" action="<?php echo $php_self;?>">
        共<b><?php echo $totalpage;?></b>页 第<b><?php echo $page;?></b>页· <?php
    if ($page!=1){
         $back=$page-1;
            echo"<a href="$php_self?board=$board&page=1">首页</a> <a href="$php_self?board=$board&page=$back">上一页</a>";
    }
    if ($page==1){
           echo"首页 上一页";
    }
    if($page!=$totalpage){
        $next=$page+1;
            echo" <a href="$php_self?board=$board&page=$next">下一页</a> <a href="$php_self?board=$board&page=$totalpage">尾页</a>";
    }
    if($page==$totalpage){
            echo" 下一页 尾页";
    }
    ?>·转到第  
        <input type="text" name="page" size="2">
        页  
      </form>
    </div>
    <?php include "footer.php"?>
    </body>
    </html>
    <?php
    }
    else {
        show_error(4);
    }
    ?> 

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

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