| Server IP : 61.19.30.66 / Your IP : 216.73.216.59 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/gpa/ |
Upload File : |
<?
require_once "config/connectdb.php";
?>
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<title>งานทะเบียนวัดผล</title>
</head>
<body>
<?
//////////หหหหห้อง 1//////
$crsql="SELECT count(UserID) FROM `klw` where cllass = 1 and room >0 and sex = 1 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm1x=$dcrd[0];
$crsql="SELECT count(UserID) FROM `klw` where cllass = 1 and room >0 and sex = 2 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm1y=$dcrd[0];
$slipnum_mm1xy=$slipnum_mm1x+$slipnum_mm1y;
$crsql="SELECT count(UserID) FROM `klw` where cllass = 2 and room >0 and sex = 1 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm2x=$dcrd[0];
$crsql="SELECT count(UserID) FROM `klw` where cllass = 2 and room >0 and sex = 2 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm2y=$dcrd[0];
$slipnum_mm2xy=$slipnum_mm2x+$slipnum_mm2y;
$crsql="SELECT count(UserID) FROM `klw` where cllass = 3 and room >0 and sex = 1 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm3x=$dcrd[0];
$crsql="SELECT count(UserID) FROM `klw` where cllass = 3 and room >0 and sex = 2 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm3y=$dcrd[0];
$slipnum_mm3xy=$slipnum_mm3x+$slipnum_mm3y;
$crsql="SELECT count(UserID) FROM `klw` where cllass = 4 and room >0 and sex = 1 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm4x=$dcrd[0];
$crsql="SELECT count(UserID) FROM `klw` where cllass = 4 and room >0 and sex = 2 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm4y=$dcrd[0];
$slipnum_mm4xy=$slipnum_mm4x+$slipnum_mm4y;
$crsql="SELECT count(UserID) FROM `klw` where cllass = 5 and room >0 and sex = 1 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm5x=$dcrd[0];
$crsql="SELECT count(UserID) FROM `klw` where cllass = 5 and room >0 and sex = 2 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm5y=$dcrd[0];
$slipnum_mm5xy=$slipnum_mm5x+$slipnum_mm5y;
$crsql="SELECT count(UserID) FROM `klw` where cllass = 6 and room >0 and sex = 1 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm6x=$dcrd[0];
$crsql="SELECT count(UserID) FROM `klw` where cllass = 6 and room >0 and sex = 2 and stat =1 ";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$slipnum_mm6y=$dcrd[0];
$slipnum_mm6xy=$slipnum_mm6x+$slipnum_mm6y;
$slipnum_mmxx=$slipnum_mm1x+$slipnum_mm2x+$slipnum_mm3x+$slipnum_mm4x+$slipnum_mm5x+$slipnum_mm6x;
$slipnum_mmyy=$slipnum_mm1y+$slipnum_mm2y+$slipnum_mm3y+$slipnum_mm4y+$slipnum_mm5y+$slipnum_mm6y;
$slipnum_mmtotal=$slipnum_mmxx+$slipnum_mmyy;
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
?>
<?
$sql2="SELECT cllass FROM klw";
$result2 = mysql_query($sql2);
while (list($cllass) = mysql_fetch_row($result2)) {
$xsc_Name = 1;
$xsc_Name2 = 2;
$xsc_Name3 = 3;
$xsc_Name4 = 4;
$xsc_Name5 = 5;
$xsc_Name6 = 6;
}
?>
<center><table border="0" bgcolor="black" style="width: 400px">
<tbody>
<tr bgcolor="#FFFFFF"><font size="2" color="black">จำนวนนักเรียน/ผู้ปกครองตรวจผลการเรียน</font>
<td><font size = "2">เพศ</font></td>
<td><font size = "2">ช</font></td>
<td><font size = "2">ญ</font></td>
<td><font size = "2">รวม</font></td>
<td><font size = "2">ตรวจวิชาเลือก/ตรวจกิจกรรม/ชุดเสื้อ กางเกง</font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td><a href="showclass.php"><font size = "2">ม.1</font></a> <a href=excellroom2.php?id=<? echo "$xsc_Name"; ?>><img src="images/excel.jpg" width="15" height="15" ></a></td>
<td><font size = 2><? echo number_format($slipnum_mm1x); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm1y); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm1xy); ?></font></td>
<td><font size = 2><a href="showroom.php?id=1">ม.1</font> /<font size = 2><a href="showinstallac1.php?id=<? echo $xsc_Name; ?>">ม.1 /<font size = 2><a href="t1.php?id=<? echo $xsc_Name; ?>">ม.1</font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><a href="showclass.php"><font size = "2">ม.2</font></a> <a href=excellroom2.php?id=<? echo "$xsc_Name2"; ?>><img src="images/excel.jpg" width="15" height="15" ></a></td>
<td><font size = 2><? echo number_format($slipnum_mm2x); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm2y); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm2xy); ?></font></td>
<td><font size = 2><a href="showroom.php?id=2">ม.2</font> /<font size = 2><a href="showinstallac1.php?id=<? echo $xsc_Name2; ?>">ม.2 /<font size = 2><a href="t1.php?id=<? echo $xsc_Name2; ?>">ม.2</font></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td><a href="showclass.php"><font size = "2">ม.3</font></a> <a href=excellroom2.php?id=<? echo "$xsc_Name3"; ?>><img src="images/excel.jpg" width="15" height="15" ></a></td>
<td><font size = 2><? echo number_format($slipnum_mm3x); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm3y); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm3xy); ?></font></td>
<td><font size = 2><a href="showroom.php?id=3">ม.3</font> /<font size = 2><a href="showinstallac1.php?id=<? echo $xsc_Name3; ?>">ม.3 /<font size = 2><a href="t1.php?id=<? echo $xsc_Name3; ?>">ม.3</font></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><a href="showclass.php"><font size = "2">ม.4</font></a> <a href=excellroom2.php?id=<? echo "$xsc_Name4"; ?>><img src="images/excel.jpg" width="15" height="15" ></a></td>
<td><font size = 2><? echo number_format($slipnum_mm4x); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm4y); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm4xy); ?></font></td>
<td><font size = 2><a href="showroom.php?id=4">ม.4</font> /<font size = 2><a href="showinstallac1.php?id=<? echo $xsc_Name4; ?>">ม.4 /<font size = 2><a href="t1.php?id=<? echo $xsc_Name4; ?>">ม.4</font></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td><a href="showclass.php"><font size = "2">ม.5</font></a> <a href=excellroom2.php?id=<? echo "$xsc_Name5"; ?>><img src="images/excel.jpg" width="15" height="15" ></a></td>
<td><font size = 2><? echo number_format($slipnum_mm5x); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm5y); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm5xy); ?></font></td>
<td><font size = 2><a href="showroom.php?id=5">ม.5</font> /<font size = 2><a href="showinstallac1.php?id=<? echo $xsc_Name5; ?>">ม.5 /<font size = 2><a href="t1.php?id=<? echo $xsc_Name5; ?>">ม.5</font></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><a href="showin.php"><font size = "2">ม.6</font></a> <a href=excellroom2.php?id=<? echo "$xsc_Name6"; ?>><img src="images/excel.jpg" width="15" height="15" ></a></td>
<td><font size = 2><? echo number_format($slipnum_mm6x); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm6y); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mm6xy); ?></font></td>
<td><font size = 2><a href="showroom.php?id=6">ม.6</font> /<font size = 2><a href="showinstallac1.php?id=<? echo $xsc_Name6; ?>">ม.6 /<font size = 2><a href="t1.php?id=<? echo $xsc_Name6; ?>">ม.6</font></font></td>
</tr>
<tr bgcolor="#DDDDDD">
<td><a href="showclass.php"><font size = "2">รวม</font></a></td>
<td><font size = 2><? echo number_format($slipnum_mmxx); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mmyy); ?></font></td>
<td><font size = 2><? echo number_format($slipnum_mmtotal); ?></font></td>
<td><font size = 2></font></td>
</tr>
<TD COLSPAN=5>
<a href ="subjectinstall.php" target="_self"><IMG SRC="image/subjects.jpg" WIDTH=200 HEIGHT=100 ALT=""></a><a href ="subjectinstallacti.php" target="_self"><IMG SRC="image/subjects2.jpg" WIDTH=200 HEIGHT=100 ALT=""></a></TD>
</tbody>
</table></center>
</body>
</html>