欢迎来到福编程网,本站提供各种互联网专业知识!

基于mysql的论坛(4)

发布时间:2006-10-09 作者: 来源:转载
##index.php论坛##left.php版面列表注册用户------------------img_t1="image/t1.gif";img_t2="image/t2.gif";tree=newTreeView(0,0,640,300);tree.AddImage(0,"image/dot.gif");tree.AddImage(1,"image/close.gif");tree.AddImage(2,"image/open.gif");m1=ne
## index.php

论坛

<body bgcolor="#FFFFFF"> </p><p></p><p></body>

## left.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);

?>

版面列表

do

{

echo"

";

echo"

";

echo"

";

}while($sql_row=mysql_fetch_array($sql_result));

?>

注册用户
---------
$sql_row[chinesename]
---------

--------

## list.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);

?>

List

版面:

echo $chinesename;

?>

版主:

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

?>

贴子总数: 发新贴子

while ($sql_row=mysql_fetch_array($sql_result))

{

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

}

?>

回应 主 题 时 间 人气
";

if ($sql_row[renum]!=0)

{

echo "[+$sql_row[renum]]";

}

else

{

echo "[0]";

}

echo"

$sql_row[title]$sql_row[writetime]$sql_row[hits]

页 第页·

if ($page!=1){

$back=$page-1;

echo"首页上一页";

}

if ($page==1){

echo"首页上一页";

}

if($page!=$totalpage){

$next=$page+1;

echo"下一页尾页";

}

if($page==$totalpage){

echo"下一页尾页";

}

?>·

## login.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

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 "

操作成功!

";

?>

o,k

}

else {

show_error(1);

}

?>

## manage_list.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);

?>

List

版面:

echo $chinesename;

?>(管理)

版主:

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

?>

贴子总数: 发新贴子 ">刷新浏览

while ($sql_row=mysql_fetch_array($sql_result))

{

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

}

?>

回应 主 题 时 间 人气
";

if ($sql_row[renum]!=0)

{

echo "[+$sql_row[renum]]";

}

else

{

echo "[0]";

}

echo"

$sql_row[title]$sql_row[writetime]$sql_row[hits]

页 第页·

if ($page!=1){

$back=$page-1;

echo"首页上一页";

}

if ($page==1){

echo"首页上一页";

}

if($page!=$totalpage){

$next=$page+1;

echo"下一页尾页";

}

if($page==$totalpage){

echo"下一页尾页";

}

?>·转到第

}

else {

show_error(4);

}

?>

相关推荐