首頁 > 教學 > PHP 教學

php 文章管理_PHP教程

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！
/**
* 文章
* 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的專欄

http://www.bkjia.com/PHPjc/478371.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/478371.htmlTechArticle?php /** * 文章 * 2011/9/21 * kcj * */ include isLogin.php; include ../conn/config.inc.php; include_once(../FCKeditor/fckeditor.php); $oFCKeditor = new FCKeditor(content) ; // 建立...

    • 本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

    聯繫我們

    該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

    如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    Get Started for Free

    • Sales Support

      1 on 1 presale consultation

      Chat Contact Sales

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

      Open a Ticket

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

      Learn More