PHP를 사용하여 간단한 온라인 수업 조정 및 퇴사 요청 시스템을 구현하는 방법

表名: students 字段: id, name, email, password 表名: courses 字段: id, name, room, teacher 表名: schedule 字段: id, student_id, course_id, date, time 表名: leave_requests 字段: id, student_id, course_id, date_from, date_to, reason, status

connect_error) { die("数据库连接失败: " . $conn->connect_error); } ?>

query($sql); if($result->num_rows == 1) { $row = $result->fetch_assoc(); $_SESSION['id'] = $row['id']; $_SESSION['name'] = $row['name']; header("location: dashboard.php"); } else { $error = "用户名或密码错误"; } } elseif(isset($_POST['register'])) { $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['password']; // 插入学生注册信息到数据库 $sql = "INSERT INTO students (name, email, password) VALUES ('$name', '$email', '$password')"; if($conn->query($sql) === TRUE){ $success = "注册成功，请登录"; }else{ $error = "注册失败"; } } } ?> 
 
学生登录
   登录 
学生注册
    注册 

query($sql) === TRUE){ $success = "调课成功"; }else{ $error = "调课失败"; } } elseif(isset($_POST['leave_request'])) { $course_id = $_POST['course_id']; $date_from = $_POST['date_from']; $date_to = $_POST['date_to']; $reason = $_POST['reason']; // 插入请假信息到数据库 $sql = "INSERT INTO leave_requests (student_id, course_id, date_from, date_to, reason, status) VALUES (".$_SESSION['id'].", $course_id, '$date_from', '$date_to', '$reason', 'pending')"; if($conn->query($sql) === TRUE){ $success = "请假申请已提交"; }else{ $error = "请假申请失败"; } } } ?> 
 
调课
  query($sql); while($row = $result->fetch_assoc()) { echo "".$row['name'].""; } ?>   确认调课 
请假
  query($sql); while($row = $result->fetch_assoc()) { echo "".$row['name'].""; } ?>     提交请假