当前位置：首页 > PHP

php实现班级系统

2026-02-15 19:45:43PHP

数据库设计

创建数据库表存储班级、学生和教师信息。主要表包括classes（班级）、students（学生）、teachers（教师）和class_teacher（班级教师关联表）。

CREATE TABLE classes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    grade VARCHAR(20) NOT NULL
);

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    class_id INT,
    FOREIGN KEY (class_id) REFERENCES classes(id)
);

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

CREATE TABLE class_teacher (
    class_id INT,
    teacher_id INT,
    PRIMARY KEY (class_id, teacher_id),
    FOREIGN KEY (class_id) REFERENCES classes(id),
    FOREIGN KEY (teacher_id) REFERENCES teachers(id)
);

连接数据库

使用PDO连接MySQL数据库，确保代码安全性和可维护性。

$host = 'localhost';
$dbname = 'school';
$username = 'root';
$password = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Could not connect to the database: " . $e->getMessage());
}

班级管理功能

实现添加、删除和查询班级的功能。

php实现班级系统

function addClass($name, $grade) {
    global $pdo;
    $stmt = $pdo->prepare("INSERT INTO classes (name, grade) VALUES (?, ?)");
    $stmt->execute([$name, $grade]);
}

function deleteClass($id) {
    global $pdo;
    $stmt = $pdo->prepare("DELETE FROM classes WHERE id = ?");
    $stmt->execute([$id]);
}

function getClasses() {
    global $pdo;
    $stmt = $pdo->query("SELECT * FROM classes");
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

学生管理功能

实现学生信息的增删改查操作。

function addStudent($name, $classId) {
    global $pdo;
    $stmt = $pdo->prepare("INSERT INTO students (name, class_id) VALUES (?, ?)");
    $stmt->execute([$name, $classId]);
}

function getStudentsByClass($classId) {
    global $pdo;
    $stmt = $pdo->prepare("SELECT * FROM students WHERE class_id = ?");
    $stmt->execute([$classId]);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

教师分配功能

将教师分配到指定班级，并查询班级教师列表。

php实现班级系统

function assignTeacherToClass($teacherId, $classId) {
    global $pdo;
    $stmt = $pdo->prepare("INSERT INTO class_teacher (teacher_id, class_id) VALUES (?, ?)");
    $stmt->execute([$teacherId, $classId]);
}

function getTeachersByClass($classId) {
    global $pdo;
    $stmt = $pdo->prepare("SELECT t.* FROM teachers t JOIN class_teacher ct ON t.id = ct.teacher_id WHERE ct.class_id = ?");
    $stmt->execute([$classId]);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

前端界面

创建简单的HTML界面展示班级信息和操作表单。

<!DOCTYPE html>
<html>
<head>
    <title>班级管理系统</title>
</head>
<body>
    <h1>班级列表</h1>
    <ul>
        <?php foreach (getClasses() as $class): ?>
            <li>
                <?php echo $class['name'] ?> (<?php echo $class['grade'] ?>)
                <a href="students.php?class_id=<?php echo $class['id'] ?>">查看学生</a>
            </li>
        <?php endforeach; ?>
    </ul>
</body>
</html>

安全措施

实施参数化查询防止SQL注入，对用户输入进行验证和过滤。

function sanitizeInput($data) {
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

扩展功能

添加分页功能处理大量数据，实现学生成绩管理和考勤记录。

function getClassesWithPagination($page = 1, $perPage = 10) {
    global $pdo;
    $offset = ($page - 1) * $perPage;
    $stmt = $pdo->prepare("SELECT * FROM classes LIMIT ?, ?");
    $stmt->bindValue(1, $offset, PDO::PARAM_INT);
    $stmt->bindValue(2, $perPage, PDO::PARAM_INT);
    $stmt->execute();
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}