include 'connect.php';
$id = $_POST['quiznum'];
$sql = mysql_query("select quizname from currentquizzes where id = '$id'");
$row = mysql_fetch_row($sql);
$name = $row[0];
$answerstable = $name."_answers";
$numright = 0;
$newsql = mysql_query("select * from $answerstable");
$row = mysql_fetch_row($newsql);
$numberanswers = mysql_num_fields($newsql);
$numoutof = $numberanswers - 1;
$sql = "select id from Quiz_users where username = '$username'";
$result = mysql_query($sql);
$newrow = mysql_fetch_row($result);
$studid = $newrow[0];
for($i = 1; $i < $numberanswers;$i++)
{
$answer = "answer".$i;
$answered = $_POST["$answer"];
if ($answered == $row[$i])
{
$numright += 1;
}
else
{
$finalsql = "insert into Quiz_results (quizid,studentid,questionwrong,answergiven)
VALUES ('$id','$studid','$i','$answered')";
$finalresults = mysql_query($finalsql);
}
}
echo "Your final score is $numright out of $numoutof";
$quizid = $id;
$score = $numright/$numoutof;
$score = $score * 100;
$sql = "insert into Quiz_scores (studentid,quizid,score) values ('$studid','$quizid','$score')";
$result = mysql_query($sql);
?>
Return to the student page
