PHP MySQL Insert survey answers into table -
if have html , php code:
<?php if(isset($_post["submit"])) { $num = $_post['number']; ($i = 0; $i < $num; $i++) { if($i==0) { echo '0'; $answer1 = $_post["answer1"]; $answer2 = $_post["answer2"]; $answer3 = $_post["answer3"]; $answer4 = $_post["answer4"]; $answer5 = $_post["answer5"]; $answer6 = $_post["answer6"]; $answer7 = $_post["answer7"]; $answer8 = $_post["answer8"]; } else { echo 'no 0'; $answer1 = $_post["answer1$i"]; $answer2 = $_post["answer2$i"]; $answer3 = $_post["answer3$i"]; $answer4 = $_post["answer4$i"]; $answer5 = $_post["answer5$i"]; $answer6 = $_post["answer6$i"]; $answer7 = $_post["answer7$i"]; $answer8 = $_post["answer8$i"]; } //then insert line items lineitems table bill sequence adhocbills table $sql="insert surveys_completed (survey_sequence, question_seq, answer1, answer2, answer3, answer4, answer5, answer6, answer7, answer8) values ('".$_post["survey_sequence"]."', '".$_post["question_seq"]."', '".$answer1."', '".$answer2."', '".$answer3."', '".$answer4."', '".$answer5."', '".$answer6."', '".$answer7."', '".$answer8."')"; $rs=mysql_query($sql,$conn) or die(mysql_error()); echo $sql.'<br><br>'; } } ?> <?php /* if(mysql_real_escape_string($_get["string"]) == '') { echo 'no survey selected'; exit(); } */ if(mysql_real_escape_string($_get["company"]) != '') { //sql company $sql="select * surveys company = '".mysql_real_escape_string($_get["company"])."' , string = '".mysql_real_escape_string($_get["string"])."' "; } elseif(mysql_real_escape_string($_get["string"]) != '') { //sql string $sql="select * surveys string = '".mysql_real_escape_string($_get["string"])."' "; } $rs=mysql_query($sql,$conn) or die(mysql_error()); $survey=mysql_fetch_array($rs); echo '<h3>'.$survey["title"].'</h3>'; ?> <form method="post" action="/home.php?id=surveys/complete_survey"> <table width="600" border="0" cellspacing="5" cellpadding="5"> <?php $sql2="select * surveys_questions survey_seq = '".$survey["sequence"]."' "; $rs2=mysql_query($sql2,$conn) or die(mysql_error()); $counter=0; while($survey_questions=mysql_fetch_array($rs2)) { $counter++; ?> <tr> <td colspan="2"><strong><?php echo $counter; ?>. <?php echo $survey_questions["question"]; ?></strong> counter<input type="text" name="number" id="number" value="<?php echo $counter; ?>" /> survey<input type="text" name="survey_sequence" id="survey_sequence" value="<?php echo $survey["sequence"]; ?>" /> question<input type="text" name="question_seq" id="question_seq" value="<?php echo $survey_questions["sequence"]; ?>" /></td> </tr> <tr> <td><?php if($survey_questions["answer1"] != '') { echo '<input type="checkbox" name="answer1'.$counter.'" value="y" /> '.$survey_questions["answer1"]; } ?></td> <td><?php if($survey_questions["answer2"] != '') { echo '<input type="checkbox" name="answer2'.$counter.'" value="y" /> '.$survey_questions["answer2"]; } ?></td> </tr> <tr> <td><?php if($survey_questions["answer3"] != '') { echo '<input type="checkbox" name="answer3'.$counter.'" value="y" /> '.$survey_questions["answer3"]; } ?></td> <td><?php if($survey_questions["answer4"] != '') { echo '<input type="checkbox" name="answer4'.$counter.'" value="y" /> '.$survey_questions["answer4"]; } ?></td> </tr> <tr> <td><?php if($survey_questions["answer5"] != '') { echo '<input type="checkbox" name="answer5'.$counter.'" value="y" /> '.$survey_questions["answer5"]; } ?></td> <td><?php if($survey_questions["answer6"] != '') { echo '<input type="checkbox" name="answer6'.$counter.'" value="y" /> '.$survey_questions["answer6"]; } ?></td> </tr> <tr> <td><?php if($survey_questions["answer7"] != '') { echo '<input type="checkbox" name="answer7'.$counter.'" value="y" /> '.$survey_questions["answer7"]; } ?></td> <td><?php if($survey_questions["answer8"] != '') { echo '<input type="checkbox" name="answer8'.$counter.'" value="y" /> '.$survey_questions["answer8"]; } ?></td> </tr> <?php } ?> <tr> <td colspan="2"><input type="submit" name="submit" id="submit" value="complete survey" /> </tr> </table> </form> so code selects survey survey table , gets questions survey_questions selected survey.
each question has 8 answers (all checkboxes value of y)
the user goes though , checks box answer(s) choose when form submitted, how can make insert surveys_completed table each answer.
so each question, adds row in surveys_completed table.
the structure of surveys_completed table is:
sequence survey_sequence question_seq answer1 answer2 answer3 answer4 answer5 answer6 answer7 answer8
create page called getval.php put below code , have make sure connect database using pdo thats when code gonna work . h hope luck
<?php $answer1=(isset($_post['answer1']))? trim($_post['answer1']): ''; $answer2=(isset($_post['answer2']))? trim($_post['answer2']): ''; $answer3=(isset($_post['answer3']))? trim($_post['answer3']): ''; $answer4=(isset($_post['answer4']))? trim($_post['answer4']): ''; $answer5=(isset($_post['answer5']))? trim($_post['answer5']): ''; $answer6=(isset($_post['answer6']))? trim($_post['answer6']): ''; $answer7=(isset($_post['answer7']))? trim($_post['answer7']): ''; $answer8=(isset($_post['answer8']))? trim($_post['answer8']): ''; $query="insert surveys_completed( answer1,answer2,answer3,answer4,answer5,answer5,answer6,answer7,answer8 ) values(:answer1,:answer2,:answer3,:answer4,:answer5,:answer5, :answer6,:answer7,:answer8)"; $insert = $con->prepare($query); $insert->execute(array( ':answer1'=>$answer1, ':answer2'=>$answer2, ':answer3'=>$answer3, ':answer4'=>$answer4, ':answer5'=>$answer5, ':answer6'=>$answer6, ':answer7'=>$answer7, ':answer8'=>$answer8 )); ?> 
Comments
Post a Comment