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

基于mysql的论坛(6)_PHP教程

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

# post.php
require("config.inc.php");
$sql="select * from boardinfo where name='$board'";
$sql_result=mysql_query($sql);
$sql_row=mysql_fetch_array($sql_result);
?>


发新贴子

















发 贴 子

(您必须注册以后才能发表新主题,不然您只能查看主题。

如果您还未注册,请点击这里转到注册页)


您的贴子将被发表在版块








# query.php
require("func.php");
$sql="select * from boardinfo";
$sql_result=mysql_query($sql);
?>


main



















论坛贴子查询



论坛信息





# query_list.php
require("func.php");
if (!empty($query_str)) {

if(!is_board_exits($board)){
$board="computer";
}
if ($title){
$submit="title";
}
elseif ($cont) {
$submit="cont";
}
elseif ($writer) {
$submit="writer";
}
else {
$submit="title";
}
$sql="select * from $board where ($submit like '%$query_str%')";
$temp=mysql_query($sql);
$sum=mysql_num_rows($temp);
if ($sum!=0) {
$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]"." ";
}
# 选择出留言纪录;

$totalpage=ceil($sum/$pagesize);
# 分页
if($page<1 or empty($page)){
$page=1;
}
elseif ($page>$totalpage){
$page=$totalpage;
}
elseif ($totalpage==0) {
$page=0;
}
$offset=($page-1)*$pagesize;
$sql="select * from $board where ($submit like '%$query_str%') 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"";
}
?>



回应 主 题 时 间 人气
";
echo "[*]";
echo"
$sql_row[title]$sql_row[writetime]$sql_row[hits]







}
else
{
show_error(10);
}
}
else {
show_error(9);
}
# read.php
require ("func.php");
if ($re){
$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 (empty($title)){
show_error(2);
$founderr=1;
}
if ($qm){
$qm=expl_qm($name);
}
if(!$founderr){
re_doc($board,$id);
setcookie ("jl_forum[name]",$name);
$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 ($qm){
$qm=expl_qm($name);
}
if (!$founderr){
add_doc($board);
$add=1;
setcookie ("jl_forum[name]",$name);
}
}
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";
$sql_result=mysql_query($sql);
# $sql_row=mysql_fetch_array($sql_result);
}
?>


<?php echo $title;?>
























标题:
作者:() ')">给作者留言 ">察看用户资料
※ 来源: [◆FROM:]



if ($add!=1){
while($sql_row=mysql_fetch_array($sql_result)) {
?>













标题:
作者:() ')">给作者留言 ">察看用户资料
※ 来源: [◆FROM:]

}
?>




www.bkjia.comtruehttp://www.bkjia.com/PHPjc/316374.htmlTechArticle# post.php ?php require(config.inc.php); $sql=select * from boardinfo where name='$board'; $sql_result=mysql_query($sql); $sql_row=mysql_fetch_array($sql_result); ? html head title发...

人气教程排行