php - 如果名称来自数据库的数组，如何插入数据库，因为我们不知道将来会有多少数组
问题描述
<form method="post" enctype="multipart/form-data">
<div class="col-md-12 quest-cat-parent">
<h2 class="quest-cat-head">Economy</h2>
</div>
<div class="form">
<div class="questions-all my-4">
<div class="question">
<?php
$economy = "SELECT * FROM questions WHERE category_id = '1'";
$run_economy = mysqli_query($conn, $economy);
$count = mysqli_num_rows($run_economy);
while ($row = mysqli_fetch_assoc($run_economy)) {
$quest_title = $row['quest_title'];
$quest_id = $row['quest_id'];
// echo $i;
echo '
<div class="quest-title">
<h4>' . $quest_title . '</h4>
</div>';
$options_economy = "SELECT * FROM options WHERE question_id='$quest_id'";
$run_opt_economy = mysqli_query($conn, $options_economy);
$count = array(mysqli_num_rows($run_opt_economy));
// echo $count1;
while ($row2 = mysqli_fetch_assoc($run_opt_economy)) {
$options_available = $row2['options'];
$options_id = $row2['id'];
$party_1_value = $row2['party1_value'];
$party_2_value = $row2['party2_value'];
if ($options_available == 'Empty Choice') {
echo '';
} else {
echo '<div class="options">
<div class="form-check">';
if ($options_available == 'Yes') {
echo '<input class="form-check-input form-check-input-yes" type="radio"
name="economy[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-yes">
' . $options_available . ' </label>';
} else {
echo '<input class="form-check-input form-check-input-no" type="radio"
name="economy[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-no">
' . $options_available . ' </label>';
}
echo '</div>
</div>';
}
}
}
?>
</div>
</div>
<div class="col-md-12 quest-cat-parent">
<h2 class="quest-cat-head">Social Issues</h2>
</div>
<div class="form">
<div class="questions-all my-4">
<div class="question">
<?php
$economy = "SELECT * FROM questions WHERE category_id = '2'";
$run_economy = mysqli_query($conn, $economy);
$count = mysqli_num_rows($run_economy);
while ($row = mysqli_fetch_assoc($run_economy)) {
$quest_title = $row['quest_title'];
$quest_id = $row['quest_id'];
echo '
<div class="quest-title">
<h4>' . $quest_title . '</h4>
<input type="hidden" name="social_quest" value=' . $quest_id . '>
</div>';
$options_economy = "SELECT * FROM options WHERE question_id='$quest_id'";
$run_opt_economy = mysqli_query($conn, $options_economy);
while ($row2 = mysqli_fetch_assoc($run_opt_economy)) {
$options_available = $row2['options'];
$options_id = $row2['id'];
$party_1_value = $row2['party1_value'];
$party_2_value = $row2['party2_value'];
if ($options_available == 'Empty Choice') {
echo '';
} else {
echo '<div class="options">
<div class="form-check">';
if ($options_available == 'Yes') {
echo '<input class="form-check-input form-check-input-yes" type="radio"
name="social[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-yes">
' . $options_available . ' </label>';
} else {
echo '<input class="form-check-input form-check-input-no" type="radio"
name="social[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-no">
' . $options_available . ' </label>';
}
echo '</div>
</div>';
}
}
}
?>
</div>
</div>
<div class="col-md-12 quest-cat-parent">
<h2 class="quest-cat-head">Environmental Issues</h2>
</div>
<div class="form">
<div class="questions-all my-4">
<div class="question">
<?php
$economy = "SELECT * FROM questions WHERE category_id = '3'";
$run_economy = mysqli_query($conn, $economy);
$count = mysqli_num_rows($run_economy);
while ($row = mysqli_fetch_assoc($run_economy)) {
$quest_title = $row['quest_title'];
$quest_id = $row['quest_id'];
echo '
<div class="quest-title">
<h4>' . $quest_title . '</h4>
<input type="hidden" name="environmental_quest" value=' . $quest_id . '>
</div>';
$options_economy = "SELECT * FROM options WHERE question_id='$quest_id'";
$run_opt_economy = mysqli_query($conn, $options_economy);
while ($row2 = mysqli_fetch_assoc($run_opt_economy)) {
$options_available = $row2['options'];
$options_id = $row2['id'];
$party_1_value = $row2['party1_value'];
$party_2_value = $row2['party2_value'];
if ($options_available == 'Empty Choice') {
echo '';
} else {
echo '<div class="options">
<div class="form-check">';
if ($options_available == 'Yes') {
echo '<input class="form-check-input form-check-input-yes" type="radio"
name="environmental[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-yes">
' . $options_available . ' </label>';
} else {
echo '<input class="form-check-input form-check-input-no" type="radio"
name="environmental[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-no">
' . $options_available . ' </label>';
}
echo '</div>
</div>';
}
}
}
?>
</div>
</div>
<div class="col-md-12 quest-cat-parent">
<h2 class="quest-cat-head">Healthcare Issues</h2>
</div>
<div class="form">
<div class="questions-all my-4">
<div class="question">
<?php
$economy = "SELECT * FROM questions WHERE category_id = '4'";
$run_economy = mysqli_query($conn, $economy);
$count = mysqli_num_rows($run_economy);
while ($row = mysqli_fetch_assoc($run_economy)) {
$quest_title = $row['quest_title'];
$quest_id = $row['quest_id'];
echo '
<div class="quest-title">
<h4>' . $quest_title . '</h4>
<input type="hidden" name="healthcare_quest" value=' . $quest_id . '>
</div>';
$options_economy = "SELECT * FROM options WHERE question_id='$quest_id'";
$run_opt_economy = mysqli_query($conn, $options_economy);
while ($row2 = mysqli_fetch_assoc($run_opt_economy)) {
$options_available = $row2['options'];
$options_id = $row2['id'];
$party_1_value = $row2['party1_value'];
$party_2_value = $row2['party2_value'];
if ($options_available == 'Empty Choice') {
echo '';
} else {
echo '<div class="options">
<div class="form-check">';
if ($options_available == 'Yes') {
echo '<input class="form-check-input form-check-input-yes" type="radio"
name="healthcare[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-yes">
' . $options_available . ' </label>';
} else {
echo '<input class="form-check-input form-check-input-no" type="radio"
name="healthcare[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-no">
' . $options_available . ' </label>';
}
echo '</div>
</div>';
}
}
}
?>
</div>
</div>
<div class="col-md-12 quest-cat-parent">
<h2 class="quest-cat-head">Science Issues</h2>
</div>
<div class="form">
<div class="questions-all my-4">
<div class="question">
<?php
$economy = "SELECT * FROM questions WHERE category_id = '5'";
$run_economy = mysqli_query($conn, $economy);
$count = mysqli_num_rows($run_economy);
while ($row = mysqli_fetch_assoc($run_economy)) {
$quest_title = $row['quest_title'];
$quest_id = $row['quest_id'];
echo '
<div class="quest-title">
<h4>' . $quest_title . '</h4>
<input type="hidden" name="science_quest" value=' . $quest_id . '>
</div>';
$options_economy = "SELECT * FROM options WHERE question_id='$quest_id'";
$run_opt_economy = mysqli_query($conn, $options_economy);
while ($row2 = mysqli_fetch_assoc($run_opt_economy)) {
$options_available = $row2['options'];
$options_id = $row2['id'];
$party_1_value = $row2['party1_value'];
$party_2_value = $row2['party2_value'];
if ($options_available == 'Empty Choice') {
echo '';
} else {
echo '<div class="options">
<div class="form-check">';
if ($options_available == 'Yes') {
echo '<input class="form-check-input form-check-input-yes" type="radio"
name="science[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-yes">
' . $options_available . ' </label>';
} else {
echo '<input class="form-check-input form-check-input-no" type="radio"
name="science[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-no">
' . $options_available . ' </label>';
}
echo '</div>
</div>';
}
}
}
?>
</div>
</div>
<div class="col-md-12 quest-cat-parent">
<h2 class="quest-cat-head">Foreign Policy</h2>
</div>
<div class="form">
<div class="questions-all my-4">
<div class="question">
<?php
$economy = "SELECT * FROM questions WHERE category_id = '6'";
$run_economy = mysqli_query($conn, $economy);
$count = mysqli_num_rows($run_economy);
while ($row = mysqli_fetch_assoc($run_economy)) {
$quest_title = $row['quest_title'];
$quest_id = $row['quest_id'];
echo '
<div class="quest-title">
<h4>' . $quest_title . '</h4>
<input type="hidden" name="foreign_quest" value=' . $quest_id . '>
</div>';
$options_economy = "SELECT * FROM options WHERE question_id='$quest_id'";
$run_opt_economy = mysqli_query($conn, $options_economy);
while ($row2 = mysqli_fetch_assoc($run_opt_economy)) {
$options_available = $row2['options'];
$options_id = $row2['id'];
$party_1_value = $row2['party1_value'];
$party_2_value = $row2['party2_value'];
if ($options_available == 'Empty Choice') {
echo '';
} else {
echo '<div class="options">
<div class="form-check">';
if ($options_available == 'Yes') {
echo '<input class="form-check-input form-check-input-yes" type="radio"
name="foreign[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-yes">
' . $options_available . ' </label>';
} else {
echo '<input class="form-check-input form-check-input-no" type="radio"
name="foreign[' . $quest_id . ']" value=' . $options_id . '>
<input type="hidden" name="party1_value" value=' . $party_1_value . '>
<input type="hidden" name="party2_value" value=' . $party_2_value . '>
<label class="form-check-label form-check-label-no">
' . $options_available . ' </label>';
}
echo '</div>
</div>';
}
}
}
?>
</div>
</div>
<button type="submit"
style="font-weight:900;border:none;border-radius:4px;background: #00ff11;padding: 10px;">Show
My
Result <i class="fa fa-check" aria-hidden="true"></i></button>
</form>
在这里，您可以看到带有 id 的选项在 while 循环中从数据库中获取，并且在每个选项的名称中，都有一个名称经济传入，每个问题 id 从数据库中传入。页面中有更多问题和更多选项，它们的名称经济加上每个问题的问题 ID。我希望访问者从每个问题中只选择一个选项，并且每个问题的他选择的选项应该插入到带有问题 ID 和他选择的选项的数据库中。
解决方案
推荐阅读
- c++ - 使用 size_t 的列表实现与想要的构造函数不匹配
- node.js - 如何迁移需要导入到带有柯里化的 es6 导入
- python - 我应该如何检查给定元素是否在列表范围内？
- c++ - 提示重载函数模板作为模板参数的最简洁的方法是什么
- python - 为什么我的 django 项目即使在上传后仍然没有显示任务？
- javascript - Typescript expressjs 全局辅助方法
- javascript - React 开发工具未显示更新状态
- android - 由于 IMA 扩展特别在 Android 11 中的 Oppo 设备上调用 AudioManager 功能而导致 ANR
- c# - 如何获得小时之间的间隔并从开始到结束放入列表？
- python - Python - 替换几个字符