phpcms评论

// 示例代码：检查数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database");
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 示例代码：处理评论提交
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $comment = $_POST['comment'];
    $article_id = $_POST['article_id'];
    $user_id = $_SESSION['user_id'];

    $sql = "INSERT INTO comments (article_id, user_id, comment) VALUES (?, ?, ?)";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("iss", $article_id, $user_id, $comment);
    if ($stmt->execute()) {
        echo "Comment saved successfully!";
    } else {
        echo "Error saving comment: " . $stmt->error;
    }
    $stmt->close();
}

// 示例代码：设置数据库字符集
$mysqli->set_charset("utf8mb4");