query($string); $array=$conn->fetch_array($result); $bh=$array["bh"]; $ans_id=$array["ans_id"]; $score=$array["score"]; $sdate=$array["sdate"]; $stime=$array["stime"]; $etime=$array["etime"]; $name=$array["cname"]; $xuexiao=$array["xuexiao"]; $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]; $shiti=$brr[1]."Äê¼¶ ".$kemu.""; if (floor($score)<50){ $color1="#ff0000"; }else{ $color1="#009900"; } $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
  Teacher Name : School Name :  
  score: % Date: Time start: Time finish:
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[2]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); echo ""; } $a_str=$srr[3]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); echo ""; } $a_str=$srr[4]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); echo ""; } eval('$a_str2 = $a_ans'.$a_ans.';'); echo ""; echo ""; } ?>
 
.
1st trial:(".$a_str.") ".$a_str2."
2nd trial:(".$a_str.") ".$a_str2."
3rd trial:(".$a_str.") ".$a_str2."
4th trial:(".$a_str.") ".$a_str2."
Correct answer:(".$a_ans.") ".$a_str2."
Score: ".$a_score."