Home >Backend Development >PHP Tutorial >Forum based on mysql (4)_PHP tutorial
Forum based on mysql (4)_PHP tutorial
- WBOYOriginal
- 2016-07-21 16:03:051027browse
## index.php
## 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);
?>
| 注册用户 |
| --------- |
| $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);
?>
| 版面：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); ?> | 贴子总数： |  | |
| 回应 | 主 题 | 时 间 | 人气 | |
| "; 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 "
操作成功!
";
?>
}
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);
?>
| 版面：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); ?> | 贴子总数： | | ">刷新浏览 |
| 回应 | 主 题 | 时 间 | 人气 | |
| "; 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);
}
?>
Statement：
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
Previous article：Change the URL into a hyperlink in the string_PHP tutorialNext article：Change the URL into a hyperlink in the string_PHP tutorial