Hey guys,
I'm making php quiz, but got some problems with results getting - they are all wrong. Here is the db table for it.
CREATE TABLE IF NOT EXISTS `quiz` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`question` text COLLATE utf8_unicode_ci NOT NULL,
`answer1` text COLLATE utf8_unicode_ci NOT NULL,
`answer2` text COLLATE utf8_unicode_ci NOT NULL,
`answer3` text COLLATE utf8_unicode_ci NOT NULL,
`correctanswer` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `pollid` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 ;
And script itself.
$questionNumber = 1;
$query = sql_query("SELECT * FROM quiz ORDER BY RAND() LIMIT $limit");
while ($result = mysqli_fetch_array($query)) { ?>
<div class="padding">
<p>
<?php echo "<b><h4>" . $questionNumber . ") " . $result['question'] . "</h4><br></b>"; ?>
<input type="radio" name="answer[<?php echo $result['id'] ?>]" value=""> <?php echo $result['answer1']; ?> <br>
<input type="radio" name="answer[<?php echo $result['id'] ?>]" value=""> <?php echo $result['answer2']; ?> <br>
<input type="radio" name="answer[<?php echo $result['id'] ?>]" value=""> <?php echo $result['answer3']; ?> <br>
</p>
<hr>
</div>
<?php
$questionNumber +=1;
}
$correctAnswers = 0;
$wrongAnswers = 0;
$questions = '';
$idList = join (',', array_map('intval', array_keys($_POST['answer'])));
$sql = "SELECT id, question, answer1, answer2, answer3, correctanswer FROM quiz WHERE id IN ($idList)";
$res = sql_query($sql) ;
$qno = 1;
while (list($id, $q, $a, $b, $c, $correct) = mysqli_fetch_row($res)) {
if ($correct == $_POST['answer'][$id]) {
$correctAnswers +=1;
}
else {
$wrongAnswers +=1;
}
}
echo $correctAnswer;
echo $wrongAnswers;
?>
Help me guys!
