php 文章管理

<?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(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 "锁定失败！";
	}
}
?>