<?php session_start(); if($_SESSION['UserID'] == "") { echo "Please Login!"; exit(); } if($_SESSION['Status'] != "Staff") { echo "Please Login Again!"; exit(); } include('config.php'); //mysql_connect("localhost","root","root"); mysql_select_db("ots_data"); $strSQL = "SELECT *FROM member WHERE UserID = '".$_SESSION['UserID']."' "; $objQuery = mysql_query($strSQL); $objResult3 = mysql_fetch_array($objQuery); $Fleet = $objResult3["Fleet"]; ?> <!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" xml:lang="en-gb" lang="en-gb" > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <script> window.onload = function(){ document.adminForm.submit(); } </script> <body> <?php include('config.php');?> <form action="Show_List.php" method="post" name="adminForm" id="adminForm"> <table width="105%" height="32" border="0" cellpadding="0" cellspacing="0"> <tr> <td >Date :</td> <td><input id = "date" name="date_search" size="20" style="width:150px;" value="<? date_default_timezone_set('Asia/Bangkok'); $date = date("Y-m-d");echo $date?>" /> </td> <td >Fleet: </td> <td > <input type="text" name="Fleet_search" id="Fleet_search" value="<?= $Fleet ;?>"/></td> </tr> </table> </form> </body> </html>
<!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" xml:lang="en-gb" lang="en-gb" > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <script type="text/javascript"> // stop window onload window.onload=function(){ var auto = setTimeout(function(){ autoRefresh(); }, 100);} function autoRefresh(){ clearTimeout(auto); auto = setTimeout(function(){ submitform(); autoRefresh(); }, 10000); } </script> <head> <script type="text/javascript" src="jQueryui/jQuery.js"></script> <script type="text/javascript" src="jQueryui/jQuery-ui.js"></script> </head> <script type="text/javascript"> // stop window onload window.onload=function(){ var auto = setTimeout(function(){ autoRefresh(); }, 100);} function autoRefresh(){ clearTimeout(auto); auto = setTimeout(function(){ submitform(); autoRefresh(); }, 10000); } </script> <body> <?php include('config.php');?> <form action="Show_List.php" method="post" name="adminForm" id="adminForm"> <table width="1009" height="33" border="0" align="center" cellpadding="0" cellspacing="0" class="display" id="headtop"> <thead> <tr align="center" bgcolor="#CDCDCD"> <td width="118" height="33" align="right" class="ff2">Booking Date :</td> <td width="150" align="left"><span class="ff2"> <input type="text" id="datepicker" name="date_search" size="30" style="background: #F5DA81;width:150px;"onchange="document.adminForm.submit();"/> </span></td> <td width="94" align="right">Fleet :</td> <td width="647" align="left"><input name="Fleet_search" type="text" id="Fleet_search" size="30" style="width:180px;" /></td> </tr> </thead> </table> </form> <thead> <table width="1015" border="1" align="center" cellpadding="1" cellspacing="1"> <thead><tr bgcolor="#154360"style="font-family:Arial, Helvetica, sans-serif; font-style:normal;font-weight:normal; font-size:13px;color:#F9E79F"> <td width="23" height="30" align="center"><span style="font-size:16px; font-weight:bold;color:#F9E79F;"><strong>ID</strong></span></td> <td width="130" height="30" align="center"><strong><span style="font-size: 16px; color: #F9E79F">Booking Date</span></strong></td> <td width="151" align="center"><strong><span style="font-size: 16px; color: #F9E79F">Car Model</span></strong></td> <td width="193" align="center"><strong><span style="font-size: 16px; color: #F9E79F">Fleet</span></strong></td> <td width="404" align="center"><strong><span style="font-size: 16px; color: #F9E79F">Details</span></strong></td> <td width="95" height="30" align="center"><span style="font-size:16px; font-weight:bold;color:#F9E79F;"><strong>EDIT</strong></span></td> </tr></thead> <?php $sql_show = "SELECT * FROM customer"; if($_POST) { $date_search= $_POST['date_search']; $Fleet_search= $_POST['Fleet_search']; $sql_show .=" WHERE booking_date like '%$date_search%' and fleet like '%$Fleet_search%' ORDER BY booking_date ASC"; } $result_show = mysql_query($sql_show) or die(mysql_error()); while($row_show = mysql_fetch_array($result_show)) { ?> <tr bgcolor="#FFFFFF"style="font-family:Arial, Helvetica, sans-serif; font-style:normal;font-weight:normal; font-size:13px;color:black"> <td height="30" align="center"> <?=$row_show['id']?></td> <td height="30"><?=$row_show['booking_date']?></td> <td height="30"><?=$row_show['Model']?></td> <td><?=$row_show['fleet']?></td> <td height="30"><?=$row_show['detail']?></td> <td height="30"><div align="center"><a href="Show_list.php?edit_id=<? echo $row_show[id]?>"><img src="edit.png" width="53" height="25" alt="edit" longdesc="edit.png" /></a></div></td> </tr> <? } ?> </table> </body> <script type="text/javascript"> $(function(){ $("#datepicker").datepicker({ dateFormat: "yy-mm-dd" }).val('<?=$_POST['date_search'];?>') }); </script> <script type="text/javascript"> document.getElementById("Fleet_search").value = "<?=$_POST["Fleet_search"];?>"; //--> </script> <link href="jQueryui/jQuery-ui.css" rel="stylesheet" type="text/css"/> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
