| 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 : |
<?//============ Start Session และทำการเรียก Function ติดต่อฐานข้อมูล
require_once "config/connectdb.php";
require_once "head.php";
//require_once('../connect/function.php');
//=========== กรณีลบรายการสินค้า
$crsql="SELECT time_s FROM `time_chack` where time_s='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$checkout=$dcrd[0];
?>
<html>
<title>..:: ระบบจัดการฐานข้อมูล ::</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<div align="center"><br>
<table cellspacing=1 cellpadding=4 width="68%" bgcolor=#CCCCCC border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td width="100%" bgcolor="#FFFFFF"> <div align="center"></div>
<table cellspacing=1 cellpadding=4 width="100%" border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td width="35%" bgcolor="#FFFFFF"> <div align="left"><b><img src="../image/allrowto.gif" width="11" height="11" align="absbottom">
รายชื่อลงเวลามาเรียน</b></div></td>
<td width="22%" align=middle bgcolor="#FFFFFF"> <div align="left">
</div></td>
<td width="43%" bgcolor="#FFFFFF"> <div align="right"><a href="index.php">กลับไปหน้าหลัก</a></div></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
</div>
<form name="frm<?=$i;?>" method="post" action="<?=$_SERVER['PHP_SELF'];?>" enctype="multipart/form-data">
<table width="68%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="58%">ชั้น
<select name="menu1" class="txtbox" onChange="MM_jumpMenu('parent',this,0)">
<option value="<?=$_SERVER['PHP_SELF'];?>">เลือก</option>
<?
//=========== แสดงหมวดหมู่
$sql_group = "select * from time_chack group by time_s order by time_s desc";
$dbquery_group = mysql_query($sql_group);
$num_rows_group = mysql_num_rows($dbquery_group);
while ($result = mysql_fetch_array($dbquery_group))
{
if($_GET["time_s"]==$result["time_s"])
{
$sel="selected";
}
else
{
$sel="";
}
?>
<option value="<?=$_SERVER['PHP_SELF'];?>?time_s=<?=$result["time_s"];?>" <?=$sel;?>><?=$result["time_s"];?></option>
<?
}
?>
</select></td>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<table cellspacing=1 cellpadding=3 width="68%" bgcolor=#CCCCCC border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td bgcolor="#FFFFFF"><div align="center">ที่</div></td>
<td bgcolor="#FFFFFF"><div align="center">รหัส</div></td>
<td bgcolor="#FFFFFF">ชื่อ</td>
<td bgcolor="#FFFFFF"><div align="center">นามสกุล</div></td>
<td bgcolor="#FFFFFF"><div align="center">ชั้น ม.</div></td>
<td bgcolor="#FFFFFF"><div align="center">ห้อง</div></td>
<td bgcolor="#FFFFFF"><div align="center">เลขที่</div></td>
<td bgcolor="#FFFFFF"><div align="center"></div></td>
<td bgcolor="#FFFFFF"><div align="center"></div></td>
<td bgcolor="#FFFFFF"><div align="center"></div></td>
</tr>
<?
//=========== แสดงสินค้า
$i=0;
//=========== ทำการ query เพื่อเลือกรายการสินค้า
$sql_product = "select * from time_chack join klw on klw.Password=time_chack.time_id where time_s='$_GET[time_s]' and Password!='$checkout' group by Username order by cllass asc,room asc";
$dbquery_product = mysql_query($sql_product);
$num_rows_product = mysql_num_rows($dbquery_product);
while ($result= mysql_fetch_array($dbquery_product))
{
$i++;
?>
<tr bgcolor=#e5e5e5>
<td width="28" bgcolor="#FFFFFF"> <div align="center">
<?=$i;?>
</div></td>
<td width="66" bgcolor="#FFFFFF"><div align="center">
<?=$result["Username"];?>
</div></td>
<td width="176" bgcolor="#FFFFFF">
<?=$result["Name"];?>
</td>
<td width="62" bgcolor="#FFFFFF">
<?=$result["surname"];?>
</td>
<td width="64" bgcolor="#FFFFFF"><div align="center">
<?=$result["cllass"];?>
</div></td>
<td width="64" bgcolor="#FFFFFF"><div align="center">
<?=$result["room"];?>
</div></td>
<td width="76" bgcolor="#FFFFFF"><div align="center">
<?=$result["ordinal"];?>
</div></td>
<td width="71" bgcolor="#FFFFFF"> <div align="right">
</div></td>
<td width="32" bgcolor="#FFFFFF"><div align="center"></div></td>
<td width="36" bgcolor="#FFFFFF"><div align="center"></div></td>
</tr>
<?
}
?>
</tbody>
</table>
<table cellspacing=0 cellpadding=4 width="68%" bgcolor=#CCCCCC border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td width="100%" bgcolor="#FFFFFF"> <div align="center"></div>
<table cellspacing=1 cellpadding=4 width="100%" border=0 align="center" height="10">
<tbody>
<tr bgcolor=#e5e5e5>
<td width="35%" bgcolor="#FFFFFF"> <div align="left"></div></td>
<td width="22%" align=middle bgcolor="#FFFFFF"> <div align="left">
</div></td>
<td width="43%" bgcolor="#FFFFFF"> <div align="right"><a href="index.php">กลับไปหน้าหลัก</a></div></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
</form>