Home > Article > Backend Development > PHP article management_PHP tutorial
PHP article management_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:49:121152browse
/**
* Article
* 2011/9/21
* kcj
**/
include "isLogin.php";
include "../conn/config.inc.php";
include_once("../FCKeditor/fckeditor.php");
$oFCKeditor = new FCKeditor("content") ; // Create an FCKeditor instance, multiple instances can be created
$oFCKeditor->BasePath = '../FCKeditor/'; // Set the FCKeditor directory address
/*action operation initialization*/
if(emptyempty($_REQUEST['action'])){
$_REQUEST['action']='list';
}else {
$_REQUEST['action']=trim($_REQUEST['action']);
}
if($_REQUEST['action']=='add'){
$oFCKeditor = new FCKeditor("content") ; //Create FCKeditor instance, multiple instances can be created
$oFCKeditor->BasePath = '../FCKeditor/'; // Set the FCKeditor directory address
$tpl->assign('fck',$oFCKeditor->Create());
$tpl->assign('tmess','Add article');
$tpl->assign('act','insert');
$tpl->assign('submitButton','Add');
$tpl->display('admin/addArticle.tpl');
}
/*Add article*/
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 "Failed!";
}
}
/*Article list*/
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","Article List");
$tpl->assign("arts",$arts);
$tpl->assign("pageInfo",$pageInfo);
$tpl->display("admin/editArticle.tpl");
}
/*Modify article*/
elseif ($_REQUEST['action']=='edit'){
$id=$_GET['id'];
$post=editArticle($id);
$tpl->assign("tmess","Modify article");
$tpl->assign('post',$post);
$oFCKeditor->Value=$post["content"]; //Show article content when editing
If($post['is_tuijian']==1||$_POST["recommend"]==1){ //Determine whether to recommend
$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);
}
/*=======文章模块相关函数==========*/
/**
* Get all articles for pagination
**/
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 "Deletion failed!";
}
}
function shenhe($id){
global $db;
$sql="update article set status='1' where id";
If(is_array($id)){
$sql.="IN (".join(",",$id).")"; //If $id is an array, use the join function to split $id into parts. The connected string join is implode Alias
}else {
$sql.="=$id";
}
$rs=$db->query($sql);
If($rs){
echo header("location:/admin/article.php?action=list");
}else {
echo "Audit failed!";
}
}
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 "Lock failed!";
}
}
?>
/**
* Article
* 2011/9/21
* kcj
**/
include "isLogin.php";
include "../conn/config.inc.php";
include_once("../FCKeditor/fckeditor.php");
$oFCKeditor = new FCKeditor("content") ; // Create FCKeditor instance, multiple instances can be created
$oFCKeditor->BasePath = '../FCKeditor/'; //Set the FCKeditor directory address
/*action operation initialization*/
if(empty($_REQUEST['action'])){
$_REQUEST['action']='list';
}else {
$_REQUEST['action']=trim($_REQUEST['action']);
}
if($_REQUEST['action']=='add'){
$oFCKeditor = new FCKeditor("content") ; // Create an FCKeditor instance, multiple instances can be created
$oFCKeditor->BasePath = '../FCKeditor/'; $oFCKeditor->BasePath = '../FCKeditor/'; // Set the FCKeditor directory address
$tpl->assign('fck',$oFCKeditor->Create());
$tpl->assign('tmess','Add article');
$tpl->assign('act','insert');
$tpl->assign('submitButton','Add');
$tpl->display('admin/addArticle.tpl');
}
/*Add article*/
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 "Failure!";
}
}
/*Article list*/
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","Article List");
$tpl->assign("arts",$arts);
$tpl->assign("pageInfo",$pageInfo);
$tpl->display("admin/editArticle.tpl");
}
/*Modify article*/
elseif ($_REQUEST['action']=='edit'){
$id=$_GET['id'];
$post=editArticle($id);
$tpl->assign("tmess","Modify article");
$tpl->assign('post',$post);
$oFCKeditor->Value=$post["content"]; //Show article content when editing
if($post['is_tuijian']==1||$_POST["recommend"]==1){ //Determine whether to recommend
$tpl->assign('recommend','checked');
}else {
$tpl->assign('no_recommend','checked');
}
$tpl->assign('fck',$oFCKeditor->Create());
$tpl->assign("act","update");
$tpl->assign('submitButton','Modify');
$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 "Modification failed!";
}
}
/*Delete*/
elseif ($_REQUEST['action']=='del'){
$id=$_GET['id'];
del($id);
}
/*Review article*/
elseif ($_REQUEST['action']=='shenhe'){
$id=$_GET['id'];
shenhe($id);
}
/*Lock article*/
elseif ($_REQUEST['action']=='lock'){
$id=$_GET['id'];
lock($id);
}
/*Batch delete*/
/*Batch review*/
elseif (isset($_REQUEST['shenhe_x'])||isset($_REQUEST['shenhe_y'])){
$del=$_POST['del'];
shenhe($del);
}
/*Batch lock*/
elseif (isset($_REQUEST['lock_x'])||isset($_REQUEST['lock_y'])){
$del=$_POST['del'];
lock($del);
}
/*========Article module related functions==========*/
/**
* Get all articles for pagination
**/
function getAllArticle(){
global $db;
$sql="select * from article";
$rs=$db->query($sql);
$total=$db->num_rows($rs);
return $total;
}
/*Article pagination related functions*/
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;
}
/*Article modification*/
function editArticle($id){
global $db;
$sql="select * from article where id = '$id'";
$rs=$db->query($sql);
return $row=$db->fetch_array($rs,MYSQL_ASSOC);
}
/*Delete article*/
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 "Delete failed!";
}
}
function shenhe($id){
global $db;
$sql="update article set status='1' where id";
if(is_array($id)){
$sql.="IN (".join(",",$id).")"; //If $id is an array, use the join function to split $id into parts. The connected string join is implode Alias
}else {
$sql.="=$id";
}
$rs=$db->query($sql);
if($rs){
echo header("location:/admin/article.php?action=list");
}else {
echo "Audit failed!";
}
}
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 "Lock failed!";
}
}
?>