代码拉取完成，页面将自动刷新
<?php
session_start();
//var_dump($_SESSION['username']);
if($_SESSION['username']==""){echo "<script language='javascript'>;alert('请登录账户后操作');location.href='login/login.php'</script>";}
else if($_SESSION['class']=="0"){echo "<script language='javascript'>;alert('请使用管理员身份登录');location.href='login/login.php'</script>";}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>留言管理</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="keywords" content="" />
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/bootstrap.css" type="text/css" rel="stylesheet" media="all">
<link href="css/style.css" type="text/css" rel="stylesheet" media="all">
<link href="css/font-awesome.css" rel="stylesheet"> <!-- font-awesome icons -->
<!-- //Custom Theme files -->
<!-- web-fonts -->
<link href="http://fonts.googleapis.com/css?family=Bigshot+One" rel="stylesheet">
<link href='http://fonts.googleapis.com/css?family=Roboto:400,100,100italic,300,300italic,400italic,500,500italic,700,700italic,900,900italic' rel='stylesheet' type='text/css'>
<!-- //web-fonts -->
</head>
<body>
<!-- banner -->
<div class="w3ls-banner aboutw3ls-banner">
<!-- header -->
<div class="header">
<div class="container">
<div class="header-top"><!-- header-top -->
<div class="agile-hdleft nav navbar-nav navbar-left">
<ul>
<li><a href="mailto:example@mail.com"><i class="fa fa-envelope-o"></i> mail@example.com</a></li>
<li><i class="fa fa-phone"></i> +01 222 111 444 </li>
</ul>
</div>
<div class="agile-hdmdl nav navbar-nav">
<form action="#" method="post">
<input type="search" name="Search" placeholder="Enter your search term..." id="search" required="">
<button type="submit" class="btn btn-default" aria-label="Left Align">
<span class="glyphicon glyphicon-search"></span>
</button>
</form>
</div>
<div class="agileits-hdright nav navbar-nav navbar-right">
<div class="social-icon">
<a href="#" class="social-button twitter"><i class="fa fa-twitter"></i></a>
<a href="#" class="social-button facebook"><i class="fa fa-facebook"></i></a>
<a href="#" class="social-button google"><i class="fa fa-google-plus"></i></a>
<a href="#" class="social-button dribbble"><i class="fa fa-dribbble"></i></a>
</div>
</div>
<div class="clearfix"> </div>
</div>
<div class="header-mdl agileits-logo"><!-- header-two -->
<div><h1><a href="#">机械实验室</a></h1></div>
<div class="blank" style="color:#fff;font-size:25px;">互联网+检测网络平台</div>
</div>
<div class="header-nav"><!-- header-three -->
<nav class="navbar navbar-default">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<!-- top-nav -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="index1.php">主页</a></li>
<li><a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">管理<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="admin_user.php">用户管理</a></li>
<li><a href="admin_file.php">文件管理</a></li>
<li><a href="#">设备管理</a></li>
<li><a href="admin_contact.php">留言管理</a></li>
</ul>
</li>
<li><a href="gallery.php">相册</a></li>
<li><a href="about.php">关于我们</a></li>
</ul>
<div class="clearfix"> </div>
</div>
</nav>
</div>
</div>
</div>
<!-- //header -->
<!-- banner-text -->
<div class="banner-text about-w3banner-text">
<div class="container">
<div class="banner-w3lstext w3-agileits">
<h2>Message</h2>
</div>
</div>
</div>
<!-- //banner-text -->
</div>
<!-- //banner -->
<!-- contact -->
<div class="contact agileits">
<div class="container">
<h3 class="agileits-title">留言板</h3>
</div>
<div style="margin-top:10px ;">
<?php
include("db.php");
/*分页处理*/
$sql_page="select * from msg ";
$re_page=$mysqli->query($sql_page);
//var_dump($re_page);
$total_num=$re_page->num_rows; //记录总数
//var_dump($total_num);
$page_num=8; //每页显示条数
$total_page=ceil($total_num/$page_num); //计算总页数
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
} //确定当前页数
$itemf=($page-1)*$page_num;
//var_dump($page);
//var_dump($itemf);
$sql3="select * from msg order by id desc limit $itemf,$page_num"; //文件信息查询
//var_dump($sql3);
$result3=$mysqli->query($sql3);
//var_dump($result3);
$rows=array();
while($row=$result3->fetch_array(MYSQLI_ASSOC)){
$rows[]=$row;
//var_dump($rows);
}
foreach($rows as $row){
echo '<div style="margin-top:30px;"> <table align="center" cellpadding="10"
style="width:80%" class="table table-bordered"><tr>';
echo '<td>用户名 '.$row['company'].' '.$row['username'].'</td>';
echo '<td>留言内容：'.$row['message'].'</td>';
echo '<td><a href="delete_msg.php?id='.$row['id'].'"onClick="delete_confirm">删除</td></td>';
echo '<tr><td>管理员回复</td>';
if($row['reply']!=''){
echo '<td>回复内容'.$row['reply'].'</td>';
}else{
echo '<td>暂无回复内容</td>';
}
echo '<td><a href="reply.php?id='.$row['id'].'">回复</td>';
echo '</tr></table></div>';
}
echo '<table align="center" style="text-align:center;width:80%;border:0px;" >';
echo '<tr>';
echo '<td><a href="admin_contact.php?page=1">首页</a></td>';
if($page>1){
echo "<td><a href='admin_contact.php?page=".($page-1)."'>上一页</a></td>";
}
if($page<$total_page){
echo "<td><a href='admin_contact.php?page=".($page+1)."'>下一页</a></td>";
echo '<td><a href="admin_contact.php?page='.$total_page.'">尾页</a></td>';
}
echo '</tr>';
echo '</table>';
echo '<div align="right" style="margin-top:20px;color:gray">';
echo "当前为第{$page}页 共{$total_page}页 共{$total_num}条留言";
echo '</div>';
?>
</div>
<div class="clearfix"> </div>
</div>
<!-- //contact -->
<!-- map -->
<!-- //map -->
<!-- footer -->
<div class="footer w3layouts">
<div class="container">
<div class="footer-agileinfo">
<div class="col-md-3 col-sm-6 footer-grid">
<h3>Useful Info</h3>
<ul>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Hendrerit quam</a></li>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Amet consectetur </a></li>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Iquam hendrerit</a></li>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Donec ut lectus </a></li>
</ul>
</div>
<div class="col-md-3 col-sm-6 footer-grid">
<h3>Recent Posts</h3>
<ul>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Vestibulum felis</a></li>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Mauris at tellus</a></li>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Donec ut lectus</a></li>
<li><a href="single.html"><i class="glyphicon glyphicon-chevron-right"></i>Vitae interdum</a></li>
</ul>
</div>
<div class="col-md-3 col-sm-6 footer-grid footer-tags">
<h3>Tag Cloud</h3>
<ul>
<li><a href="index.html">Home</a></li>
<li><a href="about.html">About</a></li>
<li><a href="codes.html">Codes</a></li>
<li><a href="gallery.html">Gallery</a></li>
<li><a href="contact.html">Contact Us</a></li>
</ul>
</div>
<div class="col-md-3 col-sm-6 footer-grid footer-review">
<h3>Review</h3>
<p>Maecenas sodales tortor ac ligula ultrices dictum et quis urna. Etiam pulvinar metus neque eget porttitor massa.</p>
<form action="#" method="post">
<input type="search" name="Search" placeholder="Enter your search term..." required="">
<button type="submit" class="btn btn-default" aria-label="Left Align">
<span class="glyphicon glyphicon-search"></span>
</button>
</form>
</div>
<div class="clearfix"> </div>
</div>
</div>
</div>
<div class="copy-right">
<div class="container">
<p>Copyright © 2017.Company name All rights reserved.<a target="_blank" href="http://sc.chinaz.com/moban/">网页模板</a></p>
</div>
</div>
<!-- //footer -->
<!-- js -->
<script src="js/jquery-2.2.3.min.js"></script>
<script src="js/SmoothScroll.min.js"></script>
<!-- //js -->
<!-- start-smooth-scrolling -->
<script type="text/javascript" src="js/move-top.js"></script>
<script type="text/javascript" src="js/easing.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$(".scroll").click(function(event){
event.preventDefault();
$('html,body').animate({scrollTop:$(this.hash).offset().top},1000);
});
});
function delete_confirm(e)
{
if (event.srcElement.outerText == "删除")
{
event.returnValue = confirm("你确认要删除吗？");
}
}
document.onclick = delete_confirm;
</script>
<!-- //end-smooth-scrolling -->
<!-- smooth-scrolling-of-move-up -->
<script type="text/javascript">
$(document).ready(function() {
/*
var defaults = {
containerID: 'toTop', // fading element id
containerHoverID: 'toTopHover', // fading element hover id
scrollSpeed: 1200,
easingType: 'linear'
};
*/
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<!-- //smooth-scrolling-of-move-up -->
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="js/bootstrap.js"></script>
</body>
</html>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
