| Server IP : 202.29.229.35 / Your IP : 18.117.151.234 Web Server : Apache System : Linux aapanel2 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 User : www ( 1001) PHP Version : 5.5.38 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,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,imap_open,apache_setenv MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /www/wwwroot/www.ivecr2.ac.th/system_admin/ |
Upload File : |
<?php
session_start();
if($_SESSION['r_statuslogin'] != 1){
echo '<script language="javascript">alert("สำหรับผู้ดูแลระบบเท่านั้น")</script>';
echo'<meta http-equiv="refresh" content="0;url=../index.php">';
exit();
}
include("connect/connect.php");
//include("connect/function.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<!------------นำเมาส์ชี้ที่่รูปแล้วเกิดภาพซ้อน------------------->
<style type="text/css">
/*Credits: Dynamic Drive CSS Library */
/*URL: http://www.dynamicdrive.com/style/ */
.thumbnail{
position: relative;
z-index: 0;
}
.thumbnail:hover{
background-color: transparent;
z-index: 50;
}
.thumbnail span{ /*CSS for enlarged image*/
position: absolute;
background-color: lightyellow;/* สีขอบรูปใหญ่ */
padding: 5px; /*ขนาดเส้นกรอบ */
left: -1000px;
border: 1.5px dashed gray; /*ขนาดและสีเส้นปะ*/
visibility: hidden;
color: black;
text-decoration: none ;
}
.thumbnail span img{ /*CSS for enlarged image*/
border-width: 0;
padding: 2px;
}
.thumbnail:hover span{ /*CSS for enlarged image on hover*/
visibility: visible;
top: 0;
left: 60px; /*รูปเยื้องทางซ้าย*/
}
.style24 {color: #FFFFFF}
</style>
<!---------------------------->
<body>
<p><center><h2>รายชื่อผู้ดูแลระบบงานทั้งหมด</h2></center></p>
<form id="form1" name="form1" method="post" action="">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td width="214" align="right">ค้นหาตามชื่องาน/แผนกวิชา :</td>
<td width="345" align="left"><select name="selectwork" id="selectwork">
<option value="">-----------------------------เลือก---------------------------</option>
<?php
$sqlad="select * from tbl_departmentall order by daNodpt ASC";
$resqlad=mysql_query($sqlad,$connect1);
while($rsad=mysql_fetch_array($resqlad)){
?>
<option value="<?php echo $rsad['daNodpt'];?>"><?php echo $rsad['daFname']; ?></option>
<?php
}//end while
?>
</select></td>
<td width="121" align="left"><input type="submit" name="button" id="button" value="ค้นหา" /></td>
</tr>
</table>
</form>
<?php
$selectwork=$_POST['selectwork'] ;
/*
if($selectwork != ""){
$sqlwork1="select * from tbl_departmentall where daNodpt='$selectwork' order by daNodpt ASC ";
}else{
$sqlwork1="select * from tbl_departmentall order by daNodpt ASC ";
}
$resqlwork1=mysql_query($sqlwork1,$connect1);
$numrow=mysql_num_rows($resqlwork1);
*/
if($selectwork != ""){
$queryper = "select * from tbl_datatecher1 where selectwork='$selectwork' order by selectwork ASC ";
}else{
$queryper = "select * from tbl_datatecher1 ";
}
//echo "--->".$queryper;
$resultper=mysql_query($queryper,$connect2);
//$rspertec=mysql_fetch_array($resultper);
//$tecPhoto=$rspertec['tecPhoto'];//รูป
//echo "PicTec=>".$tecPhoto;
?>
<table width="700" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td align="center" valign="top"> </td>
<td align="center" valign="top"><font color="#0033FF" size="+1">ผู้ดูแลระบบงานทั้งหมด : <?php echo $numrow;?> คน</font></td>
<td align="center" valign="top"><a href="?i=addAd">เพิ่มข้อมูล</a></td>
</tr>
<tr>
<td width="48" align="center" valign="top" bgcolor="#999999"><strong>ที่</strong></td>
<td width="446" align="center" valign="top" bgcolor="#999999"><strong>ชื่อ/นามสกุล/แผนกวิชา/งาน</strong></td>
<td width="176" align="center" valign="top" bgcolor="#999999"><strong>การจัดการ</strong></td>
</tr>
<?php
$n=0;
while($rspertec=mysql_fetch_array($resultper)){
$n++;
$tecPrefixThai=$rspertec['tecPrefixThai'];//คำนำหน้าชื่อ
$selectwork = $rspertec['selectwork'];//กลุ่มงาน
//คำนำหน้าชื่อ
$sqlpf="select * from ref_prefix_name where PREFIX_NAME_ID=$tecPrefixThai";
$resulpf=mysql_query($sqlpf,$connect2);
$rspf=mysql_fetch_array($resulpf);
$tecPrefixThaiori=$rspf['FULLNAME'];
$tecLogFname=$tecPrefixThaiori." ".$rspertec['tecFnameThai']." ".$tecLname=$rspertec['tecLnameThai'];
//ชื่อกลุ่มงาน
$sqlwork="select * from tbl_departmentall where daNodpt='$selectwork' ";
$resqlwork=mysql_query($sqlwork);
$rswork=mysql_fetch_array($resqlwork);
$workname = $rswork['daFname'];
if($bg == "#F5F5F5") {
$bg = "#FDFDFD";
} else {
$bg = "#F5F5F5";
}
?>
<tr bgcolor="<?php echo $bg?>" >
<td width="48" align="center" valign="top"><?php echo $n;?></td>
<td width="446" align="left" valign="top"> <?php echo $tecLogFname //$rs['adFname']." ".$rs['adLname'];?>
<font color="#0099FF" size="-2"><i><?php echo " (".$workname.")";?></i></font></td>
<td width="176" align="center" valign="top"><a href="?i=adminEdit&adID=<?php echo $rs['adID'];?>">แก้ไขข้อมูล</a> || <a href="?i=delAd&adID=<?php echo $rs['adID'];?>">ลบข้อมูล</a></td>
</tr>
<?php
}//end while
?>
</table>
</body>
</html>