PHP+MYSQL article management system (2)_PHP tutorial

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

  
    
    
  


  
    
  


  
    
    
  

    
  
  全部类别
$num=count($typ);
for($i=2;$i<=$num;$i++)
{
  echo"$typ[$i]";}
      ?>
  
  
  全部内容
  文章内容
  文章标题
  加入时间
  
  
  
  

$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:                                                    ;$i<$total_page;$i++) { $p=$i+1; echo " if($page==$i ) echo " selected" ; echo ">Page ".$p."n"; } ?> form>

Select column: echo $php_self;?>?type='+document.forms[2].elements[0].value;" >             $num=count($typ); for($i=0;$i<$num;$i++) { echo "$typ[ $i]";} ?> "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;
?>








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

      
        
        
          
          
          

src="images/third-close.gif" width=17 align=absMiddle border=0 name=content_r03_c28>

      
        
        
          
          
          
          
          
          
        
        
      

href="read_article.php?id=">

href="read_article.php?id=">

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 "暂时没有本文章的相关评论!";
  ?>
  

      

  href="javascript:window.close()">关闭窗口

    

 

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