分类分类

基于mysql的论坛（4）

关注+2004-11-07作者：蓝点

## index.php

<a href="http://www.pc6.com/pc/luntan/" target="_blank">论坛</a>







<body bgcolor="#FFFFFF"> <br><BR> <br><BR> </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]

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

}

else {

show_error(4);

}

?>

展开全部

相关文章

更多+相同厂商

热门推荐

最新排行
最热排行
评分最高

排行榜

点击查看更多

点击查看更多

点击查看更多

~~说两句~~网友评论

我要评论...

取消