PHP+MYSQL的文章管理系统(二)-php手册-PHP中文网

首页

php教程

php手册

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 pm 12:42 PM

php+mysql二文章的管理系统

###############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 " 对不起,本栏目暂没有任何文章!!!";
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 " 下一页

";?>

#####################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>

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn