代码拉取完成，页面将自动刷新
<?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 -->
<link href="login/css/style.css" type="text/css" rel="stylesheet" media="all">
<!-- //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>User</h2>
</div>
</div>
</div>
<!-- //banner-text -->
</div>
<!-- //banner -->
<!-- single -->
<div class="banner">
<div class="agileinfo-dot">
<div style="margin-bottom:50px"></div>
<div class="w3layoutscontaineragileits">
<div><p>添加用户</p></div>
<div class="blank">
<!-- 表单 -->
<form name="stu_add_form" method="post" action="judge_add_user.php">
<input type="text" Name="username" placeholder="用户名" required="">
<input type="password" Name="password" placeholder="密 码" required="">
<input type="password" Name="confirm" placeholder="确认密码" required="">
<ul class="agileinfotickwthree">
</ul>
选择： <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-bottom: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>
<div class="aitssendbuttonw3ls">
<input type="submit" value="点击提交">
<div class="clear"></div>
</div>
</form>
</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 -->
<!--************ 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]);
}
}
}
</script>
<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 助手