当前位置：首页 > PHP

php实现表白墙

2026-01-30 08:28:56PHP

实现表白墙的PHP方案

使用PHP结合MySQL数据库可以快速搭建一个简单的表白墙功能。以下为具体实现方法：

数据库设计

创建名为love_wall的数据库，包含一张messages表：

CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender` varchar(50) NOT NULL,
  `receiver` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

核心功能实现

创建index.php作为主页面：

<?php
$db = new PDO('mysql:host=localhost;dbname=love_wall', 'username', 'password');

// 处理表单提交
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $stmt = $db->prepare("INSERT INTO messages (sender, receiver, content) VALUES (?, ?, ?)");
    $stmt->execute([
        htmlspecialchars($_POST['sender']),
        htmlspecialchars($_POST['receiver']),
        htmlspecialchars($_POST['content'])
    ]);
    header("Location: ".$_SERVER['PHP_SELF']);
    exit;
}

// 获取所有留言
$messages = $db->query("SELECT * FROM messages ORDER BY created_at DESC")->fetchAll();
?>
<!DOCTYPE html>
<html>
<head>
    <title>校园表白墙</title>
    <style>
        .message { border: 1px solid #eee; padding: 15px; margin-bottom: 10px; }
    </style>
</head>
<body>
    <h1>表白墙</h1>

    <form method="post">
        你的昵称: <input type="text" name="sender" required><br>
        想对谁表白: <input type="text" name="receiver" required><br>
        表白内容: <textarea name="content" required></textarea><br>
        <button type="submit">提交</button>
    </form>

    <div class="messages">
        <?php foreach ($messages as $msg): ?>
        <div class="message">
            <strong><?= $msg['sender'] ?> 对 <?= $msg['receiver'] ?> 说：</strong>
            <p><?= nl2br($msg['content']) ?></p>
            <small><?= $msg['created_at'] ?></small>
        </div>
        <?php endforeach; ?>
    </div>
</body>
</html>

安全增强措施

为防止XSS攻击和SQL注入，需要采取以下措施：

// 所有用户输入都经过htmlspecialchars处理
$stmt = $db->prepare("INSERT INTO messages (sender, receiver, content) VALUES (?, ?, ?)");
$stmt->execute([
    htmlspecialchars($_POST['sender']),
    htmlspecialchars($_POST['receiver']),
    htmlspecialchars($_POST['content'])
]);

// 数据库连接使用PDO预处理语句
$db = new PDO('mysql:host=localhost;dbname=love_wall', 'username', 'password');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

功能扩展建议

添加分页功能避免数据过多

$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$limit = 10;
$offset = ($page - 1) * $limit;
$messages = $db->query("SELECT * FROM messages ORDER BY created_at DESC LIMIT $limit OFFSET $offset")->fetchAll();

增加点赞功能

ALTER TABLE messages ADD COLUMN likes INT DEFAULT 0;

实现匿名发布功能

php实现表白墙

// 表单中添加匿名选项
<input type="checkbox" name="anonymous" value="1"> 匿名发布
// 处理时判断
$sender = $_POST['anonymous'] ? '匿名' : htmlspecialchars($_POST['sender']);