如何从单选按钮中一一提交所选答案

debugcn 发表于 Dev

你喜欢爵士乐

我想在我的数据库中一一提交单选按钮中给出的答案，但我不知道如何提交。我尝试了一些东西，但没有成功。

这是一个调查，这就是为什么我要一个一个地保存问题答案。关于代码的问题是代码中的for循环。

我尝试更改我的 Sql 查询，但没有帮助

    <form method="POST">
    <?php
        include '../include/db_conn.php';
            $url = $_GET['surveyUrl'];
            $sqlGetSurvey = 'SELECT * FROM `survey_info` WHERE `survey_url`="'. $url .'"';
            $resultGetSurvey = mysqli_query($conn, $sqlGetSurvey);

            if ($resultGetSurvey ->num_rows > 0) {
                while ($row = $resultGetSurvey-> fetch_assoc()) {
                    $surveyId = $row['survey_id'];
                    $sqlGetQuestion = 'SELECT * FROM `survey_questions` WHERE `survey_id`="'. $surveyId .'"';
                    $sqlGetSurvey = 'SELECT * FROM `survey_info` WHERE `survey_id`="'. $surveyId .'"';
                    $resultGetQuestion = mysqli_query($conn, $sqlGetQuestion);
                    $resultGetSurvey = mysqli_query($conn, $sqlGetSurvey);
                    if ($row = mysqli_fetch_assoc($resultGetSurvey)) {
                        $text_color = $row['survey_text_color'];
                        $background_color = $row['survey_background_color'];
                        $theme_color = $row['survey_theme_color'];
                    }
                    if ($resultGetQuestion ->num_rows > 0) {
                        while ($row = $resultGetQuestion-> fetch_assoc()) {
                            $questionId = $row['question_id'];
                            $count = 'A';


                            $yuyu = "<ul  class='list-group mx-auto mt-3'>
                            <li class='list-group-item'>". $row['question'] ."</li>";

                            $sqlGetAnswers = 'SELECT * FROM `survey_question_answers` WHERE `question_id`='. $questionId .'';
                            $resultGetAnswers = mysqli_query($conn, $sqlGetAnswers);

                            if ($resultGetAnswers ->num_rows > 0) {
                                while ($row = $resultGetAnswers-> fetch_assoc()) {
                                    $yuyu .= "<li class='list-group-item'><span class='badge badge-light main-color-bg'>". $count .". <input type='radio' name='$questionId' value='$count'></span> ". $row['answer'] ."</li>";

                                    ++$count;

                                }
                            }
                            echo '</ul>';
                            echo $yuyu;
                        }
                    }
                }
            }


            if(isset($_POST['submit']))
            {

            for($x= 1; $x <= $questionId; $x++){
                $antwoord = $_POST[$questionId];
                $sql = "INSERT INTO survey_answers (question_id, survey_id, answers) VALUES ('$questionId', '$surveyId', '$antwoord')";
            }
        }


    ?>
        <input type="submit" name="submit" value="Show answer" class="btn btn-primary mb-3 mt-3">
</form>

我希望它在我的数据库中一一插入

天使.bonev

您需要执行插入查询

if (isset($_POST['submit'])) {
    for ($x = 1; $x <= $questionId; $x++) {
        if (isset($_POST[$x])) {//maybe you need to check if the question exists
            $antwoord = $_POST[$x];
            $sql = "INSERT INTO survey_answers (question_id, survey_id, answers) VALUES ('$questionId', '$surveyId', '$antwoord')";
            if ($conn->query($sql) === TRUE) {
                echo "New record created successfully";
            } else {
                echo "Error: " . $sql . "<br>" . $conn->error;
            }
        }
    }
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。