Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/director/ drwxr-xr-x |
Viewing file: SumPesonal_bkp.php (22.58 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | <?php include("../include/FunctionDB.php"); include("admin_menu.php"); ConnectDB(); $sql = "Select Sum(Teacher_name) From personal_tb "; $result = mysql_query($sql) or die(" Error").mysql_error(); $rs = mysql_fetch_array($result); $sql2 = "Select * From personal_tb Order By Teacher_name ASC"; $result2 = mysql_query($sql2) or die(" Error").mysql_error(); $rs2 = mysql_fetch_array($result2); $total = mysql_num_rows($result2); ?> <meta http-equiv="Content-Type" content="text/html; charset=TIS-620"> <style type="text/css"> <!-- .style1 { color: #0000FF; font-size: 14px; } .style2 {color: #003399} .style3 { font-size: 14px; font-weight: bold; } .style4 {font-size: 14px} .style6 {color: #FF0000} .style7 { color: #0000FF; font-weight: bold; } .style10 {color: #0000FF} .style12 { color: #0000FF; font-family: Tahoma; font-size: 14px; } .style13 {font-size: 16px} .style14 {color: #003399; font-size: 14px; } --> </style> <table width="816" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="816"><br> <fieldset> <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Director_menu.php" >หน้าหลัก</a><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />จำนวนบุคลากรจำแนกตามหน่วยงาน</font></legend> <label><div align="center"> <form id="form1" name="form1" method="post" action=""> <p align="left"><span class="style7"><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></span></p> <table width="86%" height="356" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border:0px solid gray"size="12"> <tr> <td height="27" bgcolor="#FFFFFF"><div align="center" class="style10 style13"><font face="Tahoma">รายงานสรุปสถานะข้อมูลบุคลากร</font> <table width="92%" height="317" border="0" cellpadding="0" cellspacing="0" style="border:0px solid gray"> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td colspan="4" bgcolor="#FFFFFF" class="style7"> </td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="17" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/FlatBars2.gif" width="17" height="17" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style12">จำนวนระดับการศึกษาของบุคลากรทุกสายงานทั้งหมด</td> <td bgcolor="#FFFFFF"><div align="center" class="style12">จำนวน</div></td> <td bgcolor="#FFFFFF"><div align="center" class="style12">ร้อยละ</div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td width="4%" height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td width="64%" bgcolor="#FFFFFF" class="style4"><font face="Tahoma"><a href="PersonalData1.php?Page=1&Degree_code=1<? echo $rs[Degree_code]?>" class="d"> ปริญญาตรี</a></font></td> <td width="19%" bgcolor="#FFFFFF"><div align="center"><font color="#000055" size="2" face="Tahoma"><strong> <?php $sql1 = "SELECT count(Degree_code) as num1 FROM personal_tb WHERE StatusId='1' and Degree_code=1 "; $result = mysql_query($sql1) or die(" Error").mysql_error(); $rs1 = mysql_fetch_array($result); echo "$rs1[num1]"; ?> </strong></font></div></td> <td width="19%" bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <a href="DegreeList.php?Degree_code=1"></a> <?php $per1 = ($rs1[num1] * 100) / $total; echo number_format($per1,2,'.','.'); ?> </strong></font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"> <a href="PersonalData2.php?Page=1&Degree_code=2<? echo $rs[Degree_code]?>" class="d">ปริญญาโท</a></font></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql2 = "Select Count(Degree_code) as num2 From personal_tb Where StatusId='1' and Degree_code=2 "; $result = mysql_query($sql2) or die(" Error").mysql_error(); $rs2 = mysql_fetch_array($result); echo "$rs2[num2]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $per2 = ($rs2[num2] * 100) / $total; echo number_format($per2,2,'.','.'); ?> </strong></font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"><a href="PersonalData3.php?Page=1&Degree_code=3<? echo $rs[Degree_code]?>" class="d"> ปริญญาเอก</a></font></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql3 = "Select Count(Degree_code) as num3 From personal_tb Where StatusId='1' and Degree_code=3 "; $result = mysql_query($sql3) or die(" Error").mysql_error(); $rs3 = mysql_fetch_array($result); echo "$rs3[num3]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $per3 = ($rs3[num3] * 100) / $total; echo number_format($per3,2,'.','.'); ?> </strong></font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="17" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/FlatBars2.gif" width="17" height="17" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style12">จำนวนบุคลากรตามประเภทสายงาน</td> <td bgcolor="#FFFFFF"><div align="center" class="style12">จำนวน</div></td> <td bgcolor="#FFFFFF"><div align="center" class="style12">ร้อยละ</div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d"><span class="style1"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=1<? echo $rs[Teacher_type]?>" class="d">ทันตแพทย์</a></font></span></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql4 = "Select Count(Teacher_type) as num4 From personal_tb Where StatusId='1' and Teacher_type=1 "; $result = mysql_query($sql4) or die(" Error").mysql_error(); $rs4 = mysql_fetch_array($result); echo "$rs4[num4]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $per4 = ($rs4[num4] * 100) / $total; echo number_format($per4,2,'.','.'); ?> </strong></font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d"><span class="style1"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=4<? echo $rs[Teacher_type]?>" class="d">เภสัชกร</a></font></span></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql5 = "Select Count(Teacher_type) as num5 From personal_tb Where StatusId='1' and Teacher_type=4 "; $result = mysql_query($sql5) or die(" Error").mysql_error(); $rs5 = mysql_fetch_array($result); echo "$rs5[num5]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $per5 = ($rs5[num5] * 100) / $total; echo number_format($per5,2,'.','.'); ?> </strong></font></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=2<? echo $rs[Teacher_type]?>" class="d">วิทยาจารย์</a></font><font face="Tahoma"><strong><span class="style3"><a href="PersonalData4.php?Page=1&Teacher_type=2<? echo $rs[Teacher_type]?>" class="d"></a></span></strong></font></font></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql6 = "Select Count(Teacher_type) as num6 From personal_tb Where StatusId='1' and Teacher_type=2 "; $result = mysql_query($sql6) or die(" Error").mysql_error(); $rs6= mysql_fetch_array($result); echo "$rs6[num6]"; ?> </strong></font> </strong></div></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $per6 = ($rs6[num6] * 100) / $total; echo number_format($per6,2,'.','.'); ?> </strong></font> </strong></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=5<? echo $rs[Teacher_type]?>"" class="style2">พยาบาลวิชาชีพ</a> </font></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql7 = "Select Count(Teacher_type) as num7 From personal_tb Where StatusId='1' and Teacher_type=5 "; $result = mysql_query($sql7) or die(" Error").mysql_error(); $rs7= mysql_fetch_array($result); echo "$rs7[num7]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $per7 = ($rs7[num7] * 100) / $total; echo number_format($per7,2,'.','.'); ?> </strong></font></strong></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><a href="PersonalData4.php?Page=1&Teacher_type=6<? echo $rs[Teacher_type]?>"" class="style2">สายสนับสนุน</a> </font></td> <td bgcolor="#FFFFFF"><div align="center"><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql8 = "Select Count(Teacher_type) as num8 From personal_tb Where StatusId='1' and Teacher_type=6 "; $result = mysql_query($sql8) or die(" Error").mysql_error(); $rs8= mysql_fetch_array($result); echo "$rs8[num8]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $per8 = ($rs8[num8] * 100) / $total; echo number_format($per8,2,'.','.'); ?> </strong></font></strong></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="17" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/FlatBars2.gif" width="17" height="17" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style12">จำนวนบุคลากรตามสถานะ</td> <td bgcolor="#FFFFFF"><div align="center" class="style12">จำนวน</div></td> <td bgcolor="#FFFFFF"><div align="center" class="style12">ร้อยละ</div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="style1"><font face="Tahoma"><font face="Tahoma"><a href="PersonalDatatype.php?Page=1&Person_type=1<? echo $rs[Person_type]?>" class="style2">ข้าราชการ</a></font></font></td> <td bgcolor="#FFFFFF"><div align="center"> <font color="#000000" size="2" face="Tahoma"><strong> <?php $sql9 = "Select Count(Person_type) as num9 From personal_tb Where StatusId='1' and Person_type=1 "; $result = mysql_query($sql9) or die(" Error").mysql_error(); $rs9= mysql_fetch_array($result); echo "$rs9[num9]"; ?> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $per9 = ($rs9[num9] * 100) / $total; echo number_format($per9,2,'.','.'); ?> </strong></font> </strong></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d"><a href="PersonalDatatype.php?Page=1&Person_type=3<? echo $rs[Person_type]?>"><span class="style14"><font face="Tahoma"><font face="Tahoma">ลูกจ้างประจำ</font></font></span></a></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql10 = "Select Count(Person_type) as num10 From personal_tb Where StatusId='1' and Person_type=3 "; $result = mysql_query($sql10) or die(" Error").mysql_error(); $rs10= mysql_fetch_array($result); echo "$rs10[num10]"; ?> </strong></font> </strong></div></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $per10 = ($rs10[num10] * 100) / $total; echo number_format($per10,2,'.','.'); ?> </strong></font> </strong></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><span class="style1"><font face="Tahoma"><a href="PersonalDatatype.php?Page=1&Person_type=4<? echo $rs[Person_type]?>" class="d">ลูกจ้างชั่วคราว (เหมาจ่าย) </a></font></span></font></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql11 = "Select Count(Person_type) as num11 From personal_tb Where StatusId='1' and Person_type=4 "; $result = mysql_query($sql11) or die(" Error").mysql_error(); $rs11= mysql_fetch_array($result); echo "$rs11[num11]"; ?> </strong></font> </strong></div></td> <td bgcolor="#FFFFFF"><div align="center"><strong><font color="#000000" size="2" face="Tahoma"><strong> <?php $per11 = ($rs11[num11] * 100) / $total; echo number_format($per11,2,'.','.'); ?> </strong></font> </strong></div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td height="18" bgcolor="#FFFFFF"><div align="center"><font size="2" face="Tahoma"><strong><img src="../Image/icon_paper2.gif" width="9" height="11" align="absmiddle" /></strong></font></div></td> <td bgcolor="#FFFFFF" class="d style4 style6"><font face="Tahoma"><span class="style4"><font face="Tahoma"><a href="PersonalData.php" class="d">รวมจำนวนบุคลากรทั้งหมด</a></font></span></font></td> <td colspan="2" bgcolor="#FFFFFF"><div align="center"><strong><font size="4" face="Tahoma"> <?php // $code = $rs["code"]; $sql5 = "Select * From personal_tb Where StatusId='1' "; $result5 = mysql_query($sql5) or die(" Error".mysql_error()); $rc5 = mysql_num_rows($result5); if ( $rc5 == 0) { echo"<font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">"; echo"ยังไม่ข้อมูล"; echo"</font>"; } else if ($rc5 > 0) { echo"<font face=\"Tahoma\" Size=\"2\" color=\"#006633\">"; echo"$rc5 <font face=\"Tahoma\" Size=\"2\" color=\"#000000\">คน</font>"; echo"</font>"; } ?> </font> </strong></div> <div align="center"> </div></td> </tr> <tr onmouseover="this.style.backgroundColor='#FCFCF3'" onmouseout="this.style.backgroundColor='#EEEEEE'" > <td> </td> </tr> </table> </div></td> </tr> <tr> <td height="20" ><div align="center"> <p class="style4"><font face="Tahoma"><!--<a href="./graph/reportdegreel.php?num1=<? //echo $rs1[num1]?>&m2=<? //echo $rs2[num2]?>&m3=<? //echo $rs3[num3]?>">--><!--</a>--></font></p> <?php //include("personal_graph.php"); ?> </div> </td> </tr> </table> </form> </div> </label> </fieldset><br> <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br> </font></td> </tr> </table> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0063 ]-- |