php 文章管理(2)

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