基本上,我可以根据下拉框的选择来显示div。现在我的问题是:当只有一个文本字段时,我可以插入数据。当有2个文本字段时,提交是成功的,但在数据库中找不到数据。不过,数据库中有1行被占用。
<?php
//database
$connection = mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db("survey" , $connection) or die (mysql_error());
if(isset($_POST['submit'])){
$surveyID =$_POST['surveyCategory'];
for($i=0; $i<count($_POST['id']); $i++){
$questionID = $_POST['id'][$i];
$answer = mysql_real_escape_string(htmlspecialchars($_POST['answer'][$i]));
mysql_query("INSERT INTO answers(survey_id, question_id, answer_body) VALUES ('$surveyID', '$questionID', '$answer')") or die (mysql_error());
}
}
?>
<style>
div{
display: none;
}
</style>
<html>
<body>
<form name=displayQuestion method="post">
Survey Categories :
<select name="surveyCategory" id="surveyCategory">
<option> Choose Survey Category </option>
<?php
$surveyQuery = "SELECT survey_id, survey_name FROM surveys";
$result = mysql_query($surveyQuery) or die (mysql_error());
while($menu=mysql_fetch_assoc($result)){
echo "<option value=$menu[survey_id]>$menu[survey_name]</option>";
}
?>
</select>
<!-- if selection is auction -->
<div id="1" style="display:none">
<?php
$auctionSurvey = "SELECT question_id, survey_id, question_body FROM questions
WHERE survey_id='1'";
$aucResult = mysql_query($auctionSurvey) or die (mysql_error());
while($auctionRow = mysql_fetch_assoc($aucResult)){
echo $auctionRow['question_body'] . "<input type=text name=answer[]><BR>";?>
<input type="hidden" name="id[]" value="<?php echo $auctionRow['question_id']?>">
<?php
}
?>
<input type="submit" name="submit" value="Submit">
</div>
<!-- if selection is Competition -->
<div id="2">
<?php
$compSurvey = "SELECT survey_id, question_body FROM questions
WHERE survey_id='2'";
$compResult = mysql_query($compSurvey) or die (mysql_error());
while($compRow = mysql_fetch_assoc($compResult)){
echo "$compRow[question_body]" . "<input type=text name=><BR>";
}
?>
<input type="hidden" name="id" value="<?php echo "$compRow [question_id]"?>">
<input type="submit" name="submit" value="Submit">
</div>
<!-- if selection is Gallery -->
<div id="3">
<?php
$gallerySurvey = "SELECT survey_id, question_body FROM questions
WHERE survey_id='3'";
$galleryResult = mysql_query($gallerySurvey) or die (mysql_error());
while($galleryRow = mysql_fetch_assoc($galleryResult)){
echo " $galleryRow[question_body]" . "<input type=text name=answer><BR>";
}
?>
<input type="hidden" name="id" value="<?php echo "$galleryRow [question_id]"?>">
<input type="submit" name="submit" value="Submit">
</div>
</form>
</body>
</html>
<script>
document.getElementById('surveyCategory').onchange = function() {
var i = 1;
var myDiv = document.getElementById(i);
while(myDiv) {
myDiv.style.display = 'none';
myDiv = document.getElementById(++i);
}
document.getElementById(this.value).style.display = 'block';
};
</script>
我已经更新了答案。。
<?php
//database
$connection = mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db("survey" , $connection) or die (mysql_error());
if(isset($_POST['submit'])){
$surveyID =$_POST['surveyCategory'];
for($i=0; $i<count($_POST['id']); $i++){
$questionID = $_POST['id'][$surveyID][$i];
$answer = mysql_real_escape_string(htmlspecialchars($_POST['answer'][$surveyID][$i]));
mysql_query("INSERT INTO answers(survey_id, question_id, answer_body) VALUES ('$surveyID', '$questionID', '$answer')") or die (mysql_error());
}
}
?>
<style>
div{
display: none;
}
</style>
<html>
<body>
<form name="displayQuestion" method="post">
Survey Categories :
<select name="surveyCategory" id="surveyCategory">
<option> Choose Survey Category </option>
<?php
$surveyQuery = "SELECT survey_id, survey_name FROM surveys";
$result = mysql_query($surveyQuery) or die (mysql_error());
while($menu=mysql_fetch_assoc($result)){
echo '<option value="'.$menu['survey_id'].'">'.$menu['survey_name'].'</option>';
}
?>
</select>
<!-- if selection is auction -->
<div id="1" style="display:none">
<?php
$auctionSurvey = "SELECT question_id, survey_id, question_body FROM questions
WHERE survey_id='1'";
$aucResult = mysql_query($auctionSurvey) or die (mysql_error());
while($auctionRow = mysql_fetch_assoc($aucResult)){
echo $auctionRow['question_body'] . "<input type=text name=answer[1][]><BR>";?>
<input type="hidden" name="id[1][]" value="<?php echo $auctionRow['question_id']?>">
<?php
}
?>
<input type="submit" name="submit" value="Submit">
</div>
<!-- if selection is Competition -->
<div id="2">
<?php
$compSurvey = "SELECT survey_id, question_body FROM questions
WHERE survey_id='2'";
$compResult = mysql_query($compSurvey) or die (mysql_error());
while($compRow = mysql_fetch_assoc($compResult)){
echo "$compRow[question_body]" . "<input type='text' name='answer[2][]'><BR>";?>
<input type="hidden" name="id[2][]" value="<?php echo $compRow['question_id']?>"><?php
}
?>
<input type="submit" name="submit" value="Submit">
</div>
<!-- if selection is Gallery -->
<div id="3">
<?php
$gallerySurvey = "SELECT survey_id, question_body FROM questions
WHERE survey_id='3'";
$galleryResult = mysql_query($gallerySurvey) or die (mysql_error());
while($galleryRow = mysql_fetch_assoc($galleryResult)){
echo $galleryRow[question_body] . "<input type='text' name='answer[3][]'><BR>";?>
<input type="hidden" name="id[3][]" value="<?php echo $galleryRow ['question_id']?>"><?php
}
?>
<input type="submit" name="submit" value="Submit">
</div>
</form>
</body>
</html>
<script>
document.getElementById('surveyCategory').onchange = function() {
var i = 1;
var myDiv = document.getElementById(i);
while(myDiv) {
myDiv.style.display = 'none';
myDiv = document.getElementById(++i);
}
document.getElementById(this.value).style.display = 'block';
};
</script>
只需粘贴它并尝试
您犯了几个错误:
- 可能有多个字段具有相同的名称
- 不使用循环插入数据
- 在查询中使用$id之前没有报价
第一个修复
添加"[]"作为答案:
while($auctionRow = mysql_fetch_assoc($aucResult)){
echo "$auctionRow[question_body]" .
"<input type='"text'" name='"answerswer[]'"><BR>";
}
第二次修复
为每个插入的答案添加一个循环,以防有多个:
if (isset($_POST['submit'])){
$id = $_POST['surveyCategory'];
//escaping $id
$id = mysql_real_escape_string($id);
$questionID = $_POST['id'];
$answers = $_POST['answer'];
foreach($answers as $answer)
{
$answer = mysql_real_escape_string(htmlspecialchars($answer));
mysql_query("INSERT INTO answers(survey_id, question_id, answer_body) VALUES ('$id', '$questionID', '$answer')") or die (mysql_error());
}
}
另外,mysql_*函数也不推荐使用,请考虑切换到mysqli或PDO。