来源：自学PHP网 时间：2014-12-25 09:57 作者： 阅读:次
[导读] 基于mysql的论坛（4）,##index.phplt;htmlgt;lt;headgt;lt;titlegt;论坛lt;/titlegt;lt;metahttp-equiv=quot;Content-Typequot;content=quot;text/html;charset=gb2312quot;gt;lt;/headgt;lt;framesetcols=quot;125,*quot;rows=quot;*quot;border=quo...
|
## 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); } ?> |
自学PHP网专注网站建设学习,PHP程序学习,平面设计学习，以及操作系统学习
京ICP备14009008号-1@版权所有www.zixuephp.com
网站声明：本站所有视频，教程都由网友上传，站长收集和分享给大家学习使用，如由牵扯版权问题请联系站长邮箱904561283@qq.com
