📄 test.php
字号:
<html>
<head>
<title>Question</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?PHP
$sqlhostname = "127.0.0.1";
$login = "nellainet";
$password = "1234";
$base = "online";
/* for testing getting below variables from form.php
$sessionid="ccc";
$questionpaperid=100;
$date=date("dmY");
$studentid=1;
*/
$questionnumber="q".$qid;
$aid=$qid-1;
$answernumber="a".$aid;
//$qid="1";
$db_connect = mysql_connect($sqlhostname,$login,$password);
$base_selection = mysql_select_db($base,$db_connect);
if ($questionnumber!="q20"){
$query1 = "SELECT ".$questionnumber." FROM questionpapers where questionpaperid ='$questionpaperid' AND type='question'";
$req1 = mysql_query($query1);
while($row = mysql_fetch_object ($req1)){
$questionid=$row->$questionnumber;
// echo "prev question answer given ".$answer;//$questionid.
}
mysql_free_result($req1);
}
if ($aid>=0){
$query2 = "UPDATE ans1 SET $answernumber = '$answer' where sessionid ='$sessionid'";
mysql_query($query2);
}
if ($questionnumber=="q20"){
echo "<H1>thank you for writing the exam</H1>";
echo"click here for your marks" ;
echo"<a href=\"markz2.php?sessionid=$sessionid&studentid=$studentid&questionpaperid=$questionpaperid\" target=\"_blank\">Marks </a>";
exit;
}
//modified 24-3-2002 insert answer into answers_table (later include session)
if ($questionnumber=="q0"){
$query2 = "insert into ans1 (questionpaperid,datetime,studentid,sessionid) values('$questionpaperid','$datetime','$studentid','$sessionid')";
mysql_query($query2);
}
$query = "SELECT * FROM questionbank where questionid ='$questionid'";
$req = mysql_query($query);
//$res = mysql_num_rows($req);
$qid++;
echo "<form name=\"form1\" method=\"post\" action=\"$phpself\">";
while($row = mysql_fetch_array($req))
{
$questionid=$row['questionid'];
$question=$row['question'];
$choice1=$row['choice1'];
$choice2=$row['choice2'];
$choice3=$row['choice3'];
$choice4=$row['choice4'];
echo "<table width=\"75%\" border=\"1\" cellspacing=\"1\" cellpadding=\"1\">\n";
echo "<tr><td colspan=8>".$questionid."<br>".$question."</td></tr>\n <input type=\"hidden\" name=\"qid\" value=\"$qid\">"; // <input type=\"hidden\" name=\"questionid\" value=\"$questionid\">
echo "<tr><td width=\"5%\"><input type=\"radio\" name=\"answer\" value=\"1\"></td><td width=\"20%\">".$choice1."</td><td width=\"5%\"><input type=\"radio\" name=\"answer\" value=\"2\"></td><td width=\"20%\">".$choice2."</td><td width=\"5%\"><input type=\"radio\" name=\"answer\" value=\"3\"></td><td width=\"20%\">".$choice3."</td><td width=\"5%\"><input type=\"radio\" name=\"answer\" value=\"4\"></td><td width=\"20%\">".$choice4."</td><input type=\"hidden\" name=\"questionpaperid\" value=\"$questionpaperid\"><input type=\"hidden\" name=\"sessionid\" value=\"$sessionid\"></tr>\n";
echo "</table>\n";
echo "<br>\n";
echo"<input type=\"hidden\" name=\"sessionid\" value=\"$sessionid\"><input type=\"hidden\" name=\"studentid\" value=\"$studentid\"><input type=\"hidden\" name=\"questionpaperid\" value=\"$questionpaperid\">";
/*
//echo "<b>$questionid,$question,$choice1,$choice2,$choice4 </b> <br>\n";
//
//
// <input type="hidden" name="questionid" value="$questionid">
*/
}
mysql_free_result($req);
echo "<br><input type=\"submit\" name=\"Submit Answers\" value=\"Submit\"><input type=\"reset\" name=\"reset\" value=\"Reset\">";
echo "</form>";
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -