论坛
## 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" $sql_row[chinesename] ";
echo" ";
}while($sql_row=mysql_fetch_array($sql_result));
?>
---------
--------
## 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$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" ";
if ($sql_row[renum]!=0)
{
echo " [+$sql_row[renum]] ";
}
else
{
echo "[0]";
}
echo" ";
echo" $sql_row[title] ";
echo" $sql_row[writetime] ";
echo" $sql_row[hits] ";
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$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" ";
if ($sql_row[renum]!=0)
{
echo " [+$sql_row[renum]] ";
}
else
{
echo "[0]";
}
echo" ";
echo" $sql_row[title] ";
echo" $sql_row[writetime] ";
echo" $sql_row[hits] ";
echo" ";
}
?>
}
else {
show_error(4);
}
?>
以上就介绍了merry merry christmas 基于mysql的论坛（4），包括了merry merry christmas方面的内容，希望对PHP教程有兴趣的朋友有所帮助。
查看更多关于merrymerrychristmas基于mysql的论坛（4）的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did62088