php 作业管理系统

<?php
try {
    // 数据库连接
    $pdo = new PDO('mysql:host=localhost;dbname=homework', 'username', 'password');

    // 数据验证
    $title = $_POST['title'];
    $content = $_POST['content'];
    if (empty($title) || empty($content)) {
        throw new Exception('作业标题和内容不能为空');
    }

    // 插入数据
    $stmt = $pdo->prepare('INSERT INTO homework (title, content) VALUES (?, ?)');
    $stmt->execute([$title, $content]);
} catch (Exception $e) {
    echo '错误：' . $e->getMessage();
}
?>

<?php
try {
    // 数据库连接
    $pdo = new PDO('mysql:host=localhost;dbname=homework', 'username', 'password');

    // 更新成绩
    $id = $_POST['id'];
    $score = $_POST['score'];
    $stmt = $pdo->prepare('UPDATE homework SET score = ? WHERE id = ?');
    $stmt->execute([$score, $id]);
} catch (Exception $e) {
    echo '错误：' . $e->getMessage();
}
?>