| Server IP : 134.236.49.22 / Your IP : 216.73.216.114 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/backup/170865/Menu กลุ่มงานบริหารงานทั่วไป/ |
Upload File : |
<!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><?php
if (isset($_GET['Name'])) echo $_GET['Name'];
else echo 'Unknown';
?></title>
<html lang="th">
<meta charset="utf-8">
<style>
table, td, th {
border: 1px solid black; //กำหนดความหนาและสีของเส้นขอบ
padding:4px ;
cellspacing:1px;
}
th {
background-color: #3366cc; //กำหนดสีพื้นหลังของหัวตาราง
}
</style>
</head>
<div align="center">
<img src="/Menu กลุ่มงานบริหารงานทั่วไป/img/Header2.jpg" width="700" height="117" />
<body>
<?php
//ตั้งค่าการเชื่อมต่อฐานข้อมูล
$database_host = '192.168.1.39';
$database_port = '3306';
$database_username = 'root';
$database_password = '090407';
$database_name = 'mit';
$mysqli = new mysqli($database_host, $database_username, $database_password, $database_name, $database_port);
$mysqli->set_charset("utf8");
if ($mysqli->connect_error) {
die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
if (isset($_GET['Emp'])) {
$chkDate = $_GET['Date'];
$emp =$_GET['Emp'];
$SqlDate = substr($chkDate,6,4).'-'.substr($chkDate,3,2).'-'.substr($chkDate,0,2);
$tdate = strtotime($SqlDate.' 22:00:00');
$tStart = date('Y-m-d H:i:s', strtotime('-1 days',$tdate));
$tdate = strtotime($SqlDate.' 02:00:00');
$tStop = date('Y-m-d H:i:s', strtotime('+1 days',$tdate));
$Num=0;
echo '<p>'.$emp.','.$tStart.','.$tStop.'</p>';
echo '<table align="center" width="700" class="table" id="datatable">';
$get_time = $mysqli->query("SELECT date ,type FROM timerec WHERE timerec.hn ='{$emp}' AND timerec.date >='{$tStart}' AND timerec.date <='{$tStop}' order by date");
while($recT = $get_time->fetch_array()){
$Num=$Num+1;
echo "<TR><td align='left'><span>";
if ($recT['type'] == 'O') echo " ลงชื่อออก :";
else echo " ลงชื่อ เข้า :";
echo $recT['date']."</span></td></TR>";
}
if ($Num==0) echo "<TR><td align='left'><span> ไม่พบการบันทึก</span></td>";
mysqli_free_result($get_time);
echo "</table>";
}
?>
</p>
</body>
</html>