PHP MYSQL的文章管理系統(二)_PHP教程

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

  
    
    
  
表>

  
    
  
表>

  
    
    
 名稱=“類型”>
  全部類別選項>
$typ=檔案("列表.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(空白($page))
    $page=0;
  if(空白($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))
   40)
          {
            $topic[title]=substr($topic[title],0,40) ;
            $topic[title]=$topic[title].".....";
          }
         if(trim($topic[time])==date(年月日)) 時間]字體>";
           echo"
          ";
     }
else
   echo 「 對不起

共:".$total."篇".$total_page."頁

[$topic[type]]$topic[title] ;($topic[時間])";
        if($topic[comm]==1)
          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;      if($page==$i) echo " selected" ;      echo ">第".$p."頁n";    select>

選擇欄位:         ?type=' document.forms[2].elements[0].value;" >         file("list.txt"); $num=count($typ); for($i=0;$i{   echo"$typ[$i]";}       ?>

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=myfetch_array($res) $pre=$data[id]-1;
$next=$data[id] 1;
?>