header('Content-Type: text/html; charset=tis-620');
include('db_config.php');
$sql="select * from $_sch where level not in ('x','z') order by smis";
$result=mysql_query($sql);
echo <<
สรุปรูปแบบการเปิดภาคเรียนที่ 1/2564 โรงเรียนสังกัด สพป.ศก.1
[ กลับ ]
ที่ |
โรงเรียน |
อำเภอ |
รูปแบบการเปิดเรียน |
สาเหตุ/ความจำเป็น |
On-Site |
On-Air |
Online |
On-Demand |
On-Hand |
แบบผสม |
TH;
$rw=1; $n1=$n2=$n3=$n4=$n5=$n6=0;
while ($db=mysql_fetch_array($result)) {
$ev1=$ev2=$ev3=$ev4=$ev5=$ev6=0;
$sql1="select opt from $_sch where scode='$db[scode]' and opt='1' ";
$result1=mysql_query($sql1);
$ev1=mysql_num_rows($result1);
$sql2="select opt from $_sch where scode='$db[scode]' and opt='2' ";
$result2=mysql_query($sql2);
$ev2=mysql_num_rows($result2);
$sql3="select opt from $_sch where scode='$db[scode]' and opt='3' ";
$result3=mysql_query($sql3);
$ev3=mysql_num_rows($result3);
$sql4="select opt from $_sch where scode='$db[scode]' and opt='4' ";
$result4=mysql_query($sql4);
$ev4=mysql_num_rows($result4);
$sql5="select opt from $_sch where scode='$db[scode]' and opt='5' ";
$result5=mysql_query($sql5);
$ev5=mysql_num_rows($result5);
$sql6="select opt from $_sch where scode='$db[scode]' and opt='6' ";
$result6=mysql_query($sql6);
$ev6=mysql_num_rows($result6);
if (empty($ev1)) { $cv1='-'; } else { $cv1=$ev1; }
if (empty($ev2)) { $cv2='-'; } else { $cv2=$ev2; }
if (empty($ev3)) { $cv3='-'; } else { $cv3=$ev3; }
if (empty($ev4)) { $cv4='-'; } else { $cv4=$ev4; }
if (empty($ev5)) { $cv5='-'; } else { $cv5=$ev5; }
if (empty($ev6)) { $cv6='-'; } else { $cv6=$ev6; }
echo <<
$rw |
$db[smis] $db[sname]
| $db[sampur]
| $cv1 |
$cv2 |
$cv3 |
$cv4 |
$cv5 |
$cv6 |
$db[oprem] |
TB;
$rw++;
$t1+=$ev1;
$t2+=$ev2;
$t3+=$ev3;
$t4+=$ev4;
$t5+=$ev5;
$t6+=$ev6;
}
if ($t1==0) { $ct1='-'; } else { $ct1=$t1; }
if ($t2==0) { $ct2='-'; } else { $ct2=$t2; }
if ($t3==0) { $ct3='-'; } else { $ct3=$t3; }
if ($t4==0) { $ct4='-'; } else { $ct4=$t4; }
if ($t5==0) { $ct5='-'; } else { $ct5=$t5; }
if ($t6==0) { $ct6='-'; } else { $ct6=$t6; }
$p1=number_format(($t1*100)/258,2);
$p2=number_format(($t2*100)/258,2);
$p3=number_format(($t3*100)/258,2);
$p4=number_format(($t4*100)/258,2);
$p5=number_format(($t5*100)/258,2);
$p6=number_format(($t6*100)/258,2);
echo <<
รวม |
$ct1 |
$ct2 |
$ct3 |
$ct4 |
$ct5 |
$ct6 |
|
ร้อยละ |
$p1 |
$p2 |
$p3 |
$p4 |
$p5 |
$p6 |
|
[ กลับ ]
TF;
?>
|