melo Posted March 15, 2013 Share Posted March 15, 2013 I don't know what exactly the codes to be used in order to get the score of my quiz. Could someone help me on how will I be able to get its score and put it in a table. I am new to php/programming so I dont know much about it and still getting confuse. I already post this topic but I still can't get the answer. thanks <?php if (isset($_GET['id'])) { $quiz_id = $_GET['id']; $takeq = 'SELECT * FROM tblquiz WHERE QuizId="'.$quiz_id.'"'; $takeg = mysql_query($takeq); $take = mysql_fetch_assoc($takeg); ?> <form method="post" action="index.php?id=<?php $quiz_id ?>#form"> <table cellpadding="3" cellspacing="2" width="50%" bordercolor="#999999" style="margin-top:20px;" align="center"> <tr> <th style="font-size:25px; background:#999;" colspan="8">Quiz (<?php echo $take['QuizTitle']; ?>)</th> </tr> <tr> <td width="100px" align="left" style="border:none;">Name : <?php echo $_SESSION['logged']['FirstName'].' '.$_SESSION['logged']['LastName']; ?></td> </tr> <tr> <td width="100px" align="left" style="border:none;">Program/Section : <?php echo $_SESSION['logged']['SectionCode']; ?></td> </tr> <tr> <td width="100px" align="left" style="border:none;">Quiz Item : <?php echo $take['Items']?> <hr /></td> </tr> <?php $quesq = "SELECT * FROM tblquestion_main WHERE QuizId = '".$quiz_id."'"; $quesg = mysql_query($quesq); if($ques = mysql_fetch_array($quesg)) { while($ques = mysql_fetch_array($quesg)){ $strQuery = "SELECT * FROM tblquestion_mc WHERE QuestionId = '{$ques['QuestionId']}'"; $hQuery = mysql_query($strQuery); $arMChoices = mysql_fetch_array($hQuery); switch($ques['QuestionType']) { case 1: ?> <table border="1" cellpadding="2" cellspacing="2" width="500px" bordercolor="#999999" style="margin-top:20px;" align="center"> <tr> <td width="100px" align="left" style="border:none;"> <b> Multiple Choice <br /> <pre> Direction: </b> Choose the letter of the correct answer. </td> </tr> <tr> <td width="100px" align="left" style="border:none;"> Question : <?php echo $ques['Question']; ?></td> </tr> <tr> <td width="100px" align="left" style="border:none;"> A. <?php echo $arMChoices['choice_a']; ?></td> </tr> <tr> <td width="100px" align="left" style="border:none;"> B. <?php echo $arMChoices['choice_b']; ?></td> </tr> <tr> <td width="100px" align="left" style="border:none;"> C. <?php echo $arMChoices['choice_c']; ?></td> </tr> <tr> <td width="100px" align="left" style="border:none;"> D. <?php echo $arMChoices['choice_d']; ?></td> </tr> <tr> <td align="left" style="border:none;"> Answer: <select name="answer"> <option>--Select Choices--</option> <option name ="answer <?php echo $ques['QuestionId']?>" value="A">A</option> <option name ="answer <?php echo $ques['QuestionId']?>" value="B">B</option> <option name ="answer <?php echo $ques['QuestionId']?>" value="C">C</option> <option name ="answer <?php echo $ques['QuestionId']?>" value="D">D</option> </select> </td> </tr> <?php break; case 2: ?> <tr> <td width="200px" align="left" style="border:none;"> <b> Identification <br /> <pre> Direction: </b> Write the correct answer. </td> </tr> <tr><td width="100px" align="left" style="border:none;">Question : <?php echo $ques['Question']; ?> </td></tr> <tr><td width="100px" align="left" style="border:none;">Answer : <input type="text" name="answer <?php echo $ques['QuestionId']?>" style="width:210px; margin:0px;"/></td> </tr> </td></tr> </form> <?php break; case 3: ?> <tr> <td width="100px" align="left" style="border:none;"> <b> True or False <br /> Direction: </b> Write TRUE if the statement is correct otherwise write FALSE. </td> </tr> <tr><td width="100px" align="left" style="border:none;">Question : <?php echo $ques['Question']; ?> </td></tr> <tr><td align="left" style="border:none;">Answer : <select name="answer"> <option>--Select Choices--</option> <option name ="answer <?php echo $ques['QuestionId']?>" value="True" >True</option> <option name ="answer <?php echo $ques['QuestionId']?>" value="False">False</option></select></td> </tr> </form> <?php } } } ?> <tr> <td align="center" style="border:none;" colspan="2"><a href="index.php"><input type="submit" name="quizcheckSubmit" value="submit" onclick="return confirm('Are you sure you want to end the quiz?')" style="width:150px; height:30px;"/></a></td> </tr> </table> <?php } ?> Link to comment https://forums.phpfreaks.com/topic/275706-help-pls-getting-the-score/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.