php文章管理模块实例代码

代码如下，实现了文章管理的基本功能，大家注意看注释，知识点还是不少的。

<?php   
    /** 
     *文章管理
      * www.jb200.com
     * */  
    include "isLogin.php";  
    include "../conn/config.inc.php";  
    include_once("../FCKeditor/fckeditor.php");  
    $oFCKeditor = new FCKeditor("content") ;          // 创建FCKeditor实例，可创建多个实例  
    $oFCKeditor->BasePath = '../FCKeditor/';          // 设置FCKeditor目录地址  
    /*action操作初始化*/  
    if(emptyempty($_REQUEST['action'])){  
        $_REQUEST['action']='list';  
    }else {  
        $_REQUEST['action']=trim($_REQUEST['action']);  
    }  
    if($_REQUEST['action']=='add'){  
          
        $oFCKeditor = new FCKeditor("content") ;          // 创建FCKeditor实例，可创建多个实例  
        $oFCKeditor->BasePath = '../FCKeditor/';          // 设置FCKeditor目录地址  
          
        $tpl->assign('fck',$oFCKeditor->Create());  
        $tpl->assign('tmess','添加文章');  
        $tpl->assign('act','insert');  
        $tpl->assign('submitButton','添加');  
        $tpl->display('admin/addArticle.tpl');  
    }  
    /*添加文章*/  
    elseif ($_REQUEST['action']=='insert'){  
        $title=$_POST['title'];  
        $zhaiyao=$_POST['zhaiyao'];  
        $author=$_POST['author'];  
        $laiyuan=$_POST['laiyuan'];  
        $keyword=$_POST['keyword'];  
        $is_tuijian=$_POST['is_tuijian'];  
        $content=$_POST['content'];  
        $sql="insert into article (title,zhaiyao,author,laiyuan,keyword,is_tuijian,content,addtime) values   
        ('$title','$zhaiyao','$author','$laiyuan','$keyword','$is_tuijian','$content',now())";  
        $rs=$db->query($sql);  
        if($rs){  
            echo header("location:/admin/article.php?action=list");  
        }else {  
            echo "失败！";  
        }  
    }  
    /*文章列表*/  
    elseif ($_REQUEST['action']=='list'){  
        $total=getAllArticle();  
        $curpage=isset($_GET['page'])?$_GET['page']:1;  
        $pageObj=new Page($total,$curpage);  
        $pageInfo=$pageObj->getPageInfo();  
        $arts=getArticlePage($pageInfo['row_offset'],$pageInfo['row_num']);  
        $tpl->assign("tmess","文章列表");  
        $tpl->assign("arts",$arts);  
        $tpl->assign("pageInfo",$pageInfo);  
        $tpl->display("admin/editArticle.tpl");  
    }  
    /*修改文章*/  
    elseif ($_REQUEST['action']=='edit'){  
        $id=$_GET['id'];  
        $post=editArticle($id);  
          
        $tpl->assign("tmess","修改文章");  
        $tpl->assign('post',$post);  
        $oFCKeditor->Value=$post["content"];              //编辑时显示文章内容  
        if($post['is_tuijian']==1||$_POST["recommend"]==1){   //判断是否推荐  
            $tpl->assign('recommend','checked');  
        }else {  
            $tpl->assign('no_recommend','checked');  
        }  
        $tpl->assign('fck',$oFCKeditor->Create());  
        $tpl->assign("act","update");  
        $tpl->assign('submitButton','修改');  
        $tpl->display('admin/addArticle.tpl');  
    }elseif ($_REQUEST['action']=='update'){  
        $id=$_POST['id'];  
        $title=$_POST['title'];  
        $zhaiyao=$_POST['zhaiyao'];  
        $author=$_POST['author'];  
        $laiyuan=$_POST['laiyuan'];  
        $keyword=$_POST['keyword'];  
        $is_tuijian=$_POST['is_tuijian'];  
        $content=$_POST['content'];  
        $sql="update article set title='$title',zhaiyao='$zhaiyao',author='$author',laiyuan='$laiyuan',keyword='$keyword',is_tuijian='$is_tuijian',  
        content='$content' where id ='$id'";  
        $rs=$db->query($sql);  
        if($rs){  
            echo header("location:/admin/article.php?action=list");  
        }else {  
            echo "修改失败！";  
        }  
    }  
    /*删除*/  
    elseif ($_REQUEST['action']=='del'){  
        $id=$_GET['id'];  
        del($id);  
    }  
    /*审核文章*/  
    elseif ($_REQUEST['action']=='shenhe'){  
        $id=$_GET['id'];  
        shenhe($id);  
    }  
    /*锁定文章*/  
    elseif ($_REQUEST['action']=='lock'){  
        $id=$_GET['id'];  
        lock($id);  
    }  
    /*批量删除*/  
    /*批量审核*/  
    elseif (isset($_REQUEST['shenhe_x'])||isset($_REQUEST['shenhe_y'])){  
        $del=$_POST['del'];  
        shenhe($del);  
    }  
    /*批量锁定*/  
    elseif (isset($_REQUEST['lock_x'])||isset($_REQUEST['lock_y'])){  
        $del=$_POST['del'];  
        lock($del);  
    }
         
    /*==--文章模块相关函数===*/  
      
    /** 
     * 获取所有的文章进行分页用 
     * */  
    function getAllArticle(){  
        global $db;  
        $sql="select * from article";  
        $rs=$db->query($sql);  
        $total=$db->num_rows($rs);  
        return  $total;  
    }  
    /*文章分页相关函数*/  
    function getArticlePage($offset,$num){  
        global $db;  
        $sql="select*from article order by id desc limit $offset,$num";  
        $rs=$db->query($sql);  
        while ($row=$db->fetch_array($rs)){  
            $data[]=$row;  
        }  
        return $data;  
    }  
    /*文章修改*/  
    function editArticle($id){  
        global $db;  
        $sql="select * from article where id = '$id'";  
        $rs=$db->query($sql);  
        return $row=$db->fetch_array($rs,mysql_ASSOC);  
      
    }  
    /*删除文章*/  
    function del($id){  
        global $db;  
        $sql="delete from article where id";  
        if(is_array($id)){  
            $sql.="IN (".implode(",","$id").")";  
        }else {  
            $sql.="=$id";  
        }  
        $rs=$db->query($sql);  
        if($rs){  
            echo header("location:/admin/article.php?action=list");  
        }else {  
            echo "删除失败！";  
        }  
    }  
    function shenhe($id){  
        global $db;  
        $sql="update article set status='1' where id";  
        if(is_array($id)){  
            $sql.="IN (".join(",",$id).")";      //如果$id是一个数组，用join函数把$id分割成用，连接的字符串 join是implode的别名  
        }else {  
            $sql.="=$id";  
        }  
        $rs=$db->query($sql);  
        if($rs){  
            echo header("location:/admin/article.php?action=list");   
        }else {  
            echo "审核失败！";  
        }  
          
    }  
      
    function lock($id){  
        global $db;  
        $sql="update article set status='0' where id ";  
        if(is_array($id)){  
            $sql.="IN (".implode(",","$id").")";  
        }else {  
            $sql.="=$id";  
        }  
        $rs=$db->query($sql);  
        if($rs){  
            echo header("location:/admin/article.php?action=list");   
        }else {  
            echo "锁定失败！";  
        }  
    }  
?>