dedecms 留言板修改

// 示例代码：submit.php
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $name = $_POST['name'];
    $email = $_POST['email'];
    $content = $_POST['content'];

    // 数据库连接
    $conn = mysqli_connect('localhost', 'username', 'password', 'database');
    if (!$conn) {
        die('连接失败: ' . mysqli_connect_error());
    }

    // 插入数据
    $sql = "INSERT INTO `dede_feedback` (`name`, `email`, `content`) VALUES ('$name', '$email', '$content')";
    if (mysqli_query($conn, $sql)) {
        echo '留言成功！';
    } else {
        echo '留言失败: ' . mysqli_error($conn);
    }

    mysqli_close($conn);
}
?>

// 示例代码：修改数据库字符集
ALTER DATABASE `database` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `dede_feedback` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

// 示例代码：防止SQL注入
$stmt = $conn->prepare("INSERT INTO `dede_feedback` (`name`, `email`, `content`) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $name, $email, $content);
$stmt->execute();