<!DOCTYPE html>
<head>
<meta charset="UTF-8">
<title>06_登入页面</title>
<link href="../css/index.css" rel="stylesheet" type="text/css" >
</head>
<head>
<head>
<body>
<center>
<?php
//与MySQL数据库建立连接
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "ztx42";
$js = "";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
//连接错误时的提示
if (!$conn) {
die("连接失败: " . mysqli_connect_error());
}
//设置默认字符编码
mysqli_set_charset($conn, 'utf8');
//选择特定的数据库
mysqli_select_db($conn, 'ztx42');
// $jiaoshi = $_POST['jiaoshi'];
$subject = $_POST['subject'];
// $username = $_POST['username'];
$class = $_POST['class'];
// $gender = $_POST['gender'];
if (isset($_POST["jiaoshi"])) //$jiaoshi为空时的异常处理 （js为用户身份）
{
$jiaoshi = $_POST["jiaoshi"];
} else
{
$jiaoshi = null;
}
if (isset($_POST["gender"])) //$gender为空时的异常处理 （js为用户身份）
{
$gender = $_POST["gender"];
} else
{
$gender = null;
}
if($jiaoshi == ""){
echo "选择的操作不能为空，请选择您要进行的操作！"."<br>";
echo "<a href='teacher_query.html'>
<img src=\"../image/fh.png\" width=\"85px\" height=\"35px\">
</a>" ."<br>";
} else {
if ($class == "") {
echo "班级不能为空，请选择班级！" . "<br><br>";
echo "<a href='teacher_query.html'>
<img src=\"../image/fh.png\" width=\"85px\" height=\"35px\">
</a>" . "<br>";
} elseif ($gender == "" and $jiaoshi == 'dk') {
echo "单科查询的科目不能为空，请重新选择！";
echo "<a href='teacher_query.html'>
<img src=\"../image/fh.png\" width=\"85px\" height=\"35px\">
</a>" . "<br>";
}else {
if ($jiaoshi == 'insert') {
header("location:insert.html");
} elseif ($jiaoshi == 'view_class') {
echo "班级：" . $class . "班"."<br>";
echo "课程信息：语文、数学、英语、物理、生物、地理、政治、历史、生物"."<br><br>";
echo "<a href='teacher_query.html'>
<img src=\"../image/fh.png\" width=\"85px\" height=\"35px\">
</a>" . "<br>";
} elseif ($jiaoshi == 'view_score') {
if ($gender == 'dk') {
echo "<table border='1' >";
if ($subject == 'yw') {
echo "<tr>";
echo "<td colspan='2'>" . "语文成绩如下" . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>"."名字"."</td>";
echo "<td>"."成绩"."</td>";
echo "</tr>";
$sql = "SELECT username,yuwen from score";
$all = mysqli_query($conn, $sql);
$rownum = mysqli_num_rows($all);
for ($i = 0; $i < $rownum; $i++) {
$row = mysqli_fetch_assoc($all);
echo "<tr>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['yuwen'] . "</td>";
echo "</tr>";
}
} elseif ($subject == 'sx') {
echo "<tr>";
echo "<td colspan='2'>" . "数学成绩如下" . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>"."名字"."</td>";
echo "<td>"."成绩"."</td>";
echo "</tr>";
$sql = "SELECT username,shuxue from score";
$all = mysqli_query($conn, $sql);
$rownum = mysqli_num_rows($all);
for ($i = 0; $i < $rownum; $i++) {
$row = mysqli_fetch_assoc($all);
echo "<tr>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['shuxue'] . "</td>";
echo "</tr>";
}
} elseif ($subject == 'yy') {
echo "<tr>";
echo "<td colspan='2'>" . "英语成绩如下" . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>"."名字"."</td>";
echo "<td>"."成绩"."</td>";
echo "</tr>";
$sql = "SELECT username,yingyu from score";
$all = mysqli_query($conn, $sql);
$rownum = mysqli_num_rows($all);
for ($i = 0; $i < $rownum; $i++) {
$row = mysqli_fetch_assoc($all);
echo "<tr>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['yingyu'] . "</td>";
echo "</tr>";
}
} elseif ($subject == 'wl') {
echo "<tr>";
echo "<td colspan='2'>" . "物理成绩如下" . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>"."名字"."</td>";
echo "<td>"."成绩"."</td>";
echo "</tr>";
$sql = "SELECT username,wuli from score";
$all = mysqli_query($conn, $sql);
$rownum = mysqli_num_rows($all);
for ($i = 0; $i < $rownum; $i++) {
$row = mysqli_fetch_assoc($all);
echo "<tr>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['wuli'] . "</td>";
echo "</tr>";
}
} elseif ($subject == 'hx') {
echo "<tr>";
echo "<td colspan='2'>" . "化学成绩如下" . "</td>";
echo "</tr>";
echo "<tr>";
e
PHP阿米尔期末作业.zip （51个子文件） 
PHP阿米尔期末作业 修改个人信息 
revise.html 2KB
06_revise.php 7KB
8.gif 3.98MB main.html 2KB 注册 register.html 2KB 06_register.php 5KB 新建表 data.php 2KB image 
xg.png 22KB jxlr.png 23KB xggrxx.png 25KB cxcj.png 23KB tc.png 6KB yzc.png 10KB gdcz.png 23KB qwxc.png 26KB cx.png 21KB sc.png 21KB bg1.png 18KB fh.png 6KB cxlr.png 22KB fhdl.png 25KB zx.png 7KB qwdl.png 9KB zc.png 7KB
1.jpg 249KB 管理员 修改 verify.php 3KB ravamp.php 4KB manager_query.php 2KB manager_query.html 862B 查询 chaxun.php 6KB inquire.php 3KB 删除 shanchu.php 2KB delete.php 3KB .idea 综合作业.iml 288B workspace.xml 3KB misc.xml 179B php.xml 152B modules.xml 283B .gitignore 184B 登入 06_login.php 5KB css index.css 114B 学生查询成绩 student_query.php 13KB stu_query.html 1KB 教师查询录入成绩 teacher_query.php 16KB insert.php 3KB teacher_query.html 2KB insert.html 2KB 注销 delete.html 2KB 06_delete.php 3KB 1.gif 6.41MB banner2.png 314KB资源评论
