Home >Backend Development >PHP Tutorial >Forum based on mysql (6)_PHP tutorial

Forum based on mysql (6)_PHP tutorial

WBOYOriginal: 2016-07-21 16:03:01890browse

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

main

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="">

论坛贴子查询

论坛信息

# 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：]

}
?>

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：PHP4 Practical Application Experience (1)_PHP TutorialNext article：PHP4 Practical Application Experience (1)_PHP Tutorial

See more

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

Forum based on mysql (6)_PHP tutorial

Related articles