我对堆叠溢出很陌生,对这个问题的标题有点困惑,但让我解释一下我的问题是什么。
我正在开发的调查系统,在这里,我可以选择管理员输入问题和答案从后端,所以在前端,我显示的问题,答案使用的同时循环的形式。
我的问题是如何编写代码,在mysql中输入多个值(由客户填充的调查)。我在这里附加我的密码。
$(function() {
$('form').bind('submit', function(){
$.ajax({
type: 'post',
url: "/prs/pageCode.php",
data: $("form").serialize(),
success: function() {
alert("Data Saved, Press Next!");
}
});
return false;
});
});表格如下
<form name="form" id="form" class="form-horizontal" action="#"
method="POST">
<fieldset>
<div class="control-group">
<label class="control-label" for="focusedInput">Name</label>
<div class="controls">
<input name="pname" class="input-xlarge focused" id="focusedInput"
type="text" value="" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="email">Email</label>
<div class="controls">
<input name="pemail" class="input-xlarge focused" id="focusedInput"
type="text" value="" required>
</div>
</div>
<div class="control-group">
<label>We would like to post your comments to internet rating sites,
while we may use your name or an alias name. Please select your
desire:</label>
</div>
<div class="control-group">
<label class="control-label" for="focusedInput"></label>
<div class="controls">
<p>
<label> <input type="radio" name="choice" value="yes" id="choice_0">
Yes, use my name as entered above
</label> <label> <input type="radio" name="choice" value="no"
id="choice_1" onChange="enabletextbox();"> Use the alias name, as
I enter below
</label> <input id="alias" name="alias" type="text"
class="input-xlarge focused">
</p>
</div>
</div>
</fieldset>
</div>
<div class="tab-pane" id="tab2">
<fieldset>
<?php
$i=1;
while($row=mysqli_fetch_array($questions)){
?>
<div class="control-group">
<label class="control-label" for="focusedInput">(<?php echo $i;?>) <?php
$questionid = $row['question_id'];
$question = $row['question'];
echo $row['question']; ?></label>
<div class="controls">
<?php
if($row['answer_type']=="Ratings") {
echo "
<p>
Low<input type='radio' name='rating$i' value='1' id='rating_0'>
<input type='radio' name='rating$i' value='2' id='rating_1'>
<input type='radio' name='rating$i' value='3' id='rating_2'>
<input type='radio' name='rating$i' value='4' id='rating_3'>
<input type='radio' name='rating$i' value='5' id='rating_4'>High
</p>
";
}
else if ($row['answer_type']=="Comments") {
echo "<textarea name='answer' cols='' rows=''></textarea>";
}
$i++;
echo "<br />";
$query2 = "insert into review_details (review_id,survey_id,question_id,question,answer_rating,answer_freeresponse) values (1,$surveyid,$questionid,'$question','$rating$i','$_POST[answer]')";
$result2 = mysqli_query($con,$query2);
if(!$result2) {
echo mysqli_error($result2);
}
?>
</div>
</div>
<?php }?>
</fieldset>
</div>
<div class="tab-pane" id="tab3">
<fieldset>
<div class="control-group">
<label class="control-label" for="focusedInput">Testimonial about
your care by <?php echo $_SESSION['doctorname'];?>
</label>
<div class="controls">
<textarea name="review" cols="5" rows="5" required></textarea>
</div>
</div>
<div class="form-actions">
<input type="submit" class="btn btn-primary"
value="Save & Press Finish"></input>
</div>
</fieldset>
pageCode.php
<?php
session_start();
require_once('config.php');
$con=mysqli_connect(HOST,USER,PASSWORD,DATABASE);
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$alias = $_POST['choice'];
if($alias=="yes")
$aliasname = $_POST['pname'];
else
$aliasname = $_POST['alias'];
$sql="INSERT INTO reviews (doctor_id,doctor_name,survey_id,name,email,display_name,overall_review)
VALUES
('$_SESSION[doctorid]','$_SESSION[doctorname]',$_SESSION[surveyid],'$_POST[pname]','$_POST[pemail]','$aliasname','$_POST[review]')";
$result = mysqli_query($con,$sql);
//$result2 = mysqli_query($con,$_SESSION['insertallquery']);
if(!$result) {
echo mysqli_error($result);
}
?>实际上,我想将答案插入到客户填充的数据库中。
发布于 2014-04-07 07:43:46
您需要将答案存储在review表或单独的表中,这是您的愿望。
但总的来说,我所理解的是,您有一个单独的表用于questions和question ids。
因此,您需要在review表中添加列或以question ids作为字段名的单独表。
并将相应的答案存储在该用户的该列中。
就像。考虑在现有reviews表中添加列:
INSERT INTO reviews (doctor_id,doctor_name,survey_id,name,email,display_name,overall_review,q1,q2,q3...)因此,根据你的问题数量。
同时,当您向questions表中添加一个新问题时,您必须确保在此表中使用ALTER TABLE和
为了获得问题的答案,在while循环中,创建一个数组。并使用into循环迭代数组将这些值插入mysql中。
while循环中的查询将如下所示:
INSERT INTO reviews (q.$i) VALUES ($answer[$i]) WHERE docter_id='$_SESSION[doctorid]'发布于 2014-04-07 07:55:05
您可以从in /类名或标记名称本身获取值,然后将其存储在数组中,然后将其传递给jquery ( $.ajax )或($.post),然后接受javascript中声明的数组变量,但我们的标记必须包含临时索引值示例。
另一种方法是以JSON的形式传递答案,然后可以在php中使用json_encode访问答案。
https://stackoverflow.com/questions/22905937
复制相似问题