通过 HTML 表单将问题添加到数据库时选择正确答案

Question

>我有一个表格，里面有问题和 4 个答案(这是一个测验(，我试图评论 https://stackoverflow.com/a/29280091/6482242 但我没有足够的声誉。这与我所拥有的非常相似(以及如何通过复选框设置正确答案？

我的布局是：

<label for="question_text">Question Text:</label>
<textarea title="Insert Question Text" name="question_text"></textarea>
<h4>Check Correct answer -></h4>
<input type="radio" name="correct_answer_flag" value="1">
<label for="correct_answer_flag, answer_1">Answer One:</label>
<input type="text" title="Enter Answer" name="answer_1" />
<br />
<br />
<input type="radio" name="correct_answer_flag" value="1">
<label for="correct_answer_flag, answer_2">Answer Two:</label>
<input type="text" title="Enter Answer" name="answer_2" />
<br />
<br />
<input type="radio" name="correct_answer_flag" value="1">
<label for="correct_answer_flag, answer_3">Answer Three:</label>
<input type="text" title="Enter Answer" name="answer_3" />
<br />
<br />
<input type="radio" name="correct_answer_flag" value="1">
<label for="correct_answer_flag, answer_4">Answer Four:</label>
<input type="text" title="Enter Answer" name="answer_4" />
<br />
<br />
<input type="submit" value="Submit Question" name="question_submit" />

后台有一些PHP可以抓取这些并将它们放入数据库中，但是我需要知道将单选按钮链接到文本输入的正确语法是什么？

提前致谢:D

Answer 1

您应该更改单选按钮的值，然后将其值存储到表中的单独列中，其列类似于correct_answer

<label for="question_text">Question Text:</label>
<textarea title="Insert Question Text" name="question_text"></textarea>
<h4>Check Correct answer -></h4>
<input type="radio" name="correct_answer_flag" value="1">
<label for="correct_answer_flag, answer_1">Answer One:</label>
<input type="text" title="Enter Answer" name="answer_1" />
<br />
<br />
<input type="radio" name="correct_answer_flag" value="2">
<label for="correct_answer_flag, answer_2">Answer Two:</label>
<input type="text" title="Enter Answer" name="answer_2" />
<br />
<br />
<input type="radio" name="correct_answer_flag" value="3">
<label for="correct_answer_flag, answer_3">Answer Three:</label>
<input type="text" title="Enter Answer" name="answer_3" />
<br />
<br />
<input type="radio" name="correct_answer_flag" value="4">
<label for="correct_answer_flag, answer_4">Answer Four:</label>
<input type="text" title="Enter Answer" name="answer_4" />
<br />
<br />
<input type="submit" value="Submit Question" name="question_submit" />

在该列中，仅存储所选收音机的编号。因此，对于每个问题，您将存储 4 个选项，在这 4 个选项中将有一个正确答案，其索引将存储在一个单独的表中，您可以在其中存储答案选项。