php 文章管理

/**
 * 文章
 * 2011/9/21
 * kcj
 * */ 
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 "锁定失败！"; 
    } 
} 
?> 
/**
 * 文章
 * 2011/9/21
 * kcj
 * */
include "isLogin.php";
include "../conn/config.inc.php";
include_once("../FCKeditor/fckeditor.php");
$oFCKeditor = new FCKeditor("content") ;          // 创建FCKeditor实例，可创建多个实例
$oFCKeditor->BasePath = '../FCKeditor/';          // 设置FCKeditor目录地址
/*action操作初始化*/
if(empty($_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 "锁定失败！";
 }
}
?>

摘自 chaojie2009的专栏