Forum based on mysql (6)_PHP tutorial

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

---

    
    
  
    
    


Your post will be published insection

< /table>

发 贴 子

    

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

If you have not registered yet, pleaseClick here< ;/a>Go to registration page)

 
 
                                                                                                               style="font-size: 9pt; background-color: #FFFFFF; color: #3366FF; border: 1 solid #000000" value="" size="17 " maxlength="16">
  *
 
                                                                    "16" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">
  *< /font>



 





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

Username:

Password:

Theme: -size: 9pt; background-color: #FFFFFF; color: ##3366FF; border: 1 solid #000000">      *                                                                    br>                                                                      input type="button" name="Submit2" value="Cancel" onclick="window.close()">                                                                                                                                                                          type="hidden" name="board" value="">

    
    
  
    
    
  
    
    
  
  
    
  

      

论坛贴子查询

    

      

        在  
        
          请选择版面
while($sql_row=mysql_fetch_array($sql_result)){
?>  
          
}
?>
        
        中查询

        
        

        
        
        
      

    

      

论坛信息

    

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












  
    
    
    
    
  

版面：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]

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

---

  
    
  
  
    
  
    
    
  
  
    
  

标题：

作者：()　')">　

※ 来源： [◆FROM：]

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

  
    
  
  
    
  
    
    
  
  
    
  

标题：

作者：()　')">　">

※ 来源： [◆FROM：]

}
?>

  
    
      
    
  

        
          
            
          
        

回复

      

  
    
      
      
      
      
    
    
      
      
    
    
      
      
    
    
      
      
    
  

用户名	">         *	密码	*
标题：	*
内容：
	使用签名

    }
  ?>
  

 

http://www.bkjia.com/PHPjc/316374.htmlwww.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发...