 |
|
นี่ครับโค้ด
ฐานข้อมูล
-- โครงสร้างตาราง `meet_re_time`
CREATE TABLE `meet_re_time` (
`id_auto` int(5) NOT NULL auto_increment,
`id_re` int(5) NOT NULL,
`id_time` int(2) NOT NULL,
`id_status` int(1) NOT NULL,
`id_date` date NOT NULL,
`id_meet` int(3) NOT NULL,
PRIMARY KEY (`id_auto`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=30 ;
-- dump ตาราง `meet_re_time`
INSERT INTO `meet_re_time` VALUES (27, 42, 4, 0, '2011-05-28', 11);
INSERT INTO `meet_re_time` VALUES (26, 42, 3, 0, '2011-05-28', 11);
INSERT INTO `meet_re_time` VALUES (17, 32, 1, 0, '2011-05-28', 11);
INSERT INTO `meet_re_time` VALUES (18, 32, 2, 0, '2011-05-28', 11);
โค้ด
Code (PHP)
<?php
include("../include/config.inc.php");
?>
<style type="text/css">
.tb1 {border-collapse:collapse;}
.tb1 .tr1 {font-size:7px;}
.tb1 td{border:solid silver 1px;padding-right:3px;}
</style>
<table width="100%" border="1" bordercolor="#000000" class="tb1">
<tr class="tr1">
<td width="51%" height="35" background="../images/menubar_m.png" ><div align="center"><font size="2">Room</font></div></td>
<td width="3%" background="../images/menubar_m.png" >8.00<br />
8.30</td>
<td width="2%" background="../images/menubar_m.png" >8.30<br />
9.00</td>
<td width="2%" background="../images/menubar_m.png" >9.00<br />
9.30</td>
<td width="2%" background="../images/menubar_m.png" >9.30<br />
10.00</td>
<td width="2%" background="../images/menubar_m.png" >10.00<br />
10.30</td>
<td width="2%" background="../images/menubar_m.png" >10.30<br />
11.00</td>
<td width="2%" background="../images/menubar_m.png" >11.00<br />
11.30</td>
<td width="2%" background="../images/menubar_m.png" >11.30<br />
12.00</td>
<td width="2%" background="../images/menubar_m.png" >12.00<br />
12.30</td>
<td width="2%" background="../images/menubar_m.png" >12.30<br />
13.00</td>
<td width="2%" background="../images/menubar_m.png" >13.00<br />
13.30</td>
<td width="2%" background="../images/menubar_m.png" >13.30<br />
14.00</td>
<td width="2%" background="../images/menubar_m.png" >14.00<br />
14.30</td>
<td width="2%" background="../images/menubar_m.png" >14.30<br />
15.00</td>
<td width="2%" background="../images/menubar_m.png" >15.00<br />
15.30</td>
<td width="2%" background="../images/menubar_m.png" >15.30<br />
16.00</td>
<td width="2%" background="../images/menubar_m.png" >16.00<br />
16.30</td>
<td width="2%" background="../images/menubar_m.png" >16.30<br />
17.00</font></td>
<td width="2%" background="../images/menubar_m.png" >17.00<br />
17.30</td>
<td width="2%" background="../images/menubar_m.png" >17.30<br />
18.00</td>
<td width="2%" background="../images/menubar_m.png" >18.00<br />
18.30</td>
<td width="2%" background="../images/menubar_m.png" >18.30<br />
19.00</td>
<td width="2%" background="../images/menubar_m.png" >19.00<br />
19.30</td>
<td width="2%" background="../images/menubar_m.png" >19.30<br />
20.00</td>
</tr>
<?
//ทำการเลือกวันที่ และรหัสห้อง
$sql12="select * from meet_re_time where id_date='2011-05-28' and id_meet ='11' ";
$result12=mysql_query($sql12) or die("ติดต่อข้อมูลไม่ได้");
while ($data12=mysql_fetch_array($result12)){
?>
<tr >
<td bgcolor="#F5F5F5"><div align="center">
<?=$data12[id_meet];?>
</div></td>
<td ><? if($data12[id_time]=="1") { echo "1";}else{?><input name="check[]" type="checkbox" id="check[]" value="1" /><? } ?></td>
<td ><? if($data12[id_time]=="2") { echo "2";}else{?><input name="check[]" type="checkbox" id="check[]" value="2" /><? } ?></td>
<td ><? if($data12[id_time]=="3") { echo "3";}else{?><input name="check[]" type="checkbox" id="check[]" value="3" /><? } ?></td>
<td ><? if($data12[id_time]=="4") { echo "4";}else{?><input name="check[]" type="checkbox" id="check[]" value="4" /><? } ?></td>
<td><? if($data12[id_time]=="5") { echo "5";}else{?><input name="check[]" type="checkbox" id="check[]" value="5" /><? } ?></td>
<td ><? if($data12[id_time]=="6") { echo "6";}else{?><input name="check[]" type="checkbox" id="check[]" value="6" /><? } ?></td>
<td ><? if($data12[id_time]=="7") { echo "7";}else{?><input name="check[]" type="checkbox" id="check[]" value="7" /><? } ?></td>
<td ><? if($data12[id_time]=="8") { echo "8";}else{?><input name="check[]" type="checkbox" id="check[]" value="8" /><? } ?></td>
<td ><? if($data12[id_time]=="9") { echo "9";}else{?><input name="check[]" type="checkbox" id="check[]" value="9" /><? } ?></td>
<td ><? if($data12[id_time]=="10") { echo "10";}else{?><input name="check[]" type="checkbox" id="check[]" value="10" /><? } ?></td>
<td ><? if($data12[id_time]=="11") { echo "11";}else{?><input name="check[]" type="checkbox" id="check[]" value="11" /><? } ?></td>
<td ><? if($data12[id_time]=="12") { echo "12";}else{?><input name="check[]" type="checkbox" id="check[]" value="12" /><? } ?></td>
<td ><? if($data12[id_time]=="13") { echo "13";}else{?><input name="check[]" type="checkbox" id="check[]" value="13" /><? } ?></td>
<td ><? if($data12[id_time]=="14") { echo "14";}else{?><input name="check[]" type="checkbox" id="check[]" value="14" /><? } ?></td>
<td ><? if($data12[id_time]=="15") { echo "15";}else{?><input name="check[]" type="checkbox" id="check[]" value="15" /><? } ?></td>
<td ><? if($data12[id_time]=="16") { echo "16";}else{?><input name="check[]" type="checkbox" id="check[]" value="16" /><? } ?></td>
<td ><? if($data12[id_time]=="17") { echo "17";}else{?><input name="check[]" type="checkbox" id="check[]" value="17" /><? } ?></td>
<td ><? if($data12[id_time]=="18") { echo "18";}else{?><input name="check[]" type="checkbox" id="check[]" value="18" /><? } ?></td>
<td ><? if($data12[id_time]=="19") { echo "19";}else{?><input name="check[]" type="checkbox" id="check[]" value="19" /><? } ?></td>
<td ><? if($data12[id_time]=="20") { echo "20";}else{?><input name="check[]" type="checkbox" id="check[]" value="20" /><? } ?></td>
<td ><? if($data12[id_time]=="21") { echo "21";}else{?><input name="check[]" type="checkbox" id="check[]" value="21" /><? } ?></td>
<td ><? if($data12[id_time]=="22") { echo "22";}else{?><input name="check[]" type="checkbox" id="check[]" value="22" /><? } ?></td>
<td ><? if($data12[id_time]=="23") { echo "23";}else{?><input name="check[]" type="checkbox" id="check[]" value="23" /><? } ?></td>
<td ><? if($data12[id_time]=="24") { echo "24";}else{?><input name="check[]" type="checkbox" id="check[]" value="24" /><? } ?></td>
</tr><? } ?>
</table>
|
 |
 |
 |
 |
Date :
2011-05-29 10:40:59 |
By :
baipan14 |
|
 |
 |
 |
 |
|
|
 |