文章详情页

基于mysql的论坛（4）

【字号：大中小】日期：2023-10-26 14:42:03浏览：54作者：猪猪

## 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='https://www.haobala.com/bcjs/right.htm' target='main'>")); ;;;;tree.Add2(m1); doc2=new Nodes("doc2",tree.ImageList,"论坛功能",0,2,"-"); ;;;;doc2.Add(new Node("帖子查询",1,0,"<a href='https://www.haobala.com/bcjs/query.php' target='main'>")); ;;;;doc2.Add(new Node("精华区域",1,0,"<a href='https://www.haobala.com/bcjs/good.php' target='main'>")); doc2.Add(new Node("察看留言",1,0,"<a href='https://www.haobala.com/bcjs/vmlogin.php' target='main'>")); doc2.Add(new Node("修改资料",1,0,"<a href='https://www.haobala.com/bcjs/modify_l.php' target='main'>")); doc2.Add(new Node("察看资料",1,0,"<a href='https://www.haobala.com/bcjs/userinfo.php' target='main'>")); doc2.Add(new Node("察看积分",1,0,"<a href='https://www.haobala.com/bcjs/viewscore.php' target='main'>")); doc2.Add(new Node("论坛管理",1,0,"<a href='https://www.haobala.com/bcjs/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); } ?>;

上一条：基于mysql的论坛（3）下一条：基于mysql的论坛（5）

排行榜

					
					DB2 DBA避免性能灾难并获得高性能的技巧
详解mybatis批量插入10万条数据的优化过程
MySQL横纵表相互转化操作实现方法
中国银联应用IBM DB2通用数据库的案例（1）
MySQL 字符串函数：字符串截取
MySQL如何使用授权命令grant
Mysql入门系列：需要避免的MYSQL客户机程序设计错误
教你在Windows环境下Kill掉Oracle的线程
Centos7 下mysql重新启动MariaDB篇
保“库”之路：Oracle数据库性能保护
Sql Server2005学习日记(01)
				

热门标签