require('teacher_config.php'); $url=getUrl(); $id=$_GET["k"]; //$string="select * from Sch_Teacher_Score where id='".$id."'"; $string="select Sch_Teacher_Score.bh,Sch_Teacher_Score.ans_id,Sch_Teacher_Score.score,Sch_Teacher_Score.sdate,Sch_Teacher_Score.stime,Sch_Teacher_Score.etime,Sch_Teacher_Score.ans,Sch_Teacher.cname,Sch_Teacher.xuexiao from Sch_Teacher_Score inner join Sch_Teacher on Sch_Teacher_Score.uid=Sch_Teacher.id where Sch_Teacher_Score.id='".$id."'"; $result=$conn->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"; ?>