当前位置：首页 > PHP

php实现班级

2026-02-14 08:17:12PHP

PHP实现班级管理系统

数据库设计

创建班级管理系统需要设计数据库表结构。常见表包括学生表、班级表、教师表等。

学生表（students）结构示例：

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    gender ENUM('男','女') NOT NULL,
    birth_date DATE,
    class_id INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

班级表（classes）结构示例：

CREATE TABLE classes (
    id INT AUTO_INCREMENT PRIMARY KEY,
    class_name VARCHAR(50) NOT NULL,
    teacher_id INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

连接数据库

使用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("数据库连接失败: " . $e->getMessage());
}

添加班级功能

创建添加班级的表单处理逻辑：

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_class'])) {
    $className = trim($_POST['class_name']);
    $teacherId = intval($_POST['teacher_id']);

    $stmt = $pdo->prepare("INSERT INTO classes (class_name, teacher_id) VALUES (?, ?)");
    $stmt->execute([$className, $teacherId]);

    header("Location: classes.php?success=1");
    exit;
}

班级列表展示

查询并显示所有班级信息：

$stmt = $pdo->query("SELECT classes.*, teachers.name as teacher_name 
                    FROM classes 
                    LEFT JOIN teachers ON classes.teacher_id = teachers.id");
$classes = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($classes as $class) {
    echo "<tr>
            <td>{$class['id']}</td>
            <td>{$class['class_name']}</td>
            <td>{$class['teacher_name']}</td>
            <td>
                <a href='edit_class.php?id={$class['id']}'>编辑</a>
                <a href='delete_class.php?id={$class['id']}' onclick='return confirm(\"确定删除吗？\")'>删除</a>
            </td>
          </tr>";
}

分页功能实现

为班级列表添加分页支持：

$perPage = 10;
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $perPage;

$total = $pdo->query("SELECT COUNT(*) FROM classes")->fetchColumn();
$totalPages = ceil($total / $perPage);

$stmt = $pdo->prepare("SELECT * FROM classes LIMIT :offset, :perPage");
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->bindValue(':perPage', $perPage, PDO::PARAM_INT);
$stmt->execute();
$classes = $stmt->fetchAll(PDO::FETCH_ASSOC);

安全防护措施

防止SQL注入和XSS攻击：

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

$className = sanitizeInput($_POST['class_name']);
$teacherId = filter_var($_POST['teacher_id'], FILTER_SANITIZE_NUMBER_INT);

文件结构建议

推荐的项目文件结构：

php实现班级

classes/
├── index.php          # 班级列表
├── add.php            # 添加班级
├── edit.php           # 编辑班级
├── delete.php         # 删除班级
├── includes/
│   ├── db.php        # 数据库连接
│   ├── functions.php # 公共函数
│   └── header.php    # 公共头部
└── assets/
    ├── css/
    └── js/