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

###############index.php######################
<?session_start();
require”./inc/func.php”;
mscon();
require “./inc/header.inc”;
?>

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

“; ?>

<?if($page<$total_pag来源[email protected]搞@^&代*@码网e-1)
echo ” 下一页

“;
else echo ” 下一页

“;?>

跳转到:
        <select name="page" onchange="top.location='?page=’+document.forms[1].elements[0].value+’&type=’;” class=”border”>
          <?
  for($i=0;$i<$total_page;$i++)
    {
     $p=$i+1;
     echo “<option value=$i";
     if($page==$i) echo ” selected” ;
     echo “>第”.$p.”页n”;
     }
?>

选择栏目:
        <select name="type"   onchange="top.location='?type=’+document.forms[2].elements[0].value;”>
          <? $typ=file("list.txt");
$num=count($typ);
for($i=0;$i<$num;$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;
?>

</p> <p>

<!–
body,table,td,input,textarea {  font-family: “宋体”; font-size: 9pt}
select {  font-family: “宋体”; font-size: 9pt}
code {font-family: “Courier” ; font-size: 10pt}
a {  color: #005500}
a:hover {  color: #CC0000}
.border {border: 1px #000000 solid; background-color:transparent; list-style-position: inside; list-style-type: square}
–>

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

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

发表评论

        您的姓名:

         您的电子邮件:

        仅站长可见:<input type="checkbox" name="pub" value="”>
        <input type="hidden" name="p_id" value="”>

        发表评论:

Hi，您需要填写昵称和邮箱！