header('Content-Type: text/html; charset=tis-620');
include('../db_config.php');
$sql0="select
sum(y62a1) as y62a1,sum(y62p1) as y62p1,sum(y62m1) as y62m1,sum(y62m4) as y62m4,
sum(y63a1) as y63a1,sum(y63p1) as y63p1,sum(y63m1) as y63m1,sum(y63m4) as y63m4,
sum(y62a1s) as y62a1s,sum(y62p1s) as y62p1s,sum(y62m1s) as y62m1s,sum(y62m4s) as y62m4s,
sum(y63a1s) as y63a1s, sum(y63p1s) as y63p1s,sum(y63m1s) as y63m1s,sum(y63m4s) as y63m4s
from sk1_pclass";
$result0=mysql_query($sql0);
$db0=mysql_fetch_array($result0);
$sql="select * from sk1_pclass,sk1_sch where psmis=smis and scgrp != 'prv' order by sampur";
$result=mysql_query($sql);
echo <<สรุปแผนการจัดชั้นเรียน ปีการศึกษา 2562-2563 สพป.ศรีสะเกษ เขต 1 << กลับ >>
ที่ |
โรงเรียน |
ปีการศึกษา 2562 |
ปีการศึกษา 2563 |
อ.1 |
ป.1 |
ม.1 |
ม.4 |
อ.1 |
ป.1 |
ม.1 |
ม.4 |
ห้อง |
นร. |
ห้อง |
นร. |
ห้อง |
นร. |
ห้อง |
นร. |
ห้อง |
นร. |
ห้อง |
นร. |
ห้อง |
นร. |
ห้อง |
นร. |
TH;
$rw=1;
while ($db=mysql_fetch_array($result)) {
if (($rw%2)==0) { $col='#e6ffff'; } else { $col='#bfffff'; }
echo <<
$rw |
$db[sname] |
$db[y62a1] |
$db[y62a1s] |
$db[y62p1] |
$db[y62p1s] |
$db[y62m1] |
$db[y62m1s] |
$db[y62m4] |
$db[y62m4s] |
$db[y63a1] |
$db[y63a1s] |
$db[y63p1] |
$db[y63p1s] |
$db[y63m1] |
$db[y63m1s] |
$db[y63m4] |
$db[y63m4s] |
TB;
$rw++;
}
$t62a1s=number_format($db0[y62a1s]);
$t62p1s=number_format($db0[y62p1s]);
$t62m1s=number_format($db0[y62m1s]);
$t62m4s=number_format($db0[y62m4s]);
$t63a1s=number_format($db0[y63a1s]);
$t63p1s=number_format($db0[y63p1s]);
$t63m1s=number_format($db0[y63m1s]);
$t63m4s=number_format($db0[y63m4s]);
echo <<
รวม |
$db0[y62a1] |
$t62a1s |
$db0[y62p1] |
$t62p1s |
$db0[y62m1] |
$t62m1s |
$db0[y62m4] |
$t62m4s |
$db0[y63a1] |
$t63a1s |
$db0[y63p1] |
$t63p1s |
$db0[y63m1] |
$t63m1s |
$db0[y63m4] |
$t63m4s |
กลับ
TF;
?>
|