";
echo "";
$i=1;
//หัวข้อตาราง
echo "| ที่ | ระดับชั้น |
ทั้งหมด (ครั้ง) | เลยกำหนด 09.00 น.(ครั้ง) | เช็คตามกำหนด (ครั้ง) | %ที่เช็คไม่ทันตามกำหนด | %ที่เช็คทันตามกำหนด | ";
while($row = mysqli_fetch_array($result)) {
$class_now=$row["class_now"]-9;
$class_now1=$row["class_now"];
$room_now=$row["room_now"];
$sub_sql="SELECT * FROM student_check_main WHERE student_check_main.class_now = $class_now1 and student_check_year = $curr_YEAR AND student_check_main.room_now = $room_now ORDER BY student_check_main.student_id ASC";
$result3 = mysqli_query($con, $sub_sql);
$row3 = mysqli_fetch_array($result3);
$chk_id=$row3["student_id"];
//echo "$class_now1 / $room_now
";
$sub_sql_all="SELECT COUNT(student_id) as num FROM student_check_main WHERE student_check_main.class_now = $class_now1 AND student_check_main.room_now = $room_now and student_check_year = $curr_YEAR and student_id = $chk_id";
$resultall = mysqli_query($con, $sub_sql_all);
$rowall = mysqli_fetch_array($resultall);
$num_AL=$rowall["num"];
$sub_sql_1="SELECT COUNT(student_id) as num1 FROM student_check_main WHERE student_check_main.class_now = $class_now1 AND student_check_main.room_now=$room_now and student_check_year = $curr_YEAR and student_id = $chk_id and time(save_date) > \"09:00:00\" ";
$result2 = mysqli_query($con, $sub_sql_1);
$row2 = mysqli_fetch_array($result2);
$num_L=$row2["num1"];
$num_ok=$num_AL-$num_L;
$p1=$num_L*100/$num_AL;
$p2=100-$p1;
echo "";
echo "| $i | ";
echo "มัธยมศึกษาปีที่ $class_now/$room_now | ";
echo "$num_AL | ";
echo "$num_L | ";
echo "$num_ok | ";
printf("%.2f | ",$p1);
printf("%.2f | ",$p2);
echo " ";
$i++;
}
echo "
|
";
echo "";
echo "![](\"school2.png\")