基于mysql的论坛（4）_php教程-查字典教程网

## index.php

<html>

<head>

</head>

</frameset>

</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>

</head>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<?php

{

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>

</tr>

<tr>

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>

<?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>

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>

<?php include "header.php";?> <br>

<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>

</tr>

</table>

<br>

</tr>

</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>

</table>

共<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"下一页尾页";

}

?>·

页

</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>";

</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>

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>

<?php include "header.php";?> <br>

<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>

</tr>

</table>

<br>

</tr>

</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 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>

</table>

共<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"下一页尾页";

}

?>·转到第

页

</form>

</div>

<?php include "footer.php"?>

</body>

</html>

<?php

}

else {

show_error(4);

}