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

Question

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

这是为了调查，这就是为什么我想一个接一个地保存问题答案。关于代码的问题是代码中的 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>

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

Answer 1

您需要执行插入查询

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;
}
}
}
}