基于mysql的论坛（6） -pc6资讯

您的位置：首页 → 网页设计 → PHP实例 → 基于mysql的论坛（6）

基于mysql的论坛（6） 时间：2004/11/7 3:24:00来源：本站整理作者：蓝点我要评论(0)

# 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;?>