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"]; $email=$array["email"]; $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"; $mess=""; $mess.="SmartBees"; $mess.=""; $mess.=""; $mess.=""; $mess.=""; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.="
"; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.="
"; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.="
 本次得分:".$score."%日期:".$sdate." 开始时间:".$stime." 答题耗时:".$etime."
"; $mess.="
"; $mess.=" "; $mess.=" "; $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=""; } $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $mess.=" "; $a_str=$srr[1]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); $mess.=""; } $a_str=$srr[2]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); $mess.=""; } $a_str=$srr[3]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); $mess.=""; } $a_str=$srr[4]; if ($a_str!=""){ eval('$a_str2 = $a_ans'.$a_str.';'); $mess.=""; } eval('$a_str2 = $a_ans'.$a_ans.';'); $mess.=""; $mess.=""; } $mess.=" "; $mess.="
 ".$pic."
".$i.".".$title."
"; $mess.="
".$mstr."
1st Attempt : (".$a_str.") ".$a_str2."
2st Attempt : (".$a_str.") ".$a_str2."
3st Attempt : (".$a_str.") ".$a_str2."
4st Attempt : (".$a_str.") ".$a_str2."
Correct Answer: (".$a_ans.") ".$a_str2."
Score: ".$a_score."

"; $mess.="
"; $mess.=""; $mess.=""; $mess.=""; echo $mess; $serverIP="http://".$_SERVER["HTTP_HOST"]."/"; //$mess=str_replace("ExamPics/",$serverIP."ExamPics/",$mess); //$mess=str_replace("","",$mess); //$mess=str_replace("Back to Top",$serverIP."",$mess); require('mail_smtp.php'); $smtpserver = "mail.sjkc.com.my"; //SMTP邮件服务器 $smtpserverport =25; //SMTP端口号 $smtpusermail = "webmaster@sjkc.com.my"; //SMTP发送邮件地址 $smtpuser = "webmaster@sjkc.com.my"; $smtppass = "123456"; //SMTP邮件密码 $smtpemailto = $email; //目标邮件地址 $mailsubject = $name." (".$zs.")知识点答题报告(答题时间:".$sdate.")"; //邮件主题 $mailbody = $mess; //邮件内容 $mailtype = "HTML"; //邮件发送方式(HTML/TXT) $smtp = new smtp($smtpserver,$smtpserverport,true,$smtpuser,$smtppass); //这里面的一个true是表示使用身份验证,否则不使用身份验证. $smtp->debug = false; //是否显示发送的调试信息 $smtp->sendmail($smtpemailto, $smtpusermail, $mailsubject, $mailbody, $mailtype); ?>