phpcms 问卷调查模块

<?php
// 连接数据库
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

// 查询问卷调查数据
$sql = "SELECT * FROM survey_questions";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "<h2>" . $row["question"] . "</h2>";
        echo "<ul>";
        foreach (explode(",", $row["options"]) as $option) {
            echo "<li><input type='radio' name='answer_" . $row["id"] . "' value='" . $option . "'>" . $option . "</li>";
        }
        echo "</ul>";
    }
} else {
    echo "没有问卷调查数据";
}

// 提交问卷调查数据
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    foreach ($_POST as $key => $value) {
        if (strpos($key, "answer_") === 0) {
            $question_id = str_replace("answer_", "", $key);
            $sql = "INSERT INTO survey_answers (question_id, answer) VALUES ('$question_id', '$value')";
            if ($mysqli->query($sql) === TRUE) {
                echo "提交成功";
            } else {
                echo "提交失败: " . $mysqli->error;
            }
        }
    }
}

$mysqli->close();
?>