Home  >  Article  >  Backend Development  >  PHP+MYSQL article management system (2)_PHP tutorial

PHP+MYSQL article management system (2)_PHP tutorial

WBOY
WBOYOriginal
2016-07-21 16:06:491219browse

###############index.php######################
require"./inc/func.php";
mscon();
require "./inc/header.inc";
?>




  
    
    
  

      

          
          
          
          
          
        

      

    

          
          
          
          
          

      


  
    
  
 


  

    
    
  

    
  
  
  
  
  


$type=trim($type);
  if($comm)
    {
     $sec="and comm=1";
     $fir="where comm=1";
    }
  if(!empty($type))
    $query="select count(*) from $table where type='$type' $sec";
  else
    $query="select count(*) from $table $fir";
  $res=mysql_db_query("$database",$query);
  if(@mysql_num_rows($res)>0)
    $tot=mysql_fetch_array($res);
  $total=$tot[0];
  $total_page=ceil($total/$pagenum);
  echo "";
  echo "";
  if(empty($page))
    $page=0;
  if(empty($offset))
    $offset=0;
  $offset=$pagenum*$page;
  if(!empty($type))
     $query="select * from $table where type='$type' $sec order by id desc limit $offset,$pagenum";
  else
    $query="select * from $table $fir order by id desc limit $offset,$pagenum";
  $res=mysql_db_query("$database",$query);
  if(@mysql_num_rows($res)>0)
     while($topic=mysql_fetch_array($res))
       {
         if(strlen($topic[title])>40)
          {
            $topic[title]=substr($topic[title],0,40) ;
            $topic[title]=$topic[title].".....";
          }
         if(trim($topic[time])==date(Y年m月d日))
           $topic[time]="$topic[time]";
           echo"
          
          ";
     }
else
echo "Sorry, there are no articles in this column!!!";
echo "
共:".$total."篇".$total_page."页
[$topic[type]]$topic[title]($topic[time])";
        if($topic[comm]==1)
          echo "精品文章";
        if($topic[locked]==1)
          echo "文章已锁定";
        echo "
阅读:$topic[hits] 次;评论:$topic[p_num]次
";
?>











$pre=$page-1;
$next=$page+1;
if($page>0)
echo "Previous page

";
else
echo "Previous page

"; ?>
echo " Next page

";
else echo " Next page

";?>

Jump to:
   

Select column:
echo $php_self;?>?type='+document.forms[2].elements[0].value;" >
            $num=count($typ);
for($i=0;$i<$num;$i++)
{
echo "";}
?>
"post" action=?type= target="_balnk">


####################read_article.php################### ######
require"./inc/func.php";
if(!$id)
{
echo"<script>window. close();</script>";
exit();
}
mscon();
$query="select * from $table where id='$id'";
$res=mysql_db_query("$database",$query);
if(!$res)
{
echo "this article has been deleted or no this article!!";
exit();
}
$data=mysql_fetch_array($res);
add_hits($data[id]);
$pre=$data[id]-1;
$next=$data[id]+1;
?>


<br><? echo "$data[title ]--[$data[type]]";?> <br>





cellPadding=0 align=center borderColorLight=#000000 border=1 width=545>
  
  
    
  
    
    
    
  
  

      
        
        
          
          
          
 
            
              
              
                

                  

                    
                    

                

            
          

      
        
        
          
          
          
          
          
          
        
        
      

            
          

            
          
height=16 src="images/mail.gif" width=16> href="commend.php?id=">推荐给朋友 发表时间:
            
            阅读次数:
            
          
 

    

if($data[locked]<>0)
{
  echo "对不起!本文已经被管理员锁定!";
}
else
  if($data[html]==1)
     highlight_string($data[cont]);
  else
     echo nl2br($data[cont]);
?>
      

cellpadding=0 align=center bordercolorlight=#000000 border=1 width=545>
  

    
  
  
    
  
  
    
  
  
  
  
  
    
  
  

      
发表评论

    


        您的姓名:
        
         您的电子邮件:
        
        仅站长可见:
        
        

        发表评论:
        
        

        

        

          
          
        

        

      
相关评论

    

  $res=mysql_db_query("$database",$query);
  if(mysql_num_rows($res)>0)
   {$i=1;
   while($ping=mysql_fetch_array($res))
    echo "评论人:$ping[name]   电子邮件:$ping[mail]
  ".nl2br($ping[p_cont])."
时间:$ping[time]  来自:$ping[ip]
n" ;
   }
   else
   echo "暂时没有本文章的相关评论!";
  ?>
  

      
    

 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/315322.htmlTechArticle###############index.php###################### ?session_start(); require./inc/func.php; mscon(); require ./inc/header.inc; ? script language=javascript function opwin(filename) {win...
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