基于mysql的论坛（3）_php教程-查字典教程网

#####################

# func.php #########

####################

<?php

require("config.inc.php");

##### 检查用户是否存在 #####

function is_user_exits($name) {

$name=trim($name);

$name=ereg_replace("'","‘",$name);

$name=htmlspecialchars($name);

$SQL="SELECT name FROM user WHERE name='$name'";

$result=mysql_query($SQL) or die(mysql_error());

$row=mysql_fetch_Array($result);

$name=$row[name];

return $name;

}

##### 检查版面是否存在 #####

function is_board_exits($baord){

$sql="select name from boardinfo where name='$baord'";

$result=mysql_query($sql) or die("出现错误");

$row=mysql_fetch_array($result);

$name=$row[name];

return $name;

}

##### 添加新用户 Function #####

function adduser(){

global $name,$sex,$realname,$password,$address,$oicq,$homepage,$phone,$email,$qm,$regtime;

$name=trim($name);

$name=ereg_replace("'","‘",$name);

$password=trim($password);

$name=htmlspecialchars($name);

$realname=htmlspecialchars($realname);

$address=htmlspecialchars($address);

$oicq=htmlspecialchars($oicq);

$homepage=htmlspecialchars($homepage);

$phone=htmlspecialchars($phone);

$email=htmlspecialchars($email);

$qm=htmlencode2($qm);

$regtime=date("Y-m-d H:i:s");

$sql="insert into user (name,sex,realname,password,address,oicq,homepage,score,phone,email,qm,regtime,slaveboard) values('$name','$sex','$realname','$password','$address','$oicq','$homepage','0','$phone','$email','$qm','$regtime','')";

mysql_query($sql) or die(mysql_error());

}

##### URL 重定向 ######

function redirect2($url){

header("Location:$url");

}

##### 创建版面 ######

function create_board_table($name,$chinesename){

$name=trim("$name");

$sql="CREATE TABLE $name(id int(11) NOT NULL AUTO_INCREMENT,title varchar(50) NOT NULL,writer varchar(50) NOT NULL,cont longtext, size int,writetime varchar(20) NOT NULL,hits int(4) DEFAULT '0',good varchar(1),renum int(4) DEFAULT '0',slaveid int(11) DEFAULT '0',fromip varchar(15),PRIMARY KEY (id))";

mysql_query($sql);

$sql="insert into boardinfo (name,chinesename) values('$name','$chinesename')";

mysql_query($sql);

}

###### 删除版面 ######

function drop_board_table($name){

$sql="drop table $name";

mysql_query($sql);

$sql="delete from boardinfo where name='$name'";

mysql_query($sql);

}

######## 修改版面 ###

function update_board($name,$chinesename) {

$sql="update boardinfo set name='$name',chinesename='$chinesename' where name='$name'";

mysql_query($sql);

}

##### 添加文章 ######

function add_doc($board){

global $title,$name,$cont,$writer,$fromip,$writetime,$qm,$new_topic_score;

$title=trim($title);

$title=substr($title,0,49);

$size=strlen($cont);

$cont=htmlencode2($cont);

$cont=$cont."<br>"."-------<br>".$qm;

$writetime=date("Y-m-d H:i:s");

$fromip=getenv("remote_addr");

$name=htmlspecialchars($name);

$writer=$name;

$sql="insert into $board (title,writer,cont,size,writetime,fromip) values('$title','$name','$cont','$size','$writetime','$fromip')";

mysql_query($sql);

add_score($writer,$new_topic_score);

}

##### 回复文章 #####

function re_doc($board,$slaveid){

global $title,$name,$cont,$writer,$fromip,$writetime,$qm,$re_topic_score;

$title=trim($title);

$title=substr($title,0,49);

$size=strlen($cont);

$cont=htmlencode2($cont);

$cont=$cont."<br>"."-------<br>".$qm;

$writetime=date("Y-m-d H:i:s");

$name=htmlspecialchars($name);

$writer=$name;

$fromip=getenv("remote_addr");

$sql="insert into $board (title,writer,cont,size,writetime,slaveid,fromip) values('$title','$writer','$cont','$size','$writetime','$slaveid','$fromip')";

mysql_query($sql);

$sql="update $board set renum=renum+1 where id=$slaveid";

mysql_query($sql);

add_score($writer,$re_topic_score);

}

##### 删除文章 ####

function del_doc($board,$id){

global $remove_score;

$sql="select * from $board where id=$id";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

$writer=$sql_row[writer];

remove_score($writer,$remove_score);

$slaveid=$sql_row[slaveid];

$sql="select * from $board where id=$slaveid";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

if ($sql_row[renum]>0){

$sql="update $board set renum=renum-1 where id=$slaveid";

mysql_query($sql);

}

$sql="delete from $board where id=$id";

mysql_query($sql);

$sql="delete from $board where slaveid=$id";

mysql_query($sql);

}

#### 转换 html 特殊字符和 <br> #####

function htmlencode2($str){

$str=htmlspecialchars($str);

$str=nl2br($str);

return $str;

}

##### 增加一个 hit ####

function add_one_hit($board,$id){

$sql="update $board set hits=hits+1 where id=$id";

mysql_query($sql);

}

##### 检查用户密码 ####

function check_user_password($name,$password){

$name=trim($name);

$name=ereg_replace("'","‘",$name);

$name=htmlspecialchars($name);

$password=trim($password);

$sql="select password from user where name='$name'";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

if($password<>$sql_row[password]){

$result=0;

}

else{

$result=1;

setcookie ("jl_forum[name]",$name);

setcookie ("jl_forum[password]",$password);

}

return $result;

}

##### 检查管理员密码 ####

function check_admin_password(){

$sql="select * from user where name='$jl_forum[name]'";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

if ($jl_forum[password]==$sql_row[password]){

$result=1;

}

else {

$result=0;

}

if ($sql_row[slaveboard]==$jl_forum[board]){

$result=1;

}

else {

$result=0;

}

return $result;

}

##### 修改个人资料 ####

function change_profile($name){

global $sex,$realname,$password,$address,$oicq,$homepage,$phone,$email,$qm;

$name=trim($name);

$name=htmlspecialchars($name);

$realname=htmlspecialchars($realname);

$address=htmlspecialchars($address);

$oicq=htmlspecialchars($oicq);

$homepage=htmlspecialchars($homepage);

$phone=htmlspecialchars($phone);

$email=htmlspecialchars($email);

$qm=htmlencode2($qm);

$sql="update user set sex='$sex',realname='$realname',password='$password',address='$address',oicq='$oicq',homepage='$homepage',phone='$phone',email='$email',qm='$qm' where name='$name'";

mysql_query($sql);

}

##### 显示错误 ####

function show_error($id){

redirect2("wrong.php?id=$id");

}

##### 增加版主 ####

function add_admin($board,$name){

$name=trim($name);

$sql="update user set slaveboard='$board' where name='$name'";

mysql_query($sql);

}

##### 删除版主 #####

function del_admin($name){

$name=trim($name);

$name=htmlspecialchars($name);

$sql="update user set slaveboard='' where name='$name'";

mysql_query($sql);

}

##### 贴子转精华 ####

function set_good($board,$id){

$sql="update $board set good='y' where id=$id";

mysql_query($sql);

}

##### 转出精华 ###

function set_no_good($board,$id){

$sql="update $board set good='' where id=$id";

mysql_query($sql);

}

##### 导出签名 #####

function expl_qm($name){

$name=htmlspecialchars($name);

$sql="select qm from user where name='$name'";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

$qm=$sql_row[qm];

return $qm;

}

##### 管理员 #####

function adminok() {

if ($jl_admin[name]==$admin_name and $jl_admin[password]==$admin_password) {

return 1;

}

else {

return 0;

}

##### 增加积分 #####

function add_score($name,$num) {

$name=htmlspecialchars($name);

$sql="update user set score=score+$num where name='$name'";

mysql_query($sql);

}

##### 减少积分 ####

function remove_score($name,$num) {

$name=htmlspecialchars($name);

$sql="update user set score=score-$num where name='$name'";

mysql_query($sql);

}

#### 发送留言 ####

function sendmsg() {

global $fromname,$name,$cont;

$name=htmlspecialchars($name);

$fromname=htmlspecialchars($fromname);

$cont=htmlencode2($cont);

$wt=date("Y-m-d H:i:s");

$sql="insert into message (name,fromname,cont,writetime) values ('$name','$fromname','$cont','$wt')";

mysql_query($sql);

}

#### 删除留言 ####

function delmsg($id) {

$sql="delete from message where id=$id";

mysql_query($sql);

}

### 留言是否属于这个人 #####

function is_this_user($id) {

$sql="select name from message where id=$id";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_row($sql_result);

if ($sql_row[name]==$jl_forum[name]) {

return 1;

}

else {

return 0;

}

##########################

# good.php ##########

########################

<?php

require("func.php");

$sql="select * from boardinfo";

$sql_result=mysql_query($sql);

<html>

<head>

</head>

<td>

<div align="center"><b>论坛精华区</b></div>

</td>

</tr>

<td>

<option selected>请选择版面</option>

<?php

while($sql_row=mysql_fetch_array($sql_result)){

<?php

}

</select>

<br>

</form>

</td>

</tr>

<td>

</td>

</tr>

<tr>

<td>

<?php include "info.php";?>

</td>

</tr>

</table>

</body>

</html>

###########################

# good_list.php ###########

###########################

<?php

require("func.php");

if(!is_board_exits($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);

<html>

<head>

function openwin(board,id){window.open("good_read.php?board="+board+"&id="+id,"","height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");

}

function post(board){window.open("post.php?board="+board,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");

}

</script>

</head>

<?php include "header.php";?> <br>

<tr>

<td height="20" width="22%" bgcolor="#eeeeee">版面：<?php

echo $chinesename;

?>精华区</td>

<td height="20" width="34%" bgcolor="#eeeeee">版主：<?php

while ($sql_row=mysql_fetch_array($sql_result))

{

echo "$sql_row[name]"."";

}

# 选择出留言纪录;

$sql="select * from $board where good='y'";

$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 good='y' order by id desc limit $offset,$pagesize";

$sql_result=mysql_query($sql);

?> </td>

</tr>

</table>

<br>

</tr>

</tr>

<?php

while ($sql_row=mysql_fetch_array($sql_result))

{

echo"<tr>";

echo"<td width="6%" bgcolor="#FFF5DD" align="center">";

echo "[*]";

echo"</td>";

echo"<td bgcolor="#E8FDEE" width="56%"><font face="宋体"><a href='javascript:openwin("$board",$sql_row[id])' title="作者:$sql_row[writer]大小:$sql_row[size]字节">$sql_row[title]</a></font></td>";

echo"<td width="18%" bgcolor="#FFF5DD" align="center">$sql_row[writetime]</td>";

echo"<td width="6%" bgcolor="#E8FDEE" align="center">$sql_row[hits]</td>";

echo"</tr>";

}

</tr>

</table>

共<b><?php echo $totalpage;?></b>页第<b><?php echo $page;?></b>页·<?php

if ($page!=1){

$back=$page-1;

echo"<a href="$php_self?board=$board&page=1">首页</a><a href="$php_self?board=$board&page=$back">上一页</a>";

}

if ($page==1){

echo"首页上一页";

}

if($page!=$totalpage){

$next=$page+1;

echo"<a href="$php_self?board=$board&page=$next">下一页</a><a href="$php_self?board=$board&page=$totalpage">尾页</a>";

}

if($page==$totalpage){

echo"下一页尾页";

}

?>·

页

</form>

</div>

<?php include "footer.php";?>

</body>

</html>

############################

###good_read.php ######

######################3

<?php

require ("func.php");

if ($re){

if (!is_board_exits($board)){

show_error(7);

$founderr=1;

}

$sql="select slaveid from $board where id=$id";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

if($sql_row[slaveid]!=0){

show_error(1);

$founderr=1;

}

if (!check_user_password($name,$password)){

show_error(4);

$founderr=1;

}

if (strlen($title)>50){

show_error(6);

$founderr=1;

}

if (empty($title)){

show_error(2);

$founderr=1;

}

if ($qm){

$qm=expl_qm($name);

}

if(!$founderr){

re_doc($board,$id);

$sql="select * from $board where id=$id";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

$title=$sql_row[title];

$writer=$sql_row[writer];

$cont=$sql_row[cont];

$writetime=$sql_row[writetime];

$hits=$sql_row[$hits];

$fromip=$sql_row[fromip];

$sql="select * from $board where slaveid=$id";

$sql_result=mysql_query($sql);

# $sql_row=mysql_fetch_array($sql_result);

}

elseif ($add){

if (!is_board_exits($board)){

show_error(7);

$founderr=1;

}

if (empty($title)){

show_error(2);

$founderr=1;

}

if (!check_user_password($name,$password)){

show_error(4);

$founderr=1;

}

if (strlen($title)>50){

show_error(6);

$founderr=1;

}

if ($qm){

$qm=expl_qm($name);

$founderr=1;

}

if (!$founderr){

add_doc($board);

}

else {

if (!is_board_exits){

show_error(7);

}

add_one_hit($board,$id);

$sql="select * from $board where id=$id";

$sql_result=mysql_query($sql);

$sql_row=mysql_fetch_array($sql_result);

$title=$sql_row[title];

$writer=$sql_row[writer];

$cont=$sql_row[cont];

$writetime=$sql_row[writetime];

$hits=$sql_row[$hits];

$fromip=$sql_row[fromip];

$sql="select * from $board where slaveid=$id order by id desc";

$sql_result=mysql_query($sql);

#$sql_row=mysql_fetch_array($sql_result);

}

<html>

<head>

function sendmsg(name){window.open("sendmsg.php?name="+name,"","height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");

}

</script>

</head>

<?php include "ad.php";?><br>

</tr>

<tr>

</tr>

<tr>

</tr>

</tr>

</table>

<br>

<?php include"footer.php";?><br>

</body>

</html>