在/common/function.php
<?php
//自定义的函数 过滤gpc防止注入
function filterstr($value){
$value=trim($value);
if(!get_magic_quotes_gpc()){
$value = addslashes($value);
return $value;
}
return $value;
}
function redirect($ms ='', $url='', $text=''){
echo <<<EOT
<meta http-equiv="refresh" content=$ms;URL=$url>
<div align="center">
<table width="600" border="0" cellpadding="1" cellspacing="1" class="tableoutline">
<tr>
<td colspan="3"><table width="100%" border="0" cellpadding="5" cellspacing="1">
<tr>
<td valign="bottom"><div align="center">页面操作提示</div></td>
</tr>
<tr>
<td><div align="center">$text</div></td>
</tr>
<tr>
<td><div align="center"><a href="$url" mce_href="$url">本页面在 $ms 秒后自动跳转,如果您的浏览器没有跳转,点此链接返回。</a></div>
</td>
</tr>
</table></td>
</tr>
</table>
</div>
EOT;
}
/admin/article.php
<?php
include_once "init.php";
include_once "../common/Page.class.php";
$page=isset($_GET['page'])? $_GET['page']:1;
$result = $conn->query("select * from article");
$subPages=8;
if ($_GET['action'] == 'del'){
$id = filterstr($_GET['id']);
$conn->query("delete from article where id='$id'");
if($conn->affected_rows>0){
redirect(2,'article_list.php','删除成功');
}
else{
redirect(2,'article_list.php','删除失败');
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8"/>
<title>后台管理</title>
<link rel="stylesheet" type="text/css" href="css/common.css"/>
<link rel="stylesheet" type="text/css" href="css/main.css"/>
</head>
<body>
<div class="topbar-wrap white">
<div class="topbar-inner clearfix">
<div class="topbar-logo-wrap clearfix">
<h1 class="topbar-logo none"><a href="index.html" class="navbar-brand">后台管理</a></h1>
<ul class="navbar-list clearfix">
<li><a class="on" href="index.html">首页</a></li>
<li><a href="#" target="_blank">网站首页</a></li>
</ul>
</div>
<div class="top-info-wrap">
<ul class="top-info-list clearfix">
<li><a href="#">管理员</a></li>
<li><a href="#">修改密码</a></li>
<li><a href="#">退出</a></li>
</ul>
</div>
</div>
</div>
<div class="container clearfix">
<div class="sidebar-wrap">
<div class="sidebar-title">
<h1>菜单</h1>
</div>
<div class="sidebar-content">
<ul class="sidebar-list">
<li>
<a href="#"><i class="icon-font"></i>常用操作</a>
<ul class="sub-menu">
<li><a href="design.html"><i class="icon-font"></i>作品管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>博文管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>分类管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>留言管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>评论管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>友情链接</a></li>
<li><a href="design.html"><i class="icon-font"></i>广告管理</a></li>
</ul>
</li>
<li>
<a href="#"><i class="icon-font"></i>系统管理</a>
<ul class="sub-menu">
<li><a href="system.html"><i class="icon-font"></i>系统设置</a></li>
<li><a href="system.html"><i class="icon-font"></i>清理缓存</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据备份</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据还原</a></li>
</ul>
</li>
</ul>
</div>
</div>
<!--/sidebar-->
<div class="main-wrap">
<div class="crumb-wrap">
<div class="crumb-list"><i class="icon-font"></i><a href="index.html">首页</a><span class="crumb-step">></span><span class="crumb-name">作品管理</span></div>
</div>
<div class="result-wrap">
<form name="myform" id="myform" method="post">
<div class="result-title">
<div class="result-list">
<a href="artic_add.php"><i class="icon-font"></i>新增作品</a>
</div>
</div>
<div class="result-content">
<table class="result-tab" width="100%">
<tr>
<th>ID</th>
<th>标题</th>
<th>点击</th>
<th>发布人</th>
<th>分类</th>
<th>更新时间</th>
<th>操作</th>
</tr>
<tr>
<?php
$result = $conn->query("select a.id,a.title,a.n,a.author,a.c_time,b.class_name from article as a,cate as b where a.catid = b.id order by a.id desc limit $page,$subPages");
while($row = $result->fetch_assoc()){
?>
<td><?php echo $row['id'];?></td>
<td title="<?php echo $row['title']; ?>"><a target="_blank" href="article_edit.php?id=<?php echo $row['id'];?>" title="<?php echo $row['title']; ?>"><?php echo $row['title']; ?></a>
</td>
<td><?php echo $row['n'];?></td>
<td><?php echo $row['author']; ?></td>
<td><?php echo $row['class_name']; ?></td>
<td><?php echo date("Y-m-d H:i:s",$row['c_time']); ?></td>
<td>
<a class="link-update" href="article_edit.php?id=<?php echo $row['id'];?>">修改</a>
<a class="link-del" href="javascript:del(<?php echo $row['id'];?>);">删除</a>
</td>
</tr>
<?php }?>
</table>
<div class="list-page">
<?php
$result1=$conn->query("select * from article as a,cate as b where a.catid = b.id order by a.id desc ");
$result_count1=$result1->num_rows;
$p = new Page($result_count1,4,$page,$subPages);
echo $p->showPages(1);
?>
</div>
</div>
</form>
</div>
</div>
<!--/main-->
</div>
<script>
function del(id){
if(false==confirm("是否确定删除记录?")) return;
location.href='?action=del&id='+id;
}
</script>
</body>
</html>
/admin/artic_add.php
<?php
include_once 'init.php';
header("Content-type: text/html; charset=utf-8");
$title = filterstr($_POST['title']);
$content = filterstr($_POST['content']);
$author = filterstr($_POST['author']);
$keyword = filterstr($_POST['keyword']);
$c_time = time();
$catid=filterstr($_POST['catid']);
//echo $cateid;
//$sql="insert into article (title,content,author,keyword,catid,c_time) value ('$title','$content','$author','$keyword',$cateid,'$c_time')";
//echo $sql;
if($_POST['sub']) {
$conn->query("insert into article (title,content,author,keyword,catid,c_time) value ('$title','$content','$author','$keyword',$catid,'$c_time')");
if ($conn->affected_rows > 0) {
redirect(2, 'article_list.php', '添加成功');
} else {
redirect(2, 'artic_add.php', '添加失败');
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8"/>
<title>后台管理</title>
<link rel="stylesheet" type="text/css" href="css/common.css"/>
<link rel="stylesheet" type="text/css" href="css/main.css"/>
</head>
<body>
<div class="topbar-wrap white">
<div class="topbar-inner clearfix">
<div class="topbar-logo-wrap clearfix">
<h1 class="topbar-logo none"><a href="index.html" class="navbar-brand">后台管理</a></h1>
<ul class="navbar-list clearfix">
<li><a class="on" href="index.html">首页</a></li>
<li><a href="#" target="_blank">网站首页</a></li>
</ul>
</div>
<div class="top-info-wrap">
<ul class="top-info-list clearfix">
<li><a href="#">管理员</a></li>
<li><a href="#">修改密码</a></li>
<li><a href="#">退出</a></li>
</ul>
</div>
</div>
</div>
<div class="container clearfix">
<div class="sidebar-wrap">
<div class="sidebar-title">
<h1>菜单</h1>
</div>
<div class="sidebar-content">
<ul class="sidebar-list">
<li>
<a href="#"><i class="icon-font"></i>常用操作</a>
<ul class="sub-menu">
<li><a href="design.html"><i class="icon-font"></i>作品管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>博文管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>分类管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>留言管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>评论管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>友情链接</a></li>
<li><a href="design.html"><i class="icon-font"></i>广告管理</a></li>
</ul>
</li>
<li>
<a href="#"><i class="icon-font"></i>系统管理</a>
<ul class="sub-menu">
<li><a href="system.html"><i class="icon-font"></i>系统设置</a></li>
<li><a href="system.html"><i class="icon-font"></i>清理缓存</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据备份</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据还原</a></li>
</ul>
</li>
</ul>
</div>
</div>
<!--/sidebar-->
<div class="main-wrap">
<div class="crumb-wrap">
<div class="crumb-list"><i class="icon-font"></i><a href="/jscss/admin/design/">首页</a><span class="crumb-step">></span><a class="crumb-name" href="/jscss/admin/design/">作品管理</a><span class="crumb-step">></span><span>新增作品</span></div>
</div>
<div class="result-wrap">
<div class="result-content">
<form action="" method="post" id="myform" name="myform" enctype="multipart/form-data">
<table class="insert-tab" width="100%">
<tbody><tr>
<th width="120"><i class="require-red">*</i>分类:</th>
<td>
<select name="catid" id="catid" class="required">
<option value="">请选择</option>
<?php
$cate_result = $conn->query("select * from cate");
while($row = $cate_result->fetch_assoc()){
?>
<option value="<?php echo $row['id']?>"><?php echo $row['class_name'];?></option>
<?php
}
?>
?>
</select>
</td>
</tr>
<tr>
<th><i class="require-red">*</i>标题:</th>
<td>
<input class="common-text required" id="title" name="title" size="50" value="" type="text">
</td>
</tr>
<tr>
<th>作者:</th>
<td><input class="common-text" name="author" size="50" value="admin" type="text"></td>
</tr>
<tr>
<th>关键字:</th>
<td><input class="common-text" name="keyword" size="50" type="text" placeholder="输入关键词语以空格或逗号隔开"></td>
</tr>
<tr>
<th>内容:</th>
<td><textarea name="content" id="EditorId" class="common-textarea" id="content" cols="30" style="width: 98%;" rows="10"></textarea></td>
</tr>
<tr>
<th></th>
<td>
<input class="btn btn-primary btn6 mr10" value="提交" name="sub" type="submit">
<input class="btn btn6" onClick="history.go(-1)" value="返回" type="button">
</td>
</tr>
</tbody></table>
</form>
</div>
</div>
</div>
<!--/main-->
</div>
<script type="text/javascript" src="ueditor/ueditor.config.js"></script>
<script type="text/javascript" src="ueditor/ueditor.all.min.js"></script>
<script type="text/javascript" src="ueditor/lang/zh-cn/zh-cn.js"></script>
<script type="text/javascript" charset="utf-8">//初始化编辑器
window.UEDITOR_HOME_URL = "ueditor/";//配置路径设定为UEditor所放的位置
window.onload=function(){
/* window.UEDITOR_CONFIG.initialFrameHeight=600;//编辑器的高度*/
/* window.UEDITOR_CONFIG.initialFrameWidth=1200;//编辑器的宽度*/
var editor = new UE.ui.Editor({
imageUrl : '',
fileUrl : '',
imagePath : '',
filePath : '',
imageManagerUrl:'', //图片在线管理的处理地址
imageManagerPath:''
});
editor.render("EditorId");//此处的EditorId与<textarea name="content" id="EditorId">的id值对应 </textarea>
}
</script>
</body>
</html>
/admin/article_editor.php
<?php
include_once 'init.php';
header("Content-type: text/html; charset=utf-8");
$id = filterstr($_GET['id']);
$result = $conn->query("select * from article where id = '$id'");
$row =$result->fetch_assoc();
$title = filterstr($_POST['title']);
$content = filterstr($_POST['content']);
$author = filterstr($_POST['author']);
$keyword = filterstr($_POST['keyword']);
$c_time = time();
$catid=filterstr($_POST['catid']);
if($_POST['sub']){
//echo "update article set title = '$title',content='$content',author='$author',keyword='$keyword',c_time=$c_time,catid=$catid where id='$id'";
$conn->query("update article set title = '$title',content='$content',author='$author',keyword='$keyword',c_time=$c_time,catid=$catid where id='$id'");
if ($conn->affected_rows > 0) {
redirect(2, 'article_list.php', '编辑成功');
} else {
redirect(2, 'article_edit.php', '编辑失败');
}
}
//$sql="insert into article (title,content,author,keyword,catid,c_time) value ('$title','$content','$author','$keyword',$cateid,'$c_time')";
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8"/>
<title>后台管理</title>
<link rel="stylesheet" type="text/css" href="css/common.css"/>
<link rel="stylesheet" type="text/css" href="css/main.css"/>
</head>
<body>
<div class="topbar-wrap white">
<div class="topbar-inner clearfix">
<div class="topbar-logo-wrap clearfix">
<h1 class="topbar-logo none"><a href="index.html" class="navbar-brand">后台管理</a></h1>
<ul class="navbar-list clearfix">
<li><a class="on" href="index.html">首页</a></li>
<li><a href="#" target="_blank">网站首页</a></li>
</ul>
</div>
<div class="top-info-wrap">
<ul class="top-info-list clearfix">
<li><a href="#">管理员</a></li>
<li><a href="#">修改密码</a></li>
<li><a href="#">退出</a></li>
</ul>
</div>
</div>
</div>
<div class="container clearfix">
<div class="sidebar-wrap">
<div class="sidebar-title">
<h1>菜单</h1>
</div>
<div class="sidebar-content">
<ul class="sidebar-list">
<li>
<a href="#"><i class="icon-font"></i>常用操作</a>
<ul class="sub-menu">
<li><a href="design.html"><i class="icon-font"></i>作品管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>博文管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>分类管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>留言管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>评论管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>友情链接</a></li>
<li><a href="design.html"><i class="icon-font"></i>广告管理</a></li>
</ul>
</li>
<li>
<a href="#"><i class="icon-font"></i>系统管理</a>
<ul class="sub-menu">
<li><a href="system.html"><i class="icon-font"></i>系统设置</a></li>
<li><a href="system.html"><i class="icon-font"></i>清理缓存</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据备份</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据还原</a></li>
</ul>
</li>
</ul>
</div>
</div>
<!--/sidebar-->
<div class="main-wrap">
<div class="crumb-wrap">
<div class="crumb-list"><i class="icon-font"></i><a href="/jscss/admin/design/">首页</a><span class="crumb-step">></span><a class="crumb-name" href="/jscss/admin/design/">作品管理</a><span class="crumb-step">></span><span>编辑作品</span></div>
</div>
<div class="result-wrap">
<div class="result-content">
<form action="" method="post" id="myform" name="myform" enctype="multipart/form-data">
<table class="insert-tab" width="100%">
<tbody><tr>
<th width="120"><i class="require-red">*</i>分类:</th>
<td>
<select name="catid" id="catid" class="required">
<option value="">请选择</option>
<?php
$cate_result = $conn->query("select * from cate");
while($row1 = $cate_result->fetch_assoc()){
$selected = $row['catid'] == $row1['id']?"selected":null;
?>
<option <?php echo $selected; ?> value="<?php echo $row1['id']?>"><?php echo $row1['class_name'];?></option>
<?php
}
?>
?>
</select>
</td>
</tr>
<tr>
<th><i class="require-red">*</i>标题:</th>
<td>
<input class="common-text required" id="title" name="title" value="<?php echo $row['title']; ?>" size="50" type="text">
</td>
</tr>
<tr>
<th>作者:</th>
<td><input class="common-text" name="author" size="50" value="<?php echo $row['author'];?>" type="text"></td>
</tr>
<tr>
<th>关键字:</th>
<td><input class="common-text" name="keyword" size="50" type="text" value="<?php echo $row['keyword']; ?>" placeholder="输入关键词语以空格或逗号隔开"></td>
</tr>
<tr>
<th>内容:</th>
<td><textarea name="content" id="EditorId" class="common-textarea" id="content" cols="30" style="width: 98%;" rows="10"> <?php echo $row['content']; ?></textarea></td>
</tr>
<tr>
<th></th>
<td>
<input class="btn btn-primary btn6 mr10" value="提交" name ="sub" type="submit">
<input class="btn btn6" onClick="history.go(-1)" value="返回" type="button">
</td>
</tr>
</tbody></table>
</form>
</div>
</div>
</div>
<!--/main-->
</div>
<script type="text/javascript" src="ueditor/ueditor.config.js"></script>
<script type="text/javascript" src="ueditor/ueditor.all.min.js"></script>
<script type="text/javascript" src="ueditor/lang/zh-cn/zh-cn.js"></script>
<script type="text/javascript" charset="utf-8">//初始化编辑器
window.UEDITOR_HOME_URL = "ueditor/";//配置路径设定为UEditor所放的位置
window.onload=function(){
/* window.UEDITOR_CONFIG.initialFrameHeight=600;//编辑器的高度*/
/* window.UEDITOR_CONFIG.initialFrameWidth=1200;//编辑器的宽度*/
var editor = new UE.ui.Editor({
imageUrl : '',
fileUrl : '',
imagePath : '',
filePath : '',
imageManagerUrl:'', //图片在线管理的处理地址
imageManagerPath:''
});
editor.render("EditorId");//此处的EditorId与<textarea name="content" id="EditorId">的id值对应 </textarea>
}
</script>
</body>
</html>
/admin/article_list.php
<?php
include_once "init.php";
include_once "../common/Page.class.php";
$page=isset($_GET['page'])? $_GET['page']:1;
$result = $conn->query("select * from article");
$subPages=8;
if ($_GET['action'] == 'del'){
$id = filterstr($_GET['id']);
$conn->query("delete from article where id='$id'");
if($conn->affected_rows>0){
redirect(2,'article_list.php','删除成功');
}
else{
redirect(2,'article_list.php','删除失败');
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="UTF-8"/>
<title>后台管理</title>
<link rel="stylesheet" type="text/css" href="css/common.css"/>
<link rel="stylesheet" type="text/css" href="css/main.css"/>
</head>
<body>
<div class="topbar-wrap white">
<div class="topbar-inner clearfix">
<div class="topbar-logo-wrap clearfix">
<h1 class="topbar-logo none"><a href="index.html" class="navbar-brand">后台管理</a></h1>
<ul class="navbar-list clearfix">
<li><a class="on" href="index.html">首页</a></li>
<li><a href="#" target="_blank">网站首页</a></li>
</ul>
</div>
<div class="top-info-wrap">
<ul class="top-info-list clearfix">
<li><a href="#">管理员</a></li>
<li><a href="#">修改密码</a></li>
<li><a href="#">退出</a></li>
</ul>
</div>
</div>
</div>
<div class="container clearfix">
<div class="sidebar-wrap">
<div class="sidebar-title">
<h1>菜单</h1>
</div>
<div class="sidebar-content">
<ul class="sidebar-list">
<li>
<a href="#"><i class="icon-font"></i>常用操作</a>
<ul class="sub-menu">
<li><a href="design.html"><i class="icon-font"></i>作品管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>博文管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>分类管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>留言管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>评论管理</a></li>
<li><a href="design.html"><i class="icon-font"></i>友情链接</a></li>
<li><a href="design.html"><i class="icon-font"></i>广告管理</a></li>
</ul>
</li>
<li>
<a href="#"><i class="icon-font"></i>系统管理</a>
<ul class="sub-menu">
<li><a href="system.html"><i class="icon-font"></i>系统设置</a></li>
<li><a href="system.html"><i class="icon-font"></i>清理缓存</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据备份</a></li>
<li><a href="system.html"><i class="icon-font"></i>数据还原</a></li>
</ul>
</li>
</ul>
</div>
</div>
<!--/sidebar-->
<div class="main-wrap">
<div class="crumb-wrap">
<div class="crumb-list"><i class="icon-font"></i><a href="index.html">首页</a><span class="crumb-step">></span><span class="crumb-name">作品管理</span></div>
</div>
<div class="result-wrap">
<form name="myform" id="myform" method="post">
<div class="result-title">
<div class="result-list">
<a href="artic_add.php"><i class="icon-font"></i>新增作品</a>
</div>
</div>
<div class="result-content">
<table class="result-tab" width="100%">
<tr>
<th>ID</th>
<th>标题</th>
<th>点击</th>
<th>发布人</th>
<th>分类</th>
<th>更新时间</th>
<th>操作</th>
</tr>
<tr>
<?php
$result = $conn->query("select a.id,a.title,a.n,a.author,a.c_time,b.class_name from article as a,cate as b where a.catid = b.id order by a.id desc limit $page,$subPages");
while($row = $result->fetch_assoc()){
?>
<td><?php echo $row['id'];?></td>
<td title="<?php echo $row['title']; ?>"><a target="_blank" href="article_edit.php?id=<?php echo $row['id'];?>" title="<?php echo $row['title']; ?>"><?php echo $row['title']; ?></a>
</td>
<td><?php echo $row['n'];?></td>
<td><?php echo $row['author']; ?></td>
<td><?php echo $row['class_name']; ?></td>
<td><?php echo date("Y-m-d H:i:s",$row['c_time']); ?></td>
<td>
<a class="link-update" href="article_edit.php?id=<?php echo $row['id'];?>">修改</a>
<a class="link-del" href="javascript:del(<?php echo $row['id'];?>);">删除</a>
</td>
</tr>
<?php }?>
</table>
<div class="list-page">
<?php
$result1=$conn->query("select * from article as a,cate as b where a.catid = b.id order by a.id desc ");
$result_count1=$result1->num_rows;
$p = new Page($result_count1,4,$page,$subPages);
echo $p->showPages(1);
?>
</div>
</div>
</form>
</div>
</div>
<!--/main-->
</div>
<script>
function del(id){
if(false==confirm("是否确定删除记录?")) return;
location.href='?action=del&id='+id;
}
</script>
</body>
</html>