<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="./css/nav.css">
<title>Document</title>
</head>
<body>
<?php include ('./nav.php'); ?>
<?php
include_once('./php/conn.php');
session_start();
$uid = $_SESSION["student_id"];
// 查询条件
$where = "";
if (isset($_POST['course_name']) && $_POST['course_name'] !== "") {
$where .= " AND course_name LIKE '%".$_POST['course_name']."%'";
}
if (isset($_POST['credit']) && $_POST['credit'] !== "") {
$where .= " AND credit = ".$_POST['credit'];
}
// 查询结果
$sql = "SELECT * FROM `course`.`course` WHERE 1=1 $where";
$result = mysqli_query($conn, $sql);
$result2 = mysqli_query($conn, "SELECT * FROM `course`.`view_course` WHERE student_id=$uid");
$courses = array();
$iscourses = array();
while ($row = mysqli_fetch_assoc($result2)) {
$iscourses[] = $row;
}
while ($row = mysqli_fetch_assoc($result)) {
$courses[] = $row;
}
// 显示课程列表
echo "<form method='post' id='form' action=''>";
echo "<label for='course_name'>课程名称：</label>";
if(isset($_POST['course_name'])){
echo "<input type='text' id='course_name' name='course_name' value='".$_POST['course_name']."'>";
}else{
echo "<input type='text' id='course_name' name='course_name' value=''>";
}
echo "<label for='credit'>学分：</label>";
if(isset($_POST['credit'])){
echo "<input type='text' id='credit' name='credit' value='".$_POST['credit']."'>";
}else{
echo "<input type='text' id='credit' name='credit' value=''>";
}
echo "<input type='submit' value='查询'>";
echo "</form>";
echo "<table>";
echo "<tr><th>编号</th><th>课程名称</th><th>学时</th><th>学分</th><th>上课时间</th><th>人数</th><th>教师名称</th><th>上课地点</th><th>操作</th></tr>";
foreach ($courses as $course) {
echo "<tr>";
echo "<td>" . $course['course_id'] . "</td>";
echo "<td>" . $course['course_name'] . "</td>";
echo "<td>" . $course['period'] . "</td>";
echo "<td>" . $course['credit'] . "</td>";
echo "<td>" . $course['attend_time'] . "</td>";
echo "<td>" . $course['capacity'] . "</td>";
echo "<td>" . $course['attend_address'] . "</td>";
echo "<td>" . $course['credit'] . "</td>";
$is=true;
foreach ($iscourses as $i) {
if($i['course_id']==$course['course_id']){
$is=false;
echo "<td><label> <a href='#'>已选择</a>";
break;
}
}
if($is){
echo "<td><label> <a href='select.php?course_id=".$course['course_id']."'>选择</a>";
}
echo "</tr>";
}
echo "</table>";
?>
</body>
<style>
table {
border-collapse: collapse;
width: 100%;
margin-bottom: 20px;
}
th,
td {
padding: 8px;
text-align: left;
border: 1px solid #ddd;
}
th {
background-color: #f2f2f2;
color: #666;
font-weight: normal;
}
tr:hover {
background-color: #f5f5f5;
}
h1 {
margin-bottom: 20px;
text-align: center;
font-size: 28px;
}
form {
max-width: 1000px;
margin: auto;
background-color: #f2f2f2;
padding: 20px;
border-radius: 4px;
box-shadow: 0 4px 8px 0 rgba(0, 0, 0, 0.2);
}
input[type="radio"] {
margin-right: 10px;
transform: scale(1.5);
-webkit-appearance: none;
appearance: none;
border-radius: 50%;
border: 1px solid #ccc;
}
input[type="button"] {
background-color: #4CAF50;
color: white;
padding: 10px 20px;
border: none;
border-radius: 4px;
cursor: pointer;
float: right;
}
input[type="button"]:hover {
background-color: #45a049;
}
</style>
</html>
PHP + MySQL 学生选课系统
需积分: 5 74 浏览量
2023-06-19
00:11:39
上传
评论 1
收藏 883KB ZIP 举报
PHP + MySQL 学生选课系统 （135个子文件） 
layui.css 68KB layer.css 14KB xadmin.css 10KB layui.mobile.css 10KB laydate.css 7KB login.css 2KB code.css 1KB nav.css 622B theme5.css 590B font.css 505B theme4.css 309B theme1.css 304B theme3.css 297B theme2.css 288B iconfont.eot 48KB iconfont.eot 40KB
59.gif 10KB 22.gif 10KB 24.gif 8KB 13.gif 7KB 16.gif 7KB 39.gif 6KB 64.gif 6KB 63.gif 6KB 50.gif 6KB loading-0.gif 6KB 4.gif 6KB 1.gif 5KB 42.gif 5KB 71.gif 5KB 21.gif 5KB 20.gif 5KB 29.gif 5KB 70.gif 4KB 5.gif 4KB 17.gif 4KB 27.gif 4KB 9.gif 4KB 44.gif 4KB 11.gif 4KB 8.gif 4KB 3.gif 4KB 23.gif 4KB 34.gif 4KB 41.gif 4KB 38.gif 4KB 65.gif 3KB 32.gif 3KB 45.gif 3KB 7.gif 3KB 12.gif 3KB 26.gif 3KB 60.gif 3KB 2.gif 3KB 40.gif 3KB 25.gif 3KB 19.gif 3KB 66.gif 3KB 18.gif 3KB 46.gif 3KB 10.gif 3KB 28.gif 3KB 51.gif 3KB 57.gif 3KB 67.gif 3KB 0.gif 3KB 48.gif 3KB 43.gif 3KB 30.gif 2KB 61.gif 2KB 33.gif 2KB 69.gif 2KB 14.gif 2KB 47.gif 2KB 36.gif 2KB 49.gif 2KB 58.gif 2KB 6.gif 2KB 54.gif 2KB 53.gif 2KB 56.gif 2KB 62.gif 2KB 31.gif 2KB 55.gif 2KB 35.gif 2KB 15.gif 2KB loading-2.gif 2KB 37.gif 1KB 68.gif 1KB 52.gif 777B loading-1.gif 701B layui.all.js 255KB jquery.js 95KB jquery.min.js 85KB xcity.js 56KB mobile.js 33KB table.js 30KB laydate.js 27KB layer.js 22KB xadmin.js 15KB共 135 条
- 1
- 2
资源评论
