当前位置：首页 > PHP

php实现教育开课

2026-03-13 02:52:51PHP

PHP 实现教育开课系统

数据库设计

教育开课系统需要设计合理的数据库结构来存储课程、教师、学生等相关信息。常见的表包括：

courses：存储课程基本信息（课程ID、名称、描述、学分等）
teachers：存储教师信息
students：存储学生信息
course_teacher：课程与教师的关联表
course_student：课程与学生的关联表（选课记录）

示例建表SQL：

CREATE TABLE courses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    description TEXT,
    credit INT,
    max_students INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE teachers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE
);

CREATE TABLE course_teacher (
    course_id INT,
    teacher_id INT,
    PRIMARY KEY (course_id, teacher_id),
    FOREIGN KEY (course_id) REFERENCES courses(id),
    FOREIGN KEY (teacher_id) REFERENCES teachers(id)
);

课程管理功能实现

使用PHP实现基本的课程管理功能，包括添加、编辑、删除和查询课程。

添加课程示例代码：

function addCourse($name, $description, $credit, $maxStudents) {
    global $conn;
    $stmt = $conn->prepare("INSERT INTO courses (name, description, credit, max_students) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssii", $name, $description, $credit, $maxStudents);
    return $stmt->execute();
}

教师分配功能

实现将教师分配到特定课程的功能：

function assignTeacherToCourse($courseId, $teacherId) {
    global $conn;
    $stmt = $conn->prepare("INSERT INTO course_teacher (course_id, teacher_id) VALUES (?, ?)");
    $stmt->bind_param("ii", $courseId, $teacherId);
    return $stmt->execute();
}

学生选课功能

实现学生选课系统，包括选课、退课和查询已选课程：

function enrollStudent($courseId, $studentId) {
    global $conn;

    // 检查课程是否已满
    $stmt = $conn->prepare("SELECT COUNT(*) FROM course_student WHERE course_id = ?");
    $stmt->bind_param("i", $courseId);
    $stmt->execute();
    $result = $stmt->get_result();
    $count = $result->fetch_row()[0];

    $stmt = $conn->prepare("SELECT max_students FROM courses WHERE id = ?");
    $stmt->bind_param("i", $courseId);
    $stmt->execute();
    $result = $stmt->get_result();
    $max = $result->fetch_row()[0];

    if ($count >= $max) {
        return false; // 课程已满
    }

    $stmt = $conn->prepare("INSERT INTO course_student (course_id, student_id) VALUES (?, ?)");
    $stmt->bind_param("ii", $courseId, $studentId);
    return $stmt->execute();
}

课程查询功能

实现多种课程查询方式，如按名称搜索、按教师查询等：

function searchCourses($keyword) {
    global $conn;
    $keyword = "%$keyword%";
    $stmt = $conn->prepare("SELECT * FROM courses WHERE name LIKE ? OR description LIKE ?");
    $stmt->bind_param("ss", $keyword, $keyword);
    $stmt->execute();
    return $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
}