 |
|

Code (PHP)
<?php
include 'control-booking.php';
include'connect-db/connect-db.php';
$arrTime = array('08.00-10.00','09.00-11.00','10.00-12.00','11.00-13.00',
'12.00-14.00','13.00-15.00','14.00-16.00','15.00-17.00',
'16.00-18.00','17.00-19.00','18.00-20.00');
$courtName = array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);
?>
<main>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body><br>
<script src="jquery.ui-1.5.2/jquery-1.2.6.js" type="text/javascript"></script>
<script src="jquery.ui-1.5.2/ui/ui.datepicker.js" type="text/javascript"></script>
<link href="jquery.ui-1.5.2/themes/ui.datepicker.css" rel="stylesheet" type="text/css">
<center>
<form name="form1" method="post" action="booking.php">
<input type="text" size="30" value="<?php echo date('Y-m-d'); ?>" id="jQueryUICalendar1" name="ckDate"/>
<input type="submit" name="ckDate2" id="ckDate" value="ตรวจสอบ">
<script type="text/javascript">
// BeginWebWidget jQuery_UI_Calendar: jQueryUICalendar1
jQuery("#jQueryUICalendar1").datepicker({dateFormat:'yy-mm-dd'});
// EndWebWidget jQuery_UI_Calendar: jQueryUICalendar1
</script>
</form></center>
<center><p>วันที่จอง : <?php echo $_POST['ckDate']; ?></p></center>
<?php
$strTable = '<table border="" width="100%" align="center" bgcolor="#7fffd4"><tr><td width="8%"><a style="color:black">ห้อง/เวลา</a></td>';
foreach($arrTime as $time){
$strTable.='<td><a style="color:black">'.$time.'</a></td>';
}
$strTable.='</tr>';
foreach($courtName as $Num){
$strTable.='<td><a style="color:black">'.$Num.'</a></td>';
$sql="SELECT * FROM booking WHERE room = {$Num} and date ='{$_POST['ckDate']}' Order by time ASC";
$rs = mysql_query($sql) or die(mysql_error());
$run=0;
foreach($arrTime as $time){
if(mysql_num_rows($rs)>$run && $time == mysql_result($rs,$run,'time')){
$strTable.='<td bgcolor="red"></td>';
$run++;
}else{
$strTable.='<td bgcolor="#f0fff0"></td>';
}
}
$strTable.='</tr>';
}
echo $strTable,'</table>';
?>
จากข้อมูลตังกล่าว ผมอยากกำหนดข้อมูลห้องกับเวลา ดึงออกจากฐานข้อมูล ต้องดึงยังไงหรอครับ ช่วยทีคับ
|
 |
 |
 |
 |
Date :
2016-02-09 15:35:50 |
By :
awirutritsak |
|
 |
 |
 |
 |
|
|
 |