最后一部分:管理员
一、管理员页面
<?php
include_once 'checkAdmin.php';
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>留言板系统</title>
<style>
.main {
width: 80%;
margin: 0 auto;
text-align: center;
}
h2 {
font-size: 20px
}
h2 a {
color: navy;
text-decoration: none;
margin-right: 15px
}
h2 a:last-child {
margin-right: 0
}
h2 a:hover {
color: brown;
text-decoration: underline}
tr:hover{background-color: azure}
.trClick1{background-color: yellow}
.trClick2{background-color: white
}
</style>
</head>
<body background="7.jpg"
style="background-repeat:no-repeat;
background-attachment: fixed;
background-size: 100% 100%;">
<div class="main">
<h1>留言板系统</h1>
<?php
if(isset($_SESSION['loggedUsername']) && $_SESSION['loggedUsername'] <> ''){
?>
<div class="logged">当前登录者:<?php echo $_SESSION['loggedUsername'];?> <?php if($_SESSION['isAdmin']) {?><span style="color: crimson">欢迎管理员登录</span><?php }?> <span class="logout"><span class="logout"><a href="logout.php">注销登录</a></span> </div>
<?php
}
?>
<h2>
<a href="留言.php">发表留言</a>
<a href="查看留言.php">查看留言</a>
<a href="修改.php"> 修改密码</a>
<a href="admin.php"> 后台管理 </a>
</h2>
<?php
include_once 'conn.php';
$sql = "select * from info order by id desc ";
$result = mysqli_query($conn, $sql);
?>
<table border="1" cellspacing="0" cellpadding="10" style="border-collapse: collapse" align="center" width="90%">
<tr style="background-color: darkgrey;">
<td>序号</td>
<td>用户名</td>
<td>密码</td>
<td>是否管理员</td>
<td>操作</td>
</tr>
<?php
$i = 1;
while ($info = mysqli_fetch_array($result)) {
?>
<tr onclick="if(this.className == 'trClick2'){this.className = 'trClick1'}else{this.className = 'trClick2'}" class="trClick2">
<td><?php echo $i; ?></td>
<td><?php echo $info['username']; ?></td>
<td><?php echo $info['pw']; ?> </td>
<td><?php echo $info['admin'] ? '是' : '否'; ?></td>
<td>
<?php if ($info['username'] <> 'admin') { ?>
<a href="修改.php?username=<?php echo $info['username']; ?>&source=admin">修改密码</a>
<?php
}
else{
echo "<span style='color:gray'>修改密码</span> ";
}
?>
<?php if ($info['username'] <> 'admin') { ?><a
href="javascript:del(<?php echo $info['id']; ?>,'<?php echo $info['username']; ?>');">删除用户</a>
<?php
}
else{
echo "<span style='color:gray'>删除用户</span> ";
}
if ($info['admin']) {
if ($info['username'] <> 'admin') {
?><a href="setAdmin.php?action=0&id=<?php echo $info['id']; ?>">取消管理员</a>
<?php
} else {
echo '<span style="color: gray">取消管理员</span>';
}
} else {
if ($info['username'] <> 'admin'){
?><a href="setAdmin.php?action=1&id=<?php echo $info['id']; ?>">设置管理员</a>
<?php
}
else {
echo '<span style="color: gray">设置管理员</span>';
}
}
?>
</td>
</tr>
<?php
$i++;
}
?>
</table>
</div>
<script>
function del(id,name){
if(confirm('您确定要删除用户 ' + name + ' ?')){
location.href = '删除用户.php?id=' + id + '&username=' + name;
}
}
</script>
</body>
</html>
二、设置与取消管理员
<?php
include_once 'checkadmin.php';
$action = $_GET['action'];
$id = $_GET['id'];
if(is_numeric($action) && is_numeric($id)){
if($action == 1 || $action == 0){
//说明是设置或取消管理员
$sql = "update info set admin = $action where id = $id";
}
else{
echo "<script>alert('参数错误');history.back();</script>";
exit;
}
include_once 'conn.php';
$result = mysqli_query($conn,$sql);
if($action){
$msg = '设置管理员';
}
else{
$msg = '取消管理员';
}
if($result){
echo "<script>alert('{$msg}成功');location.href='admin.php';</script>";
}
else{
echo "<script>alert('{$msg}失败');history.back();</script>";
}
}
else{
//说明action和(或)id不是数字
echo "<script>alert('参数错误');history.back();</script>";
}
这个是后端文件 没什么展示的
三、删用户
<?php
include_once 'checkadmin.php';
include_once 'conn.php';
$id = $_GET['id'];
$username = $_GET['username'];
if(is_numeric($id)){
$sql = "delete from info where id = $id";
$result = mysqli_query($conn,$sql);
if($result){
echo "<script>alert('删除用户 $username 成功');location.href = 'admin.php';</script>";
}
else{
echo "<script>alert('删除用户 $username 失败');history.back();</script>";
}
}
else{
echo "<script>alert('参数错误');history.back();</script>";
}
四、管理员删除或修改用户留言
<?php
session_start();
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>留言板系统</title>
<style>
.main{width: 80%;margin: 0 auto;text-align: center;}
h2{font-size: 20px}
h2 a{color: navy;text-decoration: none;margin-right: 15px}
h2 a:last-child{margin-right: 0}
h2 a:hover{color: brown;text-decoration: underline}
.current{color: brown}
.red{color: red}
.message
{
width:600px;
height:170px;
background:#fff;
background:rgba(255,255,255,0.25);
margin: 100px auto 0;
border: radious 5px;
padding: 5px;
}
.message p
{
color:black;
font-size:12px;
line-height:25px;
}
.message .text
{
width: 600px;
height:70px;
border: 1px solid #ddd;
background:rgba(255,255,255,0.25);
}
.message .btn
{
width:600px;
height:50px;
margin-top:10;/* 遇上个边框的距离为10像素 */
}
.message .btn .face-btn
{
float:left;
}
.message .btn .mes-btn
{
float:right;
background:rgba(255,255,255,0.25);
padding: 0px 5px;
border-radius:0px;
font-size:12px;
cursor:pointer;/* 设置鼠标形状。 */
}
.message .btn input
{
float:right;
background:rgba(255,255,255,0.25);
padding: 5px 20px;
border-radius:5px;
font-size:12px;
cursor:pointer;/* 设置鼠标形状。 */
}
</style>
</head>
<?php
include_once 'conn.php';
$id=$_GET["id"];
$sql = "select * from speak where id='$id'";
$result = mysqli_query($conn,$sql);
$speak = mysqli_fetch_array($result);
?>
<body background="6.jpg"
style="background-repeat:no-repeat;
background-attachment: fixed;
background-size: 100% 100%;">
<div class="main">
<h1>留言板系统</h1>
<?php
if(isset($_SESSION['loggedUsername']) && $_SESSION['loggedUsername'] <> ''){
?>
<div class="logged">当前登录者:<?php echo $_SESSION['loggedUsername'];?> <?php if($_SESSION['isAdmin']) {?><span style="color: crimson">欢迎管理员登录</span><?php }?> <span class="logout"><span class="logout"><a href="logout.php">注销登录</a></span> </div>
<?php
}
?>
<h2>
<a href="留言.php">发表留言</a>
<a href="查看留言.php">查看留言</a>
<a href="修改.php"> 修改密码</a>
<a href="admin.php"> 后台管理 </a>
</h2>
</div>
<form action="change_ok.php?id=<?php echo $_GET['id'] ?>" method="post" >
<div class="message">
<P>请发表留言</p>
<div class="btn">
<textarea name="text" cols="30" rows="10" class="text"><?php echo $speak['text']; ?></textarea>
<span><p align="right"><input type="submit" value="发表留言" ></p></span>
</div>
</div>
</form>
</div>
<?php
session_start();
include_once 'conn.php';
//接受数据
$username=$_SESSION['loggedUsername'];
$text=$_POST['text'];
$id=$_GET["id"];
$sql=" update speak set username='$username',text='$text' where id='$id' ";
$result = mysqli_query($conn,$sql);
if($result){
echo "<script>alert('修改留言成功!');location.href='查看留言.php';</script>";
}
else{
echo "<script>alert('修改留言失败!');history.back();</script>";
}
?>
这个是修改。然后是删除
<?php
$id=$_GET['id'];
include_once 'conn.php';
$sql="delete from speak where id='$id' ";
$return = mysqli_query($conn,$sql);
if($return)
{
echo "<script>alert('删除成功!');location.href='查看留言.php';</script>";
}
?>