| Server IP : 104.21.80.248 / Your IP : 172.71.28.156 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myschool/triamudom/check/cardtime/ |
Upload File : |
<?php
@session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php');
include ($path.'include/class_display.php');
include ($path.'include/function.php');
$CLASS['db'] = new db();
$CLASS['db']->connect();
$CLASS['disp'] = new display();
$db = $CLASS['db'];
$disp = $CLASS['disp'];
$tb_student_codecard = $_REQUEST['tb_student_codecard'];
$date_day = date("Y-m-d");
$date_time = date("H:i:s");
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
$weeks = array('อาทิตย์','จันทร์','อังคาร','พุธ','พฤหัส','ศุกร์','เสาร์');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>ระบบเช็คชื่อออนไลน์ โรงเรียนแกลง"วิทยสถาวร" จังหวัดระยอง</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<!-- FAVICON-->
<!-- Css styles -->
<link href="css/main.css" rel="stylesheet">
<script src="js/jquery-1.7.2.min.js"></script>
<script src="js/jquery.scrollTo-1.4.2-min.js"></script>
<script src="js/jquery.localscroll-1.2.7-min.js"></script>
<script src="js/jquery.mobilemenu.js"></script>
<script src="js/custom.js"></script>
<script type="text/javascript">
function FocusOnInput()
{
document.getElementById("tb_student_codecard").focus();
}
</script>
<!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<style type="text/css">
body,td,th {
font-family: TH SarabunPSK;
}
a:link {
color: #666666;
text-decoration: none;
}
body {
background-color: #FFFFFF;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style7 {
color: #000000;
font-size: 30px;
font-weight: bold;
}
.style14 {color: #FF0000; font-size: 28px; font-weight: bold; }
.style19 {font-size: 30px}
.style22 {color: #000000; font-size: 28px; font-weight: bold; }
.style24 {color: #FF0000; font-size: 36px; font-weight: bold; }
.style27 {color: #FF0000; font-size: 36; font-weight: bold; }
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head>
<body onLoad="FocusOnInput()">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td valign="top" bgcolor="#FFFF00"><span class="style24"><img src="logo.png" width="50" align="absmiddle"> นักเรียนลงเวลา วัน <?php
$day_dis = date('w', strtotime($date_day));
echo $weeks[$day_dis];
?> ที่
<?php print display_date($date_day,"longthai")?>
</span></td>
</tr>
<tr valign="top">
<td align="right" valign="top" background="20140702083127.jpg" bgcolor="#FFCCFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" valign="top"><?php
//set the number of columns
$columns = 4;
$sql_limit_q = "limit 8";
$sql_dis_pro="select * from tb_times where tb_time_date='".$date_day."' and tb_time_type='1' and tb_time_stuid !='".$fetch_dis_pro1['tb_time_stuid']."' $sql_search order by tb_time_time desc $sql_limit_q ";
$query_dis_pro = $db->query($sql_dis_pro);
//we add this line because we need to know the number of rows
$num_dis_pro = $db->num_rows($query_dis_pro);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
//changed this to a for loop so we can use the number of rows
for($i = 0; $i < $num_dis_pro; $i++) {
$fetch_dis_pro = $db->fetch_array($query_dis_pro);
if($i % $columns == 0) {
//if there is no remainder, we want to start a new row
echo "<TR>\n";
}
?>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<?php
$fetch_disstudent = $db->fetch_array($db->query("select * from tb_students where tb_student_id='".$fetch_dis_pro['tb_time_stuid']."' "));
//echo "select * from tb_students where tb_student_code='".$fetch_dis_pro['tb_time_stucode']."' ";
//echo $fetch_disstudent['tb_student_code'];
//echo $fetch_disstudent['tb_student_degree'];
$fetch_disstudentroom = $db->fetch_array($db->query("select * from tb_rooms where tb_room_id='".$fetch_disstudent['tb_student_degree']."' "));
//echo "select * from tb_rooms where tb_room_id='".$fetch_disstudent['tb_student_degree']."' ";
//echo $fetch_disstudentroom['tb_room_name'];
// echo "<br>";
//echo substr($fetch_disstudentroom['tb_room_name'],5);
?>
<tr>
<td width="16%" align="center" valign="top" nowrap bgcolor="#FFFF99"><p><span class="style22 style25"><?php print $disp->display_studentallcode_show($fetch_dis_pro['tb_time_stucode']);?><?php /*?> ( <?php print $fetch_dis_pro['tb_time_stucode'];?> ) <?php */?><br>
</span><span class="style22 style25"> <span class="style14"><?php print $fetch_dis_pro['tb_time_time'];?> น.</span></span><br>
<img src="../file_student/<?php print $fetch_public['tb_public_year'];?>/M<?php echo substr($fetch_disstudentroom['tb_room_name'],5);?>/<?php print $fetch_dis_pro['tb_time_stucode'];?>.JPG" width="185" border="0"></p> </td>
</tr>
</table></td>
<? if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_dis_pro) {
//if there is a remainder of 1, end the row
//or if there is nothing left in our result set, end the row
echo "</TR>\n";
}
}
?>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>