markz2.php

一个基于PHP的在线考试系统

<?PHP
$sqlhostname = "127.0.0.1";
$login = "nellainet";
$password = "1234";
$base = "online";
//$testid=36;
$maxquestion=20;



$questions=1;
$marks=0;
//echo "test	$marks <br>\n";
$db_connect = mysql_connect($sqlhostname,$login,$password);
$base_selection = mysql_select_db($base,$db_connect);

for ($qid = 0; $qid < $maxquestion; $qid++) {

$questionnumber="q".$qid;
$answernumber="a".$qid;


//$query="select q.q1, a.q1 from questionpapers q, answersheets a where q.type = 'answer' AND a.testid='10'";
$query="select q.".$questionnumber.", a.".$answernumber." from questionpapers q, ans1 a where q.type = 'answer' AND a.sessionid='$sessionid' AND a.studentid='$studentid' AND a.questionpaperid='$questionpaperid' AND q.questionpaperid='$questionpaperid'";
$req = mysql_query($query);


while($row = mysql_fetch_array($req)){

$qq0=$row[$questionnumber];

$aq0=$row[$answernumber];

if($qq0==$aq0){
$marks++;

}
echo "qno:$questions correct answer $qq0 given answer $aq0 marks=$marks<br>\n";	
//echo "marks=$marks from $questions questions<br>\n";
}
//debug
$questions=$questions +1;
//echo "$qid - ";
}

echo "<br>\n  <b>total marks</b>=$marks from $maxquestion questions<br>\n";







mysql_free_result($req);

?>