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_22222/Develop_person_depart/ drwxr-xr-x |
Viewing file: Conclude_bkp.php (15.69 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | <?php session_start(); if (session_is_registered("valid_user")&&session_is_registered("Priority") ) { $Password = $password; include("../include/FunctionDB.php"); include("admin_menu.php"); ConnectDB(); $sql = "Select Sum(Teacher_name) From personal_tb "; $sql2 = "Select * From personal_tb"; $result = mysql_query($sql) or die(" Error").mysql_error(); $result2 = mysql_query($sql2) or die(" Error").mysql_error(); $rs = mysql_fetch_array($result); $rs2 = mysql_fetch_array($result2); $total = mysql_num_rows($result2); ?> <meta http-equiv="Content-Type" content="text/html; charset=TIS-620"> <link href="../source/style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style5 {font-size: 14px} .style6 { font-size: 14px; font-weight: bold; } --> </style> <table width="814" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="814"><br /> <fieldset> <legend><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><span class="style5"><a href="menu_personal.php" >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="PersonalData.php">ข้อมูลส่วนตัวบุลากร</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="EducationData.php">ข้อมูลวุฒิบุคลากร</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" />รายละเอียดสัดส่วนการศึกษา</span></font></legend> <label></label> <div align="center"> <form id="form1" name="form1" method="post" action=""> <p align="left"><font size="2" face="Tahoma"><img src="../picture/previous.gif" onclick="window.history.back()" width="85" height="22" border="0" /></font></p> <table width="89%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table" style="border:0px solid gray"> <tr bgcolor="#F3ECD2" > <td height="24" colspan="4"><div align="center" class="style6"><font color="#003366" face="Tahoma">แสดงรายละเอียดสัดส่วนการศึกษา</font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#EEEEEE" style="border:1px solid gray"><div align="center" class="style5"><font color="#003366" face="Tahoma"><strong>วุฒิ</strong></font></div></td> <td bgcolor="#EEEEEE" style="border:1px solid gray"><div align="center" class="style5"><font color="#003366" face="Tahoma"><strong>จำนวน (</strong></font><font color="#000000" face="Tahoma"><strong> คน </strong></font><font color="#003366" face="Tahoma"><strong>) </strong></font></div></td> <td bgcolor="#EEEEEE" style="border:1px solid gray"><div align="center" class="style5"><font color="#003366" face="Tahoma"><strong>ร้อยละ</strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td width="46%" bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#000000" face="Tahoma">ปริญญาตรี</font></div> </div></td> <td width="28%" bgcolor="#FFFFFF" class="e"><div align="center" class="d style1 style5"><font color="#000000" face="Tahoma"><strong> <a href="DegreeList.php?Degree_code=1"> <?php $sql1 = "SELECT count(Degree_code) as num1 FROM personal_tb WHERE Degree_code=1 "; $result = mysql_query($sql1) or die(" Error").mysql_error(); $rs1 = mysql_fetch_array($result); echo "$rs1[num1]"; ?> </a> </strong></font></div></td> <td width="26%" bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#000000" face="Tahoma"><strong> <?php $per1 = ($rs1[num1] * 100) / $total; echo number_format($per1,2,'.','.'); ?> </strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td height="22" bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#000000" face="Tahoma">ปริญญาโท</font></div> </div></td> <td bgcolor="#FFFFFF" class="e"><div align="center" class="style5"><font color="#000000" face="Tahoma"><strong> <a href="DegreeList.php?Degree_code=2"> <?php $sql2 = "Select Count(Degree_code) as num2 From personal_tb Where Degree_code=2 "; $result = mysql_query($sql2) or die(" Error").mysql_error(); $rs2 = mysql_fetch_array($result); echo "$rs2[num2]"; ?> </a> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#000000" face="Tahoma"><strong> <?php $per2 = ($rs2[num2] * 100) / $total; echo number_format($per2,2,'.','.'); ?> </strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#000000" face="Tahoma">ปริญญาเอก</font></div> </div></td> <td bgcolor="#FFFFFF" class="e"><div align="center" class="style5"><font color="#000000" face="Tahoma"><strong> <a href="DegreeList.php?Degree_code=3"> <?php $sql3 = "Select Count(Degree_code) as num3 From personal_tb Where Degree_code=3 "; $result = mysql_query($sql3) or die(" Error").mysql_error(); $rs3 = mysql_fetch_array($result); echo "$rs3[num3]"; ?> </a> </strong></font></div></td> <td bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#000000" face="Tahoma"><strong> <?php $per3 = ($rs3[num3] * 100) / $total; echo number_format($per3,2,'.','.'); ?> </strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td height="22" bgcolor="#F3ECD2"><div align="left"><span class="style5"></span></div></td> <td colspan="3" bgcolor="#F3ECD2"><table width="79%" border="0" align="center"> <tr bgcolor="#F3ECD2"> <td width="30%" bgcolor="#F3ECD2" class="style5"><div align="center"><font color="#003366" face="Tahoma"><strong>ปริญญาตรี</strong></font></div></td> <td width="30%" class="style5"><div align="center"><font color="#003366" face="Tahoma"><strong>ปริญญาโท</strong></font></div></td> <td width="30%" class="style5"><div align="center"><font color="#003366" face="Tahoma"><strong>ปริญญาเอก</strong></font></div></td> </tr> </table></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">อัตราส่วน</font></div> </div></td> <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style5"> <font color="#FF0000" face="Tahoma"><strong> <?php echo number_format($per1,2,'.','.'); ?> <font color="#000000">:</font> <?php echo number_format($per2,2,'.','.'); ?> <font color="#000000"> : </font> <?php echo number_format($per3,2,'.','.'); ?> </strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">จำนวนอาจารย์วุฒิทางการพยาบาล</font></div> </div></td> <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#003366" face="Tahoma"><strong> </strong></font><font color="#000000" size="2" face="Tahoma"><strong> <?php $sql7 = "Select Count(Teacher_type) as num7 From personal_tb Where Teacher_type=5 "; $result = mysql_query($sql7) or die(" Error").mysql_error(); $rs7= mysql_fetch_array($result); echo "$rs7[num7]"; ?> </strong></font><font color="#003366" face="Tahoma"><strong> คน</strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">จำนวนอาจารย์วุฒิทันตแพทย์ศาสตรบัณฑิต</font></div> </div></td> <td colspan="3" 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 Teacher_type=1 "; $result = mysql_query($sql4) or die(" Error").mysql_error(); $rs4 = mysql_fetch_array($result); echo "$rs4[num4]"; ?> </strong></font><span class="style5"><font color="#003366" face="Tahoma"><strong>คน</strong></font></span></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">จำนวนอาจารย์วุฒิเภสัชศาสตรบัณฑิต</font></div> </div></td> <td colspan="3" 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 Teacher_type=4 "; $result = mysql_query($sql5) or die(" Error").mysql_error(); $rs5 = mysql_fetch_array($result); echo "$rs5[num5]"; ?> </strong></font><span class="style5"><font color="#003366" face="Tahoma"><strong>คน</strong></font></span></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">จำนวนอาจารย์ตำแหน่งวิทยาจารย์</font></div> </div></td> <td colspan="3" 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 Teacher_type=2 "; $result = mysql_query($sql6) or die(" Error").mysql_error(); $rs6= mysql_fetch_array($result); echo "$rs6[num6]"; ?> </strong></font></strong><span class="style5"><font color="#003366" face="Tahoma"><strong>คน</strong></font></span></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">จำนวนอาจารย์ทั้งหมด</font></div> </div></td> <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#003366" face="Tahoma"><strong> <?php $sql = "Select * From personal_tb Where Teacher_type='1' Or Teacher_type='2' Or Teacher_type='4' Or Teacher_type='5' "; $result = mysql_query($sql) or die(" Error").mysql_error(); $num = mysql_num_rows($result); echo "$num "; ?> คน </strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">จำนวนนักศึกษา</font></div> </div></td> <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#FF0000"><strong><font color="#003366" face="Tahoma"> <?php // $CountNurse = $rs[CountNurse]; $sql4 ="Select * From student_tb Where Succ_Status='1' "; $res2 = mysql_query($sql4) or die("Error".mysql_error()); $Total_std = mysql_num_rows($res2); echo"$Total_std"; ?> คน</font></strong></font></div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font color="#003366" face="Tahoma">สัดส่วนอาจารย์ที่มีวุฒิสาธารณสุข ต่อ จำนวนนักศึกษา</font></div> </div></td> <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#003366" face="Tahoma"><strong> <?php $sql = "Select Count(Type_Degree) as CountNurse From personal_tb Where Type_Degree='1' "; $result = mysql_query($sql) or die(" Error").mysql_error(); $rs = mysql_fetch_array($result); $rs[CountNurse] ; echo "$rs[CountNurse] "; ?> : </strong><font color="#FF0000"><strong> <?php // $CountNurse = $rs[CountNurse]; $sql4 ="Select * From student_tb Where Succ_Status='1' "; $res2 = mysql_query($sql4) or die("Error".mysql_error()); $Total_std = mysql_num_rows($res2); echo"$Total_std"; ?> </strong></font></font> </div></td> </tr> <tr bordercolor="#CCCCCC"> <td bgcolor="#FFFFFF"><div align="center" class="style5"> <div align="left"><font face="Tahoma"><font color="#003366">สัดส่วนอาจารย์</font><font color="#003366" face="Tahoma">ทั้งหมดต่อจำนวนนักศึกษา</font></font></div> </div></td> <td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style5"><font color="#FF0000"><strong> <font color="#003366" face="Tahoma"> <?php $sql = "Select * From personal_tb Where Teacher_type='1' Or Teacher_type='2' Or Teacher_type='4' Or Teacher_type='5' "; $result = mysql_query($sql) or die(" Error").mysql_error(); $num = mysql_num_rows($result); echo "$num "; ?> </font></strong></font><font color="#003366" face="Tahoma"><strong> : <?php // $CountNurse = $rs[CountNurse]; $sql4 ="Select * From student_tb Where Succ_Status='1' "; $res2 = mysql_query($sql4) or die("Error".mysql_error()); $Total_std = mysql_num_rows($res2); echo"$Total_std"; ?> </strong></font></div></td> </tr> <tr > <td height="20" colspan="4" bgcolor="#FFFFFF"> </td> </tr> <tr > <td height="20" colspan="4" bgcolor="#FFFFFF"><div align="center"><font color="#003366" size="2" face="Tahoma"><a href="../graph/reportdegreel.php?num1=<? echo $rs1[num1]?>&m2=<? echo $rs2[num2]?>&m3=<? echo $rs3[num3]?>">แสดงกราฟอัตราส่วนวุฒิการศึกษา</a></font></div></td> </tr> </table> </form> </div> </fieldset> <br /> <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br /> </font></td> </tr> </table> <?php } else { echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n"; echo"Please Login "; } ?> |
:: 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.0169 ]-- |