<form name="frmMain" method="post" action="test_search.php"> <table width="533" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="164" height="31" bgcolor="#FFFF66"><div align="left"><span class="style26">Hotel :</span></div></td> <td width="181" bgcolor="#FFFF66"><span class="style16"> <label> <input type="text" name="txtKeyword" id="txtKeyword" /> </label> </span></td> <td width="188" bgcolor="#FFFF66"> </td> </tr> <tr> <td height="40" bgcolor="#FFFF66" class="style26">Geography :</td> <td bgcolor="#FFFF66"><select id="ddlGeo" name="ddlGeo" onChange = "ListProvince(this.value)"> <option selected value="0">-- Geography--</option> <? $strSQL = "SELECT * FROM geography ORDER BY geo_id ASC "; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); while($objResult = mysql_fetch_array($objQuery)) { ?> <option value="<?=$objResult["geo_id"];?>"><?=$objResult["geo_name"];?></option> <? } ?> </select></td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td height="40" bgcolor="#FFFF66"><div align="left"><span class="style26">Destination :</span></div></td> <td bgcolor="#FFFF66"><span class="style16"> <select id="province_id" name="province_id" style="width:120px" onChange = "ListLocation(this.value)"></select> </span></td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td height="27" bgcolor="#FFFF66"><div align="left"><span class="style26">Location :</span></div></td> <td bgcolor="#FFFF66"><span class="style16"> <select id="location_id" name="location_id" style="width:200px"></select> </span></td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td height="33" bgcolor="#FFFF66"><div align="left"><span class="style26">Room type :</span></div></td> <td bgcolor="#FFFF66"><span class="style16"> <select name="room_id" id="room_id"> <option selected value="0">--Room Type--</option> <? $strSQL = "SELECT * FROM room_type ORDER BY room_id ASC "; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); while($objResult = mysql_fetch_array($objQuery)) { ?> <option value="<?=$objResult["room_id"];?>"><?=$objResult["room_name"];?></option> <? } ?> </select> </span></td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td height="35" bgcolor="#FFFF66"><div align="left"><span class="style26">Rate Between :</span></div></td> <td bgcolor="#FFFF66"><span class="style16"> <select name="room_rate" id="room_rate"> <option value="">--Any--</option> <option value="10-50">10 USD - 50 USD</option> <option value="51-100">51 USD - 100 USD</option> <option value="101-200">101 USD - 200 USD</option> <option value="201-300">201 USD - 300 USD</option> <option value="999"> >300 USD</option> </select> </span></td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td height="28" bgcolor="#FFFF66"><div align="left"><span class="style26">Facibilities :</span></div></td> <td bgcolor="#FFFF66"><span class="style16"> <select name="hotel_fac" id="hotel_fac"> <option value="">--Select Facibilities--</option> <option value="beach">beach</option> <option value="swim">swim</option> <option value="3"></option> <option value="4"></option> <option value="5"></option> </select> </span></td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td bgcolor="#FFFF66"> </td> <td bgcolor="#FFFF66"> </td> <td bgcolor="#FFFF66"> </td> </tr> <tr> <td bgcolor="#FFFF66"> </td> <td bgcolor="#FFFF66"> <div align="left"> <input type="submit" name="button" id="button" value="Search" /> </div></td> <td bgcolor="#FFFF66"> </td> </tr> </table> </form>
<!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>Untitled Document</title> </head> <body> <tr> <td height="123" colspan="3" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <? $txtKeyword=$_POST["txtKeyword"]; $province_id=$_POST["provine_id"]; $location_id=$_POST["location_id"]; $room_id=$_POST["room_id"]; $room_rate=$_POST["room_rate"]; $hotel_fac=$_POST["hotel_fac"]; include 'connect.php'; mysql_query('SET NAMES UTF8'); if($txtKeyword!="") { $sql="SELECT * FROM hotel_infor INNER JOIN geography ON hotel_infor.geo_id=geography.geo_id INNER JOIN province ON hotel_infor.province_id = province.province_id INNER JOIN location ON hotel_infor.location_id = location.location_id INNER JOIN room_type ON hotel_infor.room_id = room_type.room_id INNER JOIN room_rate ON hotel_infor.rate_id = room_rate.rate_id WHERE (hotel_infor.hotel_name LIKE'%$txtKeyword%')"; $query = mysql_query ($sql) or die ("$sql") ; $row = mysql_fetch_array ($query); } //if($geo_id!="") //{ // $sql="SELECT * FROM hotel_infor INNER JOIN geography ON hotel_infor.geo_id=geography.geo_id WHERE(hotel_infor.geo_id LIKE '%$geo_id%')"; // }else{ // $query = mysql_query ($sql) or die ("$sql") ; //$row = mysql_fetch_array ($query); // } /* if($location_id!="") { $strSQL="SELECT * FROM hotel_infor,location WHERE (hotel_infor.hotel_id=lcation.location_id LIKE '%$location_id%' AND location_name LIKE '%$location_id%' AND location_code LIKE '%$location_id%')"; } if($room_id!="") { $strSQL="SELECT * FROM province,location,hotel_infor WHERE (hotel_name LIKE '%$txtKeyword%' OR image LIKE '%$txtKeyword%' OR room_id LIKE '%$$room_id%')"; } if($room_rate!="") { $strSQL="SELECT * FROM hotel_infor WHERE (room_rate LIKE '%$txtKeyword%')"; } //$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); //$arr = mysql_fetch_array($objQuery);*/ ?> <p> </p> <div align="center" class="style20">:: Search Result ::</div> <div align="center"></div> <div align="left"></div> <p> </p> <table width="460" border="1" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="112" bgcolor="#FFFF66"><span class="style19">Photo </span></td> <td width="342" bgcolor="#FFFFFF"> <? if(file_exists("../pic/{$arr['hotel_id']}.gif")) { ?> <img src="../pic/<? echo $arr['hotel_id'] ?>.gif" width="50" border="0"/> <? }?></td> </tr> <tr> <td width="112" bgcolor="#FFFF66"><span class="style19">Hotel Name </span></td> <td width="342" bgcolor="#FFFFFF"><? echo $row['hotel_name']?></td> </tr> <tr> <td bgcolor="#FFFF66"><span class="style19">Star</span></td> <td bgcolor="#FFFFFF"> <? echo $row['hotel_star']?> </td> </tr> <tr> <td bgcolor="#FFFF66"><span class="style19">Province</span></td> <td bgcolor="#FFFFFF"><? echo $row['province_name']?></td> </tr> <tr> <td bgcolor="#FFFF66"><span class="style19">Location</span></td> <td bgcolor="#FFFFFF"><? echo $row['location_name'] ?></td> </tr> <tr> <td bgcolor="#FFFF66"><span class="style19">Room Type</span></td> <td bgcolor="#FFFFFF"><? echo $row['room_name'] ?></td> </tr> <tr> <td bgcolor="#FFFF66"><span class="style19">Rate</span></td> <td bgcolor="#FFFFFF"><? echo $row['cost'] ?></td> </tr> <tr> <td bgcolor="#FFFF66"><span class="style19">Facibilities</span></td> <td bgcolor="#FFFFFF"><? echo $row['hotel_fac'];?></td> </tr> <tr> <td bgcolor="#FFFF66"> </td> <td bgcolor="#FFFFFF"> </td> </tr> </table> <p> </p> <? mysql_close(); ?></td> </tr> </body> </html>
if($geo_id!="" AND $location_id!="" AND $room_id!="" AND $room_rate!="") { condition }
<? $txtKeyword=$_POST["txtKeyword"]; $geo_id=$_POST["geo_id"]; $province_id=$_POST["provine_id"]; $location_id=$_POST["location_id"]; $room_id=$_POST["room_id"]; $rate_id=$_POST["rate_id"]; $hotel_fac=$_POST["hotel_fac"]; include 'connect.php'; mysql_query('SET NAMES UTF8'); if($txtKeyword!="") { $sql="SELECT hotel_infor.hotel_name, geography.geo_name, province.province_name, location.location_name, $sql="SELECT * FROM hotel_infor INNER JOIN geography ON hotel_infor.geo_id=geography.geo_id INNER JOIN province ON hotel_infor.province_id = province.province_id INNER JOIN location ON hotel_infor.location_id = location.location_id INNER JOIN room_type ON hotel_infor.room_id = room_type.room_id INNER JOIN room_rate ON hotel_infor.rate_id = room_rate.rate_id WHERE (hotel_infor.hotel_name LIKE'%$txtKeyword%')"; if($geo_id !="") { $sql="and hotel_infor.hotel_name LIKE '%$geo_id%'"; } else { $sql="and hotel_infor.geo_id=geography.geo_id"; } if($location_id !="") { $sql="and hotel_infor.hotel_name LIKE '%$location_id%'"; } else { $sql="and hotel_infor.location_id=location.location_id"; } if($room_id !="") { $sql="and hotel_infor.hotel_name LIKE'%$room_id%'"; } else { $sql="and hotel_infor.room_id = room_type.room_id"; } if($rate_id !="") { $sql="and hotel_infor.hotel_name LIKE'%$rate_id%'"; } else { $sql="and hotel_infor.rate_id = room_rate.rate_id"; } if($hotel_fac !="") { $sql="and hotel_infor.hotel_name LIKE '%$hotel_fac%'"; } else { $sql="and hotel_infor.hotel_fac = hotel_infor.hotel_fac"; } $query = mysql_query ($sql) or die ("$sql") ; $row = mysql_fetch_array ($query); ?>
<? $strSQL = "SELECT * FROM table WHERE 1 "; if($_POST["txt1"] != "") { $strSQL .= " AND F1 = '".$_POST["txt1"]."' "; } if($_POST["txt2"] != "") { $strSQL .= " AND F2 = '".$_POST["txt2"]."' "; } ?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
