";
echo "";
//หัวข้อตาราง
echo "| เลขที่ | รหัส | ชื่อ | นามสกุล | ชั้น | มา | ลา | ป่วย | ขาด | รวม | มา(%) | ";
while($row = mysqli_fetch_array($result)) {
echo "";
echo "| " .$row["student_number"] . " | ";
echo "" .$row["student_id"] . " | ";
echo "" .$row["prename"] ."" .$row["name"] . " | ";
echo "" .$row["surname"] . " | ";
$cc=$row["class_now"];
$cc=$cc-9;
echo "ม." .$cc."/".$row["room"] ." | ";
$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 student_id='$row[student_id]' AND student_check_year=$curr_YEAR AND MONTH(check_date) = $std_month AND DAYNAME(check_date) = 'Thursday' ";
$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]];
//echo $sumC;
}
$sumAll+=$sumcheck[$a_val[$i]];
echo "".$sumcheck[$a_val[$i]]." | ";
}
$percent=$sumC*100/$sumAll;
echo"$sumAll | ";
printf("%.2f | ",$percent);
echo " ";
echo "";
}
echo "
|
";
//==เลือกที่ปรึกษา
//$year_active = $result['year_active'];
$pms_list="";
//$edu_type=$result['class_now'];
//$person_id=$_SESSION[person_id];
$sql_pms="SELECT * FROM `student_check_permission` WHERE `class_now` = $std_class AND `room_now` = $std_room ";
$pmsquery = mysqli_query($con, $sql_pms);
echo "![](\"school2.png\")