php留言板网页

<?php
// 数据库连接
$host = 'localhost';
$dbname = 'message_board';
$user = 'username';
$pass = 'password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}

// 查询留言
$sql = "SELECT * FROM messages";
$stmt = $pdo->query($sql);

if ($stmt->rowCount() > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo "<p>" . htmlspecialchars($row['content']) . "</p>";
    }
} else {
    echo "没有留言";
}
?>

<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $content = $_POST['content'];

    $sql = "INSERT INTO messages (content) VALUES (:content)";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':content', $content);

    try {
        $stmt->execute();
        echo "留言已成功提交";
    } catch (PDOException $e) {
        echo "留言提交失败: " . $e->getMessage();
    }
}
?>

<form method="post">
    <textarea name="content"></textarea><br>
    <button type="submit">提交留言</button>
</form>