当前位置:Gxlcms > PHP教程 > 基于mysql的论坛(4)

基于mysql的论坛(4)

时间:2021-07-01 10:21:17 帮助过:29人阅读

## index.php


论坛



 
 
 

<body bgcolor="#FFFFFF"> <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);
}
?>

人气教程排行