Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > marc by marc jacobs official website forum based on mysql (6)

marc by marc jacobs official website forum based on mysql (6)

WBOY
Release： 2016-07-29 08:34:14
Original
1055 people have browsed it

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


发新贴子







    
    
  
    
    




发 贴 子

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

If you have not registered yet, pleaseClick hereGo to the registration page)


Your post will be published in< b>section





 
 
  < td width="224"> value="" size="17" maxlength="16">
                                                                                               /td> password" name="password" size="10" maxlength="16" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">
         < font color="#FF0000">*
                          < td colspan = "4" style="font-size: 9pt; background-color: #FFFFFF; color: ##3366FF; border: 1 solid #000000">
            * < ;/td>
                                                                   

                                                                                                                                                                    ="Cancel"                                                                                                                                                                                               color="#FFFFFF">Use signature
                                                                                                               td>
;
# query.php
require("func.php");
$sql="select * from boardinfo";
$sql_result=mysql_query($sql);
?>


main




Username:

    
    
  
    
    
  
    
    
  
  
    
  

      
论坛贴子查询

    

      
        在  
        
        中查询

        
        

        
        
        
      
    

      
论坛信息

    


    



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



    
    
    共页 第页·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];
         $c
         $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];
     $c
     $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：]

}
?>

  
    
      
    
  

        
          
            
          
        
回复

      

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

                                                                                                       
?>

The above introduces the mysql-based forum (6) of marc by marc jacobs official website, including the content of marc by marc jacobs official website. I hope it will be helpful to friends who are interested in PHP tutorials.


Related labels：
marc by marc jacobs 官网
source：php.cn
Previous article：photoshop cs4 Chinese version download PHP4 practical application experience 2 Next article：Can I recharge Alipay with a credit card? Credit card verification procedure
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2240
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2380
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1990
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1877
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1947
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template

Public welfare online PHP training，Help PHP learners grow quickly！

About us Disclaimer Sitemap

© php.cn All rights reserved