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(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 "锁定失败！";}}?>php
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);}/*=======文章模块相关函数==========*/ PHP 8.5.5 PHP 8.5.5 是 PHP 8.5 分支的维护更新版本。该版本延续了“小步快跑”的迭代逻辑，通过深度错误修复、底层性能微调以及安全加固，旨在为开发者提供一个更健壮、更高效的运行环境。该版本严格遵守语义化版本规范，不包含破坏性变更。
下载/*** 获取所有的文章进行分页用* */ 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.html www.bkjia.com true http://www.bkjia.com/PHPjc/478371.html TechArticle?php /** * 文章 * 2011/9/21 * kcj * */ include isLogin.php; include ../conn/config.inc.php; include_once(../FCKeditor/fckeditor.php); $oFCKeditor = new FCKeditor(content) ; // 创建...