require('config.php');
$url=getUrl();
$id=$_GET["id"];
$string="select * from Sch_Score where id='".$id."'";
$result=$conn->query($string);
$array=$conn->fetch_array($result);
$ans_id=$array["ans_id"];
$bh=$array["bh"];
$score=$array["score"];
$sdate=$array["sdate"];
$stime=$array["stime"];
$etime=$array["etime"];
$arr=explode(",",$array["ans"]);
$brr=explode("-", $bh);
$nianji="Year ".$brr[1];
$string1="select kemu,zhishi from Sch_Knowledge where id=".$brr[3];
$query1=$conn->query($string1);
$result1=$conn->fetch_array($query1);
$kemu=$result1["kemu"];
$zhishi=$result1["zhishi"];
$nandu="ΔΡΆΘ".$brr[4];
$bh=substr($bh,0,strlen($bh)-1);
$string="select * from Sch_Exam where bh like '%".$bh."%' and id in (".$ans_id.") order by id";
?>
SmartBees
| |
score: |
% |
Date:
|
Time
start:
|
Time
finish:
|
|
$query=$conn->query($string);
$i=0;
while ($result=$conn->fetch_array($query))
{
$srr=explode("|",$arr[$i]);
$i=$i+1;
$mstr="";
$zsid=$result["id"];
$pic=$result["q_pic"];
$title=nl2br($result["q_title"]);
$mark=$result["q_mark"];
$a_ansA=$result["a_ans1"];
$a_ansB=$result["a_ans2"];
$a_ansC=$result["a_ans3"];
$a_ansD=$result["a_ans4"];
$a_ans=$result["a_ans"];
$a_score=floor($srr[0])/100;
if ($mark!=""){
$mstr=" ";
}
?>
| |
|
|
. |
|
|
|
$a_str=$srr[1];
if ($a_str!=""){
eval('$a_str2 = $a_ans'.$a_str.';');
echo "| 1st Trial: (".$a_str.") ".$a_str2." | ";
}
$a_str=$srr[2];
if ($a_str!=""){
eval('$a_str2 = $a_ans'.$a_str.';');
echo "| 2nd Trial: (".$a_str.") ".$a_str2." | ";
}
$a_str=$srr[3];
if ($a_str!=""){
eval('$a_str2 = $a_ans'.$a_str.';');
echo "| 3rd Trial: (".$a_str.") ".$a_str2." | ";
}
$a_str=$srr[4];
if ($a_str!=""){
eval('$a_str2 = $a_ans'.$a_str.';');
echo "| 4th Trial: (".$a_str.") ".$a_str2." | ";
}
eval('$a_str2 = $a_ans'.$a_ans.';');
echo "Correct Answer: (".$a_ans.") ".$a_str2." Score: ".$a_score." | ";
echo "
| ";
}
?>
|