php文章代码,php文章管理模块实例代码

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

/**

*文章管理

* www.jbxue.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 "锁定失败！";

}

}

?>