Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > Forum based on mysql (4)_PHP tutorial

Forum based on mysql (4)_PHP tutorial

WBOY
Release： 2016-07-21 16:03:05
Original
1032 people have browsed it

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



    共页 第页·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);
}
?> 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/316365.htmlTechArticle## index.php html head title论坛/title meta http-equiv=Content-Type content=text/html; charset=gb2312 /head frameset cols=125,* rows=* border=0 frameborder=0 frame src=left.php na...
Related labels：
c head html index.php meta mysql title based on of forum
source：php.cn
Previous article：Change the URL into a hyperlink in the string_PHP tutorial Next article：PHP4 Practical Application Experience (3)_PHP Tutorial
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1335
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Creating this specific design using a grid: a step-by-step guide I'm trying to create a layout similar to this image, I've tried using this grid but can't ...
From 2024-04-06 20:29:08
0
2
492
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template