!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!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> <title>Untitled Document</title> <style type="text/css"> table#gridview { clear:both; } table#gridview td { padding:3px 0px; } table#gridview tr.head { background:#B18904; font-family:Arial, Helvetica, sans-serif; text-align:center; } table#gridview tr.head td { padding:3px 0px; } .bb2 { font-size: 14px; } text-indent:0.5in; #gridviewsss { color: #FFF; } body { background-color: #D3D3D3; } body,td,th { color: #909090; } thead > tr{background:#A2C4AA;} th, td{font-family:font-family:Arial, Helvetica, sans-serif} thead th{color:#fff;font-size:14px;} tr{height:44px;} tbody > tr:nth-child(even) {background: #f3f3f3} tbody > tr:nth-child(odd) {background: #fff} tr.tr2 {background:#FFB7B7 !important} tr.tr3 {background:#0066ff !important} tbody > tr:hover, tr.tr2:hover, tr.tr3:hover{background:#fff5e6 !important} tbody td{font-size:13px;color:#000} tbody td > div{text-align:center} .text-center{text-align:center} .hide{display: none;visibility: hidden;} </style> <body> <?php include('config.php'); $strSQL = "SELECT * FROM customer"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); $Num_Rows = mysql_num_rows($objQuery); $strSQL .=" ORDER BY id DESC"; $objQuery = mysql_query($strSQL); ?> <table class="display" width="800" height="114" border="0" align="center" cellpadding="1" cellspacing="1" id="gridview"> <thead> <tr> <th width="35">ID </th> <th width="134">Reservation Date</th> <th width="212">Guest Name</th> <th width="161">Destination</th> <th width="79">Amount</th> </tr> </thead> <?php while($objResult = mysql_fetch_array($objQuery)) { $id = $objResult["id"]; $remark = $objResult["remark"]; $edit_class = (trim($remark) == '') ? '' : ' hide'; $tr_class = ''; if ($objResult['level'] == '2' OR $objResult['level'] == 3) { $tr_class = ' class="tr'.$objResult['level'].'"'; } echo '<tr'.$tr_class.'>'; ?> <td height="34"><?php echo $id;?></td> <td><?php echo $objResult["reservation_date"];?></td> <td><?php echo $objResult["destination"];?></td> <td><?php echo $objResult["guest_name"];?><br /></td> <td><?php echo $objResult["amount"];?></td></tr> <div class="text-center<?php echo $edit_class;?>"><tr> <td height="29" colspan="5"><?php echo $remark;?></td> </tr></div> <?php } ?> </table> </body> </html>
<?php while($objResult = mysql_fetch_array($objQuery)) { $id = $objResult["id"]; $remark = $objResult["remark"]; $edit_class = (trim($remark) == '') ? '' : ' hide'; $tr_class = ''; if ($objResult['level'] == '2' OR $objResult['level'] == 3) { $tr_class = ' class="tr'.$objResult['level'].'"'; } if ($remark != ""): echo '<tr'.$tr_class.'>'; ?> <td height="34"><?php echo $id;?></td> <td><?php echo $objResult["reservation_date"];?></td> <td><?php echo $objResult["destination"];?></td> <td><?php echo $objResult["guest_name"];?><br /></td> <td><?php echo $objResult["amount"];?></td></tr> <div class="text-center<?php echo $edit_class;?>"><tr> <td height="29" colspan="5"><?php echo $remark;?></td> </tr></div> <?php endif; } ?>
<?php while($objResult = mysql_fetch_array($objQuery)) { $id = $objResult["id"]; $remark = $objResult["remark"]; $edit_class = (trim($remark) == '') ? '' : ' hide'; $tr_class = ''; if ($objResult['level'] == '2' OR $objResult['level'] == 3) { $tr_class = ' class="tr'.$objResult['level'].'"'; } echo '<tr'.$tr_class.'>'; ?> <td height="34"><?php echo $id;?></td> <td><?php echo $objResult["reservation_date"];?></td> <td><?php echo $objResult["destination"];?></td> <td><?php echo $objResult["guest_name"];?><br /></td> <td><?php echo $objResult["amount"];?></td></tr> <?php if ($remark != ""): ?> <div class="text-center<?php echo $edit_class;?>"><tr> <td height="29" colspan="5"><?php echo $remark;?></td> </tr></div> <?php endif; } ?>
$strSQL = "SELECT * FROM customer WHERE remark != ''"; หรือ $strSQL = "SELECT * FROM customer WHERE remark != NULL";
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
