furrls

ok when i submit the form, it still insert the result despite blank answers at my process page. this is my code at the process page $studID = $_POST['studentID']; if ((count($_POST['answers'])) < (count($_POST['question']))) { die("PLEASE COMPLETE ALL QUESIOJN"); } else { foreach ($_POST['answers'] as $qID=>$answer) { echo ''.$_SESSION['username'].' answered '.$answer.' for qID '.$qID.'<br/>'; $SQL = "INSERT INTO responses (student_id, question_id, answer) VALUES ('$studID','$qID', '$answer')"; $result = mysql_query($SQL); } } print "Thanks for voting!";

yea, but i'm printing many question from a while loop so there will some question that the user will miss and he will just submit without any validation, so how could prevent that? such as user will have to comeplete ALL question before he is able to submit

validate as in u have to fill in all the radio buttons before you can submit if not a popout or any error will show it to the user

<?php $SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.* FROM stu_satisfaction_tblquestions LEFT JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id WHERE stu_satisfaction_tblquestions.answers_id BETWEEN '1' AND '2' "; $result = mysql_query($SQL); while ($data = mysql_fetch_array($result)) { echo $data['question'].'<br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$data['answer1'].'" value="1" /><label for="'.$data['question_id'].'_'.$data['answer1'].'">'.$data['answer1'].'</label><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$data['answer2'].'" value="2" /><label for="'.$data['question_id'].'_'.$data['answer2'].'">'.$data['answer2'].'</label><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$data['answer3'].'" value="3" /><label for="'.$data['question_id'].'_'.$data['answer3'].'">'.$data['answer3'].'</label><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$data['answer4'].'" value="4" /><label for="'.$data['question_id'].'_'.$data['answer4'].'">'.$data['answer4'].'</label><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$data['answer5'].'" value="5" /><label for="'.$data['question_id'].'_'.$data['answer5'].'">'.$data['answer5'].'</label><br/>'; } ?> this is my form, how should i validate the radio buttons of it?

hey eveyone, i'm just curious whether i could use a dynamic sql query of AS statement. Can i do this? "COUNT (BLAHBLAH) AS "'.$sad.'" FROM reeedddd; Can i make the AS statement be dynamic instead of being static ? just curious. haha

hey thanks for the codes, but how do i make it dynamic? because the answers set are different in my case. cos i'm doing a survey. For example. Strongly agree disagree satistified unsatisfied not applicable. These are the different type of answers set for some of my question, so how do i change the code in such way that it is dynamic when appearing as the different option on the y-axis of the graph ?

if (isset($_POST['Submit'])) { $question = $_POST['question']; $SQL = "SELECT student_id, question_id, COUNT(answer) from responses WHERE question_id='".$question."'"; $result = mysql_query($SQL)or die("ERROR: $query. ".mysql_error()); $total = 0; while($row = mysql_fetch_assoc($result)){ //echo "There are ". $row['COUNT(answer)'] ." for ".$row['question_id']." "; //echo "<br />"; $total = $row['COUNT(answer)']; } echo "There are ".$total." of students taking question ".$question.".<br/>"; unset($SQL); unset($result); unset($row); unset($total); $SQL = "SELECT question_id, answer, COUNT(student_id) AS TOTAL FROM responses WHERE question_id = '".$question."' GROUP BY answer"; $result = mysql_query($SQL) or die("ERROR: $query. ".mysql_error()); $total = 0; while($row = mysql_fetch_assoc($result)){ $total = $row['TOTAL']; echo "There are ".$total." answered ".$row['answer']." in question ".$question.".<br/>"; } } ?> <html> <form action="test.php" method="POST"> <tr> <td> <?php $sql_result=mysql_query("select question_id, question from stu_satisfaction_tblquestions order by question_id asc"); echo "<select name='question'>"; echo "<option size =30 selected>Select</option>"; if(mysql_num_rows($sql_result)) { while($row = mysql_fetch_assoc($sql_result)) { echo "<option value=$row[question_id]>$row[question]</option>"; } } else { echo "<option>No Names Present</option>"; } ?> </td> </tr> <tr> <td><input type="submit" name="Submit" value="Select" /> </tr> </form> </html> currently, i created a dropdown box to view each question specifically. Now i can get to view the total number of students that did the survey and how many student chose the different options in each question. So how i'm going to generate a graph from here.

Hello people, currently i ran into some problem. Currently, i have a database called responses which have the fields of ID, Student_id, question_id, Answer. I had stored my results into the database which appeared to be 1 1 1 Agree 2 1 2 Disagree 3 3 4 Unsatisfied. So any recommendation on how should i do about in generating the result into a graph whereby the graph will show how many students choose "AGree" on that particular question THANKS

echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$A.'" value="'.$A.'" /><label for="'.$data['question_id'].'_'.$A.'">'.$A.'</label><br/>'; so nothing to do with this ? i suppose? just the query right ?

<?php include 'config.php'; $SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id "; $result = mysql_query($SQL); while($db_field = mysql_fetch_assoc($result)){ $A = $db_field['answer1']; $answerB = 'unchecked'; $answerC = 'unchecked'; $answerD = 'unchecked'; $answerE = 'unchecked'; } ?> <html> <head> <script type="text/javascript"> function show_alert() { alert("Please Click OK to proceed!"); } </script> </head> <form action="Process1.php" method="POST"> <table> <tr> <?php $SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id "; $result = mysql_query($SQL); while ($data = mysql_fetch_array($result)) { echo $data['question'].'<br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$A.'" value="'.$A.'" /><label for="'.$data['question_id'].'_'.$A.'">'.$A.'</label><br/>'; //echo '<input type="radio" name="answers['.$data['question_id'].']" value="A"<br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="B" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="C" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="D" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="E" /><br/>'; } ?> <td> </tr> </td> <tr> <td> Please add any comments you may have:</br> <textarea rows="3" cols="60" name="comments" id="comments"> </textarea> </td> </tr> </table> <input type="submit" onclick="show_alert()" value="Submit" /> </form> </html> I managed to print out the 1st option, but it didnt tally with my database for the question and the set of answers, how do i go about doiing it ?

anyone?

echo '<input type="radio" name="answers['.$data['question_id'].']" value='<?php print $A;?><?PHP echo $answerA; ?>><?PHP echo $A; ?>>'<br/>'; anyone tell me what is syntax error in this line of code? Parse error: syntax error, unexpected '?'

those are stored in table called answer_type answers_id answer1 answer2 answer3 answer4 answer5 1 Strongly Agree Agree Dont Know Disagree Strongly Disagree

it didnt work, nothing came out. but for $answerA, the word "unchecked" appeared. <?php include 'config.php'; $qID = ''; $question = 'Question not set'; //$answerA = 'unchecked'; $answerB = 'unchecked'; $answerC = 'unchecked'; $answerD = 'unchecked'; $answerE = 'unchecked'; ?> <html> <head> <script type="text/javascript"> function show_alert() { alert("Please Click OK to proceed!"); } </script> </head> <form action="Process1.php" method="POST"> <table> <tr> <?php $SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id "; $result = mysql_query($SQL); while ($data = mysql_fetch_array($result)) { $answerA = $db_field['answer1']; $B = $db_field['answer2']; $C = $db_field['answer3']; $D = $db_field['answer4']; $E = $db_field['answer5']; echo $data['question'].'<br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" id="'.$data['question_id'].'_'.$answerA.'" value="'.$answerA.'" /><label for="'.$data['question_id'].'_'.$answerA.'">'.$answerA.'</label><br/>'; //echo '<input type="radio" name="answers['.$data['question_id'].']" value="A" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="B" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="C" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="D" /><br/>'; echo '<input type="radio" name="answers['.$data['question_id'].']" value="E" /><br/>'; } ?>

ok thanks, if i wanna print out the options for each questions how do i do that? cos currently i have the radio button but didnt display the options or the answers. It is because there are different sets of answers such as - (Satisfied, not satifsied) or (agree,disagree) should i change it to echo '<input type="radio" name="answers['.$data['question_id'].']" value="<?php print $A" /><br/>'; ?

as for the post handler codes. Can i do this to update my database the results? foreach ($_POST['answers'] as $qID=>$answer) { echo 'The person answered '.$answer.' for qID '.$qID.'<br/>'; $SQL = "UPDATE answers SET $answers = $answers + 1 WHERE question_id='$qID'"; $result = mysql_query($SQL); mysql_close(); print "Thanks for voting!"; } my fields in my database is current id,question_id, A, B, C, D, E

oopps, i found the error

Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\studsurvey.php on line 36 $SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id "; $result = mysql_query($SQL); while ($data = mysql_fetch_array($Sresult)) {

hey, thanks for the codes. but i ran into some syntax errors Parse error: syntax error, unexpected ']', expecting ',' or ';' in C:\xampp\htdocs\studsurvey.php on line 39 echo '<input type="radio" name="answers['.$data['question_id']].'" value="A" />';

$qID = ''; $question = 'Question not set'; $answerA = 'unchecked'; $answerB = 'unchecked'; $answerC = 'unchecked'; $answerD = 'unchecked'; $answerE = 'unchecked'; ?> <html> <head> <script type="text/javascript"> function show_alert() { alert("Please Click OK to proceed!"); } </script> </head> <form action="Process1.php" method="POST"> <table> <tr> <td> <?php $SQL = "SELECT stu_satisfaction_tblquestions.question_id, stu_satisfaction_tblquestions.question, answer_type.answer1, answer_type.answer2, answer_type.answer3, answer_type.answer4, answer_type.answer5 FROM stu_satisfaction_tblquestions INNER JOIN answer_type ON stu_satisfaction_tblquestions.answers_id=answer_type.answers_id "; $result = mysql_query($SQL); while($db_field = mysql_fetch_assoc($result)){ $qID = $db_field['question_id']; $question = $db_field['question']; $A = $db_field['answer1']; $B = $db_field['answer2']; $C = $db_field['answer3']; $D = $db_field['answer4']; $E = $db_field['answer5']; print $question; ?> </td> </tr> <tr> <td> <INPUT TYPE = 'Radio' Name ='q' value= 'A' <?PHP echo $answerA; ?>><?PHP echo $A; ?> <INPUT TYPE = "Hidden" Name = "h" VALUE = <?PHP print $qID; ?>> <?php echo $qID;?> </td> </tr> <tr> <td> <INPUT TYPE = 'Radio' Name ='q' value= 'B' <?PHP echo $answerB; ?>><?PHP echo $B; ?> <?php echo $qID;?> </tr> </td> <tr> <td> <INPUT TYPE = 'Radio' Name ='q' value= 'C' <?PHP echo $answerC; ?>><?PHP echo $C; ?> </tr> </td> <tr> <td> <INPUT TYPE = 'Radio' Name ='q' value= 'D' <?PHP echo $answerD; ?>><?PHP echo $D; ?> </tr> </td> <tr> <td> <INPUT TYPE = 'Radio' Name ='q' value= 'E' <?PHP echo $answerE; ?>><?PHP echo $E; ?> <br> <?php } mysql_close(); ?> </tr> </td> <tr> <td> Please add any comments you may have:</br> <textarea rows="3" cols="60" name="comments" id="comments"> </textarea> </td> </tr> </table> <input type="submit" onclick="show_alert()" value="Submit" /> </form> </html> I ran to some problems here. After filling every question up with the answers. When i process the form, i only managed to get QID of 20 and the answer of 1st question as my database have only 20questions. How do i go about in solving, so that i'm able to retrieve all result and update my database correctly $selected_radio = $_POST['q']; $qID = $_POST['h']; echo $selected_radio; echo $qID; $SQL = "UPDATE answers SET $selected_radio = $selected_radio + 1 WHERE question_id='$qID'"; $result = mysql_query($SQL); mysql_close(); print "Thanks for voting!"; ?> THis is my process page, and i echo out the answer to be B and qid as 20.