";
echo "";
//หัวข้อตาราง
echo "| ระดับชั้น/ห้อง |
มา | ลา | ป่วย | ขาด | รวม | มา(%) | ";
$s1=0;
$s2=0;
$s3=0;
$s4=0;
$s5=0;
while($row = mysqli_fetch_array($result)) {
$classText=$row["text_view"];
$classLevel=$row["class_group"];
$classLevel=$classLevel+9;
$classRoom=$row["room"];
echo "";
echo "| ห้อง $classText | ";
$YY=$curr_YEAR-543;
$a_val=array("0" => "C", "1" => "W", "2" => "S", "3" => "L");
$a_val_txt=array("0" => "มา", "1" => "ลา", "2" => "ป่วย", "3" => "ขาด");
//$sql_val="Select * from student_check_main Where MONTH(check_date) = $std_month AND student_id='$row[student_id]' AND student_check_year='2561' ";
//Select * from student_inclass_main Where student_id='5719' AND student_check_year='2561' AND MONTH(check_date) = 5
$sql_val="Select * from student_inclass_main Where class_now='$classLevel' AND room_now='$classRoom' AND YEAR(check_date)=$YY AND MONTH(check_date) = $std_month ";
$result2 = mysqli_query($con, $sql_val);
$M=1;
$N=1;
for($i=0;$i".$$a_val[$i]."";
if($i==0) {
$sumC=$sumcheck[$a_val[$i]];
$s1=$s1+$sumcheck[$a_val[0]];
//echo $sumC;
}
if($i==1) $s2=$s2+$sumcheck[$a_val[1]];
if($i==2) $s3=$s3+$sumcheck[$a_val[2]];
if($i==3) $s4=$s4+$sumcheck[$a_val[3]];
//if($i==4) $s5=$s5+$sumcheck[$a_val[4]];
$sumAll+=$sumcheck[$a_val[$i]];
echo "".$sumcheck[$a_val[$i]]." | ";
}
$s5+=$sumAll;
$percent=$sumC*100/$sumAll;
echo"$sumAll | ";
printf("%.2f | ",$percent);
echo " ";
$i++;
}
$percent=$s1*100/$s5;
echo "| รวม | $s1 | $s2 | $s3 | $s4 | $s5 | ";
printf("%.2f | ",$percent);
echo "
<--- |
";
//5. close connection
mysqli_close($con);
?>![](\"school2.png\")