📄 correct_answer_finder.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
include('config.inc');
//debug
$maxquestion=20;
//$questionpaperid=2;
$db_connect = mysql_connect($datahost,$datauser,$datapasswd);
$base_selection = mysql_select_db($base,$db_connect);
//emptying existing correctanswers from questionpapers
$query="delete from questionpapers where type='answer'";
@mysql_query($query);
//debug all questionpapers
$query5="SELECT questionpaperid from questionpapers where type='question'";
$req5 = mysql_query($query5);
while($rowd = mysql_fetch_object($req5)){
$questionpaperid=$rowd->questionpaperid;
//debug all questionpapers ends
$value="answer";
$query2 = "insert into questionpapers (questionpaperid,type) values('$questionpaperid','$value')";
@mysql_query($query2);
for ($qid = 0; $qid < $maxquestion; $qid++) {
//print $i;
$questionnumber="q".$qid;
//$qid="1";
$query1 = "SELECT ".$questionnumber." FROM questionpapers where questionpaperid ='".$questionpaperid."' AND type = 'question'";
$req1 = mysql_query($query1);
//$res1 = mysql_num_rows($req1);
while($row = mysql_fetch_object ($req1)){
$questionid=$row->$questionnumber;
// echo $questionid." ".$answer;
}
$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'];
$answer=$row['answer'];
echo "$qid <br>\n";
//$questionnumber="q".$qid;
$query2 = "UPDATE questionpapers SET $questionnumber = '$answer' where type ='answer' AND questionpaperid='$questionpaperid'";
mysql_query($query2);
}
}
echo "correct answers updated for questionpaper:$questionpaperid <br>\n";
//debug all questionpapers
}
mysql_free_result($req1);
mysql_free_result($req);
mysql_free_result($req5);
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -