So I'm working on a computer based test(CBT) web app, on a php platform, I'v gon a lil far in it, upto d point of rendering d questions(randomly) 2d user, my problem nw is how do I mark d test and give d user his/her score? Just a pseudo, thanks in anticipation.

Benny95: So I'm working on a computer based test(CBT) web app, on a php platform, I'v gon a lil far in it, upto d point of rendering d questions(randomly) 2d user, my problem nw is how do I mark d test and give d user his/her score? Just a pseudo, thanks in anticipation.

Shouldn't you have a database of the questions and the answers such that it juxtaposes the user's answer to the correct and answer and assign a score and at the end, it does a calculation to arrive at the final score.

Afam4eva:
Shouldn't you have a database of the questions and the answers such that it juxtaposes the user's answer to the correct and answer and assign a score and at the end, it does a calculation to arrive at the final score.

Yeah I do, I'm using mongoDB as d database, I can also use mysql tho, I'm just looking 4 a way 2 loop through all d user-supplied answers and compare to the answers in my DB........fanks

Benny95:

Yeah I do, I'm using mongoDB as d database, I can also use mysql tho, I'm just looking 4 a way 2 loop through all d user-supplied answers and compare to the answers in my DB........fanks

<?php
$pos = 0;
$db = new mysqli('server', 'username', 'password', 'dbName');
if($db->connect_errno > 0) {
die('Unable to connect to database'.$db->connect_error);
}
$stmt = $db->prepare("SELECT `id`, `answer` FROM `question` LIMIT ?, 10";
$stmt->bind_param('i', $pos);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($id, $answer);
while($stmt->fetch()) {
$answers[$id] = $answer;
}
$db->close();
$score = 0;
foreach($_POST as $key => $value) {
if($value == $answers[$key]) {
$score += 1;
}
}
?>

please edit the query and other mysqli_ ish stuff. The code above expect your html input tag names to be the id of the question from the db.

elvis10ten:


<?php
$pos = 0;
$db = new mysqli('server', 'username', 'password', 'dbName');
if($db->connect_errno > 0) {
die('Unable to connect to database'.$db->connect_error);
}
$stmt = $db->prepare("SELECT `id`, `answer` FROM `question` LIMIT ?, 10";
$stmt->bind_param('i', $pos);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($id, $answer);
while($stmt->fetch()) {
$answers[$id] = $answer;
}
$db->close();
$score = 0;
foreach($_POST as $key => $value) {
if($value == $answers[$key]) {
$score += 1;
}
}
?>

please edit the query and other mysqli_ ish stuff. The code above expect your html input tag names to be the id of the question from the db.

Thanks!

Benny95: Thanks!

ur welcome.