";
//echo $otime."
";
//echo $start_date."
";
//echo $start_time."
";
//echo $end_time."
";
//$etime=$stime date("g:i:s a");
$ans=$_POST["ans"];
$score=$_POST["score"];
$scrr=split("/",$score);
$sc_score=floor($scrr[0]);
$sc_total=floor($scrr[1]);
$score=$sc_score/$sc_total;
$score=sprintf("%01.2f", $score);
$answers=$_POST["answers"];
$bh=$_POST["bh"];
$ans_id=$_POST["ans_id"];
$brr=explode("-", $bh);
$nianji=$brr[1];
$kemu=$brr[2];
//echo $ans."
";
//echo $score."
";
//echo $bh.":".$nianji.":".$kemu."
";
//-----本次练习的成绩保存--------------------------------------
$string="insert into Sch_Score(uid,bh,ans_id,ans,score,sdate,stime,etime) values ('".$uid."','".$bh."','".$ans_id."','".$ans."','".$score."','".$start_date."','".$start_time."','".$end_time."')";
$id=$conn->add($string);
//-----更新每个用户，每个年级，每个科目的成绩------------------
$kkk="score".$kemu;
$mmm="kemu".$kemu;
$ttt="time".$kemu;
$string="select score,answers,score_total,".$kkk." from Sch_Paihang where nianji='".$nianji."' and uid='".$uid."'";
$result=$conn->query($string);
$array=$conn->fetch_array($result);
if ($array){
//每一科
$one_rr=explode("/",$array[$kkk]);
$one_total=(float)$one_rr[0]+(float)$score;
$one_count=floor($one_rr[1])+1;
$one_score=$one_total/$one_count;
$one_score=sprintf("%01.2f", $one_score);
$one_answers=floor($one_rr[2])+floor($answers);
$one_total=sprintf("%01.2f", $one_total);
$one_str=$one_total."/".$one_count."/".$one_answers;
//总成绩
$total_rr=explode("/",$array["score_total"]);
$Tscore_total=0;
$total_str="";
for ($j=1;$j<=5;$j++){
if ($j==$kemu){
$Tscore_total=$Tscore_total+$one_score;
$total_str=$total_str."/".$one_score;
}else{
$Tscore_total=$Tscore_total+(float)$total_rr[$j];
$total_str=$total_str."/".$total_rr[$j];
}
}
$Tscore_count=5;
$Tscore=$Tscore_total/$Tscore_count;
$Tscore=sprintf("%01.2f", $Tscore);
$Tanswers=floor($answers)+floor($array["answers"]);
$pstr="update Sch_Paihang set score='".$Tscore."',answers='".$Tanswers."',score_total='".$total_str."',".$kkk."='".$one_str."',".$mmm."='".$one_score."',".$ttt."='".$one_count."' where nianji='".$nianji."' and uid='".$uid."'";
}else{
$one_str=$score."/1/".$answers;
$total_str="";
for ($j=1;$j<=5;$j++){
if ($j==$kemu){
$total_str=$total_str."/".$score;
}else{
$total_str=$total_str."/0";
}
}
$Tscore=$score/5;
$Tscore=sprintf("%01.2f", $Tscore);
$Tanswers=$answers;
$pstr="insert into Sch_Paihang(uid,nianji,score,answers,score_total,".$kkk.",".$mmm.",".$ttt.") values ('".$uid."','".$nianji."','".$Tscore."','".$Tanswers."','".$total_str."','".$one_str."','".$score."','1')";
}
echo $pstr;
$conn->query($pstr);
echo "";
exit;
}else{
echo "数据错误，请重新登陆！";
exit;
}
?>