PHP+MYSQL的文章管理系统(二)

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

  
    
    
  


  
    
  


  
    
    
  

    
  
  全部类别
$typ=file("list.txt");
$num=count($typ);
for($i=2;$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 " 对不起,本栏 目暂没有任何文章!!!";
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 "上一页 "; else   echo "上一页 ";  ?>

echo "   下一页 "; else echo "   下一页 ";?>

跳转到:                       for($i=0;$i    {      $p=$i+1;      echo "     if($page==$i) echo " selected" ;      echo ">第".$p."页n";      } ?>

选择栏目:         ?type='+document.forms[2].elements[0].value;" >            $typ=file("list.txt"); $num=count($typ); for($i=0;$i{   echo"$typ[$i]";}       ?>

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