当前位置: 首页 > 图文教程 > 网络编程 > PHP > 基于mysql的论坛（4）

PHP
工作笔记：配置MySQL为高可用集群 （1）
MySQL (C API)VC实例及代码下载 （1）(5)
MySQL (C API)VC实例及代码下载 （1）(4)
MySQL (C API)VC实例及代码下载 （1）(3)
MySQL (C API)VC实例及代码下载 （1）(2)
MySQL (C API)VC实例及代码下载 （1）
用JSP连接mysql数据库的方法 （1）(2)
用JSP连接mysql数据库的方法 （1）
MySQL数据库账户授权的相关管理解析 （1）(2)
MySQL数据库账户授权的相关管理解析 （1）
SAP MaxDB MySQL修补数据库严重漏洞
MySQL研发中心成立发布会会后访问整理 （1）(2)
MySQL研发中心成立发布会会后访问整理 （1）
MySQL中SQL-TEXT、DATE和SET数据类型
MySQL存在权限提升及安全限制绕过漏洞
MySQL 卸载的问题
windows下安装、卸载mysql服务
如何正确卸载MySQL
MySQL手册版本 5.0.20-MySQL优化(四) （1）(5)
MySQL手册版本 5.0.20-MySQL优化(四) （1）(4)

No. « 183 184 185 186 »

技术文章搜索

关键字

PHP 中的 基于mysql的论坛（4）

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 206 ::
收藏到网摘: n/a

## 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);
}
?>