php 文章管理-php手册-php.cn

Home

php教程

php手册

php 文章管理

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 am 10:47 AM

includephparticlemanage

/**
* 文章
* 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 "审核失败！";
}

}

摘自 chaojie2009的专栏

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055612 fails to install in Windows 10?

4 weeks agoByDDD

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks agoByDDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Nordhold: Fusion System, Explained

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Zend Studio 13.0.1

Powerful PHP integrated development environment

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Hot Topics

1670

1428

1329

1276

1256