PHP開発：ユーザーコメント機能の実装方法

CREATE TABLE comments (
    id INT(11) PRIMARY KEY AUTO_INCREMENT,
    user_id INT(11),
    content TEXT,
    created_at DATETIME,
    updated_at DATETIME
);

<?php
// 获取用户提交的评论内容
$content = $_POST['content'];

// 获取当前时间
$currentDateTime = date('Y-m-d H:i:s');

// 构建插入评论的SQL语句
$sql = "INSERT INTO comments (user_id, content, created_at, updated_at) VALUES ('1', '$content', '$currentDateTime', '$currentDateTime')";

// 执行SQL插入语句
$result = mysqli_query($conn, $sql);

if($result) {
    echo "评论提交成功！";
} else {
    echo "评论提交失败！";
}
?>

<?php
// 获取所有评论数据
$sql = "SELECT * FROM comments";
$result = mysqli_query($conn, $sql);

// 遍历评论数据并展示给用户
while($row = mysqli_fetch_assoc($result)) {
    echo "<div>";
    echo "<p>用户ID：" . $row['user_id'] . "</p>";
    echo "<p>评论内容：" . $row['content'] . "</p>";
    echo "<p>评论时间：" . $row['created_at'] . "</p>";
    echo "</div>";
}
?>

<?php
// 获取用户传递的要删除的评论ID
$commentId = $_GET['comment_id'];

// 构建删除评论的SQL语句
$sql = "DELETE FROM comments WHERE id = '$commentId'";

// 执行SQL删除语句
$result = mysqli_query($conn, $sql);

if($result) {
    echo "评论删除成功！";
} else {
    echo "评论删除失败！";
}
?>

<?php
// 获取用户传递的要更新的评论ID
$commentId = $_GET['comment_id'];

// 获取要更新的评论数据
$sql = "SELECT * FROM comments WHERE id = '$commentId'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);

// 展示评论的内容和一个表单供用户更新评论
echo "<form action='update_comment.php' method='post'>";
echo "<input type='hidden' name='comment_id' value='" . $row['id'] . "'>";
echo "<textarea name='content'>" . $row['content'] . "</textarea>";
echo "<button type='submit'>更新评论</button>";
echo "</form>";
?>