简易教学管理系统

学号：1825101045 姓名：杨祉

班级：计算机科学与技术一班

课程查询
"; echo ""; echo ""; echo ""; echo ""; } } ?>
任课教师 课程 均分
" . $row["t_name"] . "" . $row["c_name"] . "" . $row["AVG"] . "
alert(\"登陆成功！\");"; Header('location:login.php?usertype=' . $_SESSION['usertype']); } else { //如果用户信息正确 echo ""; } } elseif (isset($_GET['usertype'])) { ?>
"; //用户登录查询 $sql = "SELECT * FROM student"; $query = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($query)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } break; case "t": if (isset($_GET['search'])) { $sql = "SELECT t_id FROM teacher WHERE t_name='{$_GET['search_name']}'"; $query = mysqli_query($conn, $sql); $row = mysqli_fetch_array($query); if ($row) { Header('location:teacher.php?id=' . $row["t_id"]); } } //输出表头 echo ""; //用户登录查询 $sql = "SELECT * FROM teacher"; $query = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($query)) { echo ""; echo ""; $sql_new = "SELECT COUNT(DISTINCT c_id) AS count FROM course WHERE t_id='{$row["t_id"]}'"; $query_new = mysqli_query($conn, $sql_new); $row_new = mysqli_fetch_array($query_new); echo ""; echo ""; echo ""; } break; case "a": Header('location:admin.php'); break; } ?>
姓名生日性别操作
" . $row["s_name"] . "" . $row["s_birth"] . "" . $row["s_sex"] . "查看
教师姓名授课门数操作
" . $row["t_name"] . "" . $row_new["count"] . "查看
用户登录
帐号：
密码：
登录端：