pageHeading('TEST RESULTS'); $db = new DBMain(); $test_id = 1; //show the test results $test_res = $db->exec_query('tests', ['*'], '', '', '', '', "record_id = $test_id"); $tests = $test_res->fetch_assoc(); // echo "
Test id: " . $test_id; // echo "
Test name: " . $_POST['test_name']; // echo "
description: " . $_POST['test_description']; // echo "
nqf: " . $_POST['nqf_level']; // echo "
credits: " . $_POST['credits']; // echo "
Passmark: " . $_POST['passmark']; // echo "
sections total: " . $section_total = $_POST['sections_total'] . "

"; // echo "
question total: " . $section_total . "

"; $sections_res = $db->exec_query('test_sections', ['*'], '', '', '', '', "test_id = $test_id", "ORDER BY record_id ASC"); $index = 0; $marks = 0; $total_possible_answers = 0; $total_correct_answers = 0; // fetch sections fetch loop questions fetch loop answers while ($section = $sections_res->fetch_assoc()) { "
Section: " . $section['section_name'] . "
"; $question_res = $db->exec_query('test_questions', ['*'], '', '', '', '', "test_section_id = {$section['record_id']}", "ORDER BY record_id ASC"); $q_index = 0; while ($question = $question_res->fetch_assoc()) { "
Question: " . $question['question'] . "
"; $answer_res = $db->exec_query('test_answers', ['*'], '', '', '', '', "test_question_id = {$section['record_id']}", "ORDER BY record_id ASC"); $a_index = 0; $total_possible_answers += $answer_res->num_rows; while ($answer = $answer_res->fetch_assoc()) { "
total answers for question:" . $answer_res->num_rows; "
Answer: " . $answer['answer']; "
Answer value: " . $answer['option']; "
Current value: " . $_POST[$index . "_change_value_$a_index"] . "
"; if ($answer['option'] == 1) { $total_correct_answers++; } $current_a = $_POST[$index . "_change_value_$a_index"]; if (($answer['option'] == 1) && ($current_a == 1)) { "
Correct"; $marks++; } else { "
Incorrect"; } $a_index++; } $q_index++; } $index++; } "
Total answers: " . $total_possible_answers . "
"; "
Total correct answers: " . $total_correct_answers . "
"; $count = 0; "
Num_correct_a: " . $count . "
"; $test_score = ($marks / $total_correct_answers) * 100; $new_test_score = round($test_score, 0); "
Score: " . $test_score . "
"; ?>
' />
' />
' /> ' />




pageHeading('TEST QUESTIONS'); ?>
exec_query('test_sections', ['*'], '', '', '', '', "test_id = $test_id", "ORDER BY record_id ASC"); while ($section = $sections_res2->fetch_assoc()) { $question_res = $db->exec_query('test_questions', ['*'], '', '', '', '', "test_section_id = {$section['record_id']}", "ORDER BY record_id ASC"); $answer_res = $db->exec_query('test_answers', ['*'], '', '', '', '', "test_question_id = {$section['record_id']}", "ORDER BY record_id ASC"); // if the answer in correct change the background color if (($answer['option'] == 1) && ($current_a == 1)) { echo "
"; ?> ' style="width: 60%;"> ' style="width: 60%;" hidden> fetch_assoc()) { ?> fetch_assoc()) { ?>
QUESTION
ANSWER
"; ?> ' style="width: 60%;"> ' style="width: 60%;" hidden> fetch_assoc()) { ?> fetch_assoc()) { ?>
QUESTION
ANSWER