I am making quiz in php and have some problem. so i want to retrieve questions, answers and answer points from the database. for example i have 10 questions, when user marks all questions i want to count the points of marked radio buttons. I want do it dynamicaly depending on database values. i do not want to retrieve values of 10 radio buttons staticaly and sum it.
<div class="test-data">
<form method="POST" action="index.php">
<?php foreach($test_data as $id_question => $item): ?>
<div class="question" data-id="<?=$id_question?>" id="question-<?=$id_question?>">
<?php foreach($item as $point => $answer): ?>
<?php if(!$point): ?>
<p class="q"><?=$answer?></p>
<?php else: ?>
<p class="a">
<input type="radio" id="answer-<?=$id_answer?>" name="question-<?=$id_question?>" value="<?=$point?>" /><?=$answer?>
</p>
<?php endif; ?>
<?php endforeach; ?>
</div>
<?php endforeach; ?>
<input type="submit" name="finish_test" id="finish_test" value="Finish" />
</form>
</div>
<?php endif; ?>
this is my function which retrieves questions, answers and points
function get_test_data(){
$query = "SELECT q.question, q.quizz_id, a.id, a.answer, a.question_id, a.point
FROM questions q
LEFT JOIN answers a
ON q.id = a.question_id";
$res = mysql_query($query);
$data = null;
while($row = mysql_fetch_assoc($res)){
if(!$row['question_id']) return false;
$data[$row['question_id']]['0'] = $row['question'];
$data[$row['question_id']][$row['point']] = $row['answer'];
}
return $data;
}
