master

分支 (1)

管理

管理

master

php_web_site_implementation_of_file_upload_management
/
admin_file.php

<?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>";}
?>

<?php //
/***********************************************
** 功 能： php+mysql+javascript实现二级级联下拉框
** 数据库：数据库名（ useradmin）、数据表（ com_charter、 company）
** 表 com_charter中字段： Charter_id（ 大 id编号）、 charter（大 名）
** 表 company中的字段： id（ 小 id编号）、 Charter_id（大 ID）、 company（小 名）

***********************************************/
//****************** 连接选择数据库 ***************
//$mysqli2 = new mysqli("localhost", "root", "","useradmin");
include("db.php");
//******************提取 大 信息 ******************
$sql = "SELECT*FROM com_charter ORDER BY Charter_id";
//$mysqli2->query("SET NAMES UTF8");

$result1 = $mysqli->query($sql) ;
$com_charter = array();
while( $row1 = mysqli_fetch_array($result1) )
{
  $com_charter[] = $row1;
}
//print_r ($forum_data);
mysqli_free_result($result1);
//**************获取专业信息 **************
$queryMaj = "SELECT*FROM company ORDER BY id";
//$mysqli2->query("SET NAMES UTF8");
$result2 = $mysqli->query($queryMaj);

if(!$result2)
{
  die('Could not query t_city list');
}
$company = array();
while( $row2 = mysqli_fetch_array($result2) )
{
  $company[] = $row2;
}
mysqli_free_result($result2);
?>


<!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</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 class="bs-glyphicons" style="margin-left:auto; margin-bottom:30px";>


					<!-- 上传文件 -->
					<form name="stu_add_form" action="judge_add_files.php" method="post" enctype="multipart/form-data" >

					<div style="text-align:center ">

							<input type="file" name="file" style="margin-left:auto;margin-right:auto" required/>

							<select name="com_charter"
							onChange="changeCharter(document.stu_add_form.com_charter.options[document.stu_add_form.com_charter.selectedIndex].value)"
							size="1" style="color:black; margin-top:20px">
							<option selected>==请选择首字母 ==</option>
							<?php
							$num = count($com_charter);
							for($i=0;$i<$num;$i++)
							{
							?>
							<option value="<?php echo $com_charter[$i]['Charter_id'];?>"><?php echo $com_charter[$i]['charter'];?></option>
							<?php
							}
							?>
							</select>
							<select name="company" style="color:black" required>
							<option selected value="<?php echo $company['company'];?>">==选择公司 ==</option>
							</select>

							<input type="submit"  value="上传文件"/>

					</div>
					</form>


				</div>

				<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>
							<tr>
								<td colspan="4">
									<form action="file_search.php" method="post" class="navbar-form navbar-left"><!-- 搜索 -->
									<div class="form-group w3-agile" style="margin-bottom:20px;" >
										<input type="search" name="fname" class="form-control" placeholder="按文件名进行搜索" required>
										<button type="submit" class="btn btn-default" aria-label="Left Align">
											<span class="glyphicon glyphicon-search"></span>
										</button>
									</div>
									</form>
								</td>
							</tr>
						</thead>
							<tr style="margin-top:10px;margin-bottom:10px; ">					<!-- 显示文件列表 -->
								<th><h4>文件名</h4></th>
								<th><h4>文件大小</h4></th>
								<th><h4>公司</h4></th>
								<th><h4></h4></th>
							</tr>

							<?php
								include("db.php");

									/*分页处理*/
								$sql_page="select * from upload";
								$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 upload  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 '<tr >';
									  echo "<td><a href=\"{$row['fpath']}\">{$row['fname']}</a></td>";
									  echo '<td>'.$row['fsize'].'</td>';
									  echo '<td>'.$row['company'].'</td>';
									  echo '<td><a href="delete.php?id='.$row['id'].'"onClick="delete_confirm">删除</td>';
									  echo '</tr>';

							}

							echo '</table>';

							echo '<table align="center"  style="text-align:center;width:80%;border:0px;" >';
							echo '<tr>';
							echo '<td><a href="admin_file.php?page=1">首页</a></td>';
							if($page>1){
								echo "<td><a href='admin_file.php?page=".($page-1)."'>上一页</a></td>";
							}
							if($page<$total_page){
								echo "<td><a href='admin_file.php?page=".($page+1)."'>下一页</a></td>";
								echo '<td><a href="admin_file.php?page='.$total_page.'">尾页</a></td>';
							}

							echo '</tr>';
							echo '</table>';
							echo '<div align="right" style="margin-top:20px;color:gray">';
							echo "当前为第{$page}页&nbsp;&nbsp;共{$total_page}页&nbsp;&nbsp;共{$total_num}个文件";
							echo '</div>';


							if($_SESSION['file']!=''){
								unset($_SESSION['file']);
							}
							?>


				</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 &copy; 2017.Company name All rights reserved.<a target="_blank" href="http://sc.chinaz.com/moban/">&#x7F51;&#x9875;&#x6A21;&#x677F;</a></p>
		</div>
	</div>
	<!-- //footer -->
	<!--************ JavaScript处理 college-onChange *************-->
<script language = "JavaScript">
 var companyCount; // 存储专业记录条数
 // form_company[] 储存专业 major数据，如 {(1,1,电子商务 ),(4,1,计算机科学 ),(3,2,古典文学 )}
 form_company = new Array();
 <?php
   $num2 = count($company); // $num2 获取专业表中记录的个数
 ?>
   companyCount = <?php echo $num2;?>;
 <?php
   for($j=0;$j<$num2;$j++) // 从 0开始取出上面 company[]中存储的专业数据填充数组
 {
 ?>
   form_company[<?php echo $j;?>] = new Array("<?php echo $company[$j]['id'];?>",
   "<?php echo $company[$j]['Charter_id'];?>","<?php echo $company[$j]['company'];		//最后一个company可能有问题?>");
 <?php
 }
 ?>
 function changeCharter(Charter_id)
 {
   document.stu_add_form.company.length = 0;
   var id=id;
   var j;
   document.stu_add_form.company.options[0] = new Option('==选择公司==',''); // label的 value为空 ' '
   for (j=0;j < companyCount; j++) // 从 0开始判断
   {
    if (form_company[j][1] == Charter_id) // if college_id等于选择的学院的 id
    {
       document.stu_add_form.company.options[document.stu_add_form.company.length] = new Option(form_company[j][2], form_company[j][0]);
    }
   }
 }


 function delete_confirm(e)
{
    if (event.srcElement.outerText == "删除")
    {
        event.returnValue = confirm("你确认要删除吗？");
    }
}
document.onclick = delete_confirm;

</script>


<!-- 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>