代码拉取完成，页面将自动刷新
<?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">
<h2>File Search</h2>
</div>
</div>
</div>
<!-- //banner-text -->
</div>
<!-- //banner -->
<!-- single -->
<div class="codes icons main-grid-border">
<div class="container" style="padding-left: auto;">
<div class="list-center">
<div style="border-bottom:1px solid #bbbbbb"></div>
<div style="margin-top:30px ;">
<table align="center" cellpadding="10" style="width:80%" class="table table-bordered">
<caption style="text-align:center"><h3><b>文件列表</b></h3></caption>
<thead>
</thead>
<tr style="margin-top:10px;margin-bottom:10px; "> <!-- 显示文件列表 -->
<th><h4>文件名</h4></th>
<th><h4>文件大小</h4></th>
<th><h4>公司</h4></th>
</tr>
<?php
include("db.php");
$fileName=htmlspecialchars($_POST['fname']);
//var_dump($fileName);
if($_SESSION['file']==''){$_SESSION['file']=$fileName;}
$sql3="select * from upload where fname like '%{$_SESSION['file']}%' "; //文件信息查询
//var_dump($sql3);
$result3=$mysqli->query($sql3);
$total=$result3->num_rows; //记录总数
$page_num=8; //每页显示条数
$total_page=ceil($total/$page_num); //计算总页数
//var_dump($result3);
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
} //确定当前页数
if($total==0){
echo '<tr >';
echo '<td>'."对不起，没有相关文件".'</td>';
echo '<td></td>';
echo '<td></td>';
echo '</tr>';
//exit;
}
$itemf=($page-1)*$page_num;
$sql4="select * from upload where fname like '%{$_SESSION['file']}%' order by id desc limit $itemf,$page_num";
$result4=$mysqli->query($sql4);
//var_dump($result4);
$rows=array();
while($row=$result4->fetch_array(MYSQLI_ASSOC)){
$rows[]=$row;
//var_dump($rows);
}
foreach($rows as $row){
echo '<tr >';
echo "<td><a href=\"{$row['fpath']}\">{$row['fname']}</a></td>";
echo '<td>'.$row['fsize'].'</td>';
echo '<td>'.$row['company'].'</td>';
echo '</tr>';
}
echo '</table>';
echo '<table align="center" style="text-align:center;width:80%;border:0px;" >';
echo '<tr>';
echo '<td><a href="file_search.php?page=1">首页</a></td>';
if($page>1){
echo "<td><a href='file_search.php?page=".($page-1)."'>上一页</a></td>";
}
if($page<$total_page){
echo "<td><a href='file_search.php?page=".($page+1)."'>下一页</a></td>";
}
echo '<td><a href="file_search.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}个文件";
echo '</div>';
?>
</div>
</div>
</div>
</div>
<!-- //single -->
<!-- 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 w3layouts">
<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);
});
});
</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 助手