您好,欢迎访问一九零五行业门户网

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

###############index.php######################
全部类别
$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 共:.$total.篇.$total_page.页
;
  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 [$topic[type]]$topic[title]($topic[time]);
        if($topic[comm]==1)
          echo ;
        if($topic[locked]==1)
          echo ;
        echo
          阅读:$topic[hits] 次;评论:$topic[p_num]次
;
     }
else
   echo 对不起,本栏 目暂没有任何文章!!!;
echo
;
  ?>
$pre=$page-1;
     $next=$page+1;
if($page>0)
   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];}
      ?>
#####################read_article.php#########################
require./inc/func.php;
if(!$id)
{
  echo;
   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;
?>
echo $data[title]--[$data[type]];?>
其它类似信息

推荐信息