จะทำส่วนค้นหาโรงแรมในแต่ละอำเภอ แต่ไม่รู้ว่าจะเขียนโค้ดยังงั้นต่อ ช่วยหน่อยค่ะนั่งมั่วนานแร้ว....
อันนี้ฐานข้อมูลค่ะ Code (PHP) <?php
$hostname_edoc = "127.0.0.1";
$database_edoc = "db_hotel";
$username_edoc = "root";
$password_edoc = "root";
$connect_db= mysql_pconnect($hostname_edoc, $username_edoc, $password_edoc) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_query("SET character_set_results=tis620");
mysql_query("SET character_set_client=tis620");
mysql_query("SET character_set_connection=tis620");
mysql_query("collation_connection = tis620_thai_ci");
mysql_query("collation_database = tis620_thai_ci");
mysql_query("collation_server = tis620_thai_ci");
mysql_select_db($database_edoc, $connect_db) or trigger_error(mysql_error(),E_USER_ERROR);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>จังหวัด-อำเภอ-ตำบล ด้วย AJAX</title>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620" />
<style type="text/css">
* {
font-family:Tahoma;
font-size:8pt;
}
.style1 {
font-size: 12pt;
font-weight: bold;
}
.style2 {font-size: 10pt}
</style>
<script language="javascript">
function go(which) {
n = which.value;
document.form1.submit() ;
}
</script>
</head>
<body>
<?
//ค่าที่ได้รับมาจากการ Submit
$province = $_POST[province];
$amphur = $_POST[amphur];
?>
<p align="center" class="style1">ค้นหาโรงแรม
<form id="form1" name="form1" method="post" action="index.php">
<table width="237" height="88" border="1" align="center" bordercolor="#0000FF" bgcolor="#66FFCC">
<tr>
<td width="60"><span class="style2">จังหวัด : </span></td>
<td width="146"><select name="province_id" id="province_id" onchange="go(this)" >
>
<?php
##############################################################
$query_type2 = "SELECT * FROM province where id='$province_id' ";
$type_db2 = mysql_query($query_type2, $connect_db) or die(mysql_error());
$row_province_id2 = mysql_fetch_assoc($type_db2);
################################################################ ?>
<option value="<?php echo $row_province_id2['id']?>" ><?php echo $row_province_id2['name']?></option>
<?
$sql_province = "SELECT * FROM province ";
$query_province = mysql_query($sql_province, $connect_db) or die(mysql_error());
$row_province_id = mysql_fetch_array($query_province) ;
do {
?>
<option value="<?php echo $row_province_id['id']?>" ><?php echo $row_province_id['name']?></option>
<?php
} while ($row_province_id = mysql_fetch_assoc($query_province));
?>
</select></td>
</tr>
<tr>
<td><span class="style2">อำเภอ : </span></td>
<td><select name="amphur_id" id="amphur_id" >
<?
$sql_amphur = "SELECT * FROM amphur where provinceID='$province_id' ";
$query_amphur = mysql_query($sql_amphur, $connect_db) or die(mysql_error());
$row_amphur_id = mysql_fetch_array($query_amphur) ;
do { ?>
<option value="<?php echo $row_amphur_id['id']?>" ><?php echo $row_amphur_id['name']?></option>
<?php
} while ($row_amphur_id = mysql_fetch_assoc($query_amphur));
?>
</select></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit" /></td>
</tr>
</table>
</form>
<?php
if($Submit=="Submit"){
$sql_amphur = "SELECT
amphur.provinceID,
hotel.name as hotel_name ,
hotel.detail,
hotel.photo,
hotel.id_hotel,
province.name as province_name,
amphur.name as amphur_name ,
FROM
//ส่วนล่ะค่ะที่ไปต่อไม่ได้
";
$query_amphur = mysql_query($sql_amphur, $connect_db) or die(mysql_error());
$row_amphur_id = mysql_fetch_array($query_amphur) ;
?>
<table width="423" border="1" align="center" bordercolor="#0000FF" bgcolor="#CCFFCC">
<tr bgcolor="#0099FF">
<td width="163"><span class="style2">ชื่อ</span></td>
<td width="244"><span class="style2">รายละเอียด</span></td>
</tr>
<tr>
<td><?php print $row_amphur_id['hotel_name']; ?></td>
<td><?php print $row_amphur_id['detail']; ?></td>
</tr>
</table>
<p>
<br>
<? } while ($row_amphur_id = mysql_fetch_assoc($query_amphur));
?></p>
</body>
</html>
Date :
2009-09-22 16:39:39By :
ann
แก้ไขฐานข้อมูลน่ะค่ะ พอคลิกค้นหาอยากให้แสดง รูปภาพ ชื่อ รายละเอียดของโรงแรม
Date :
2009-09-23 03:16:25By :
ann
select * from province as p, amphur as a, hotel as h where (p.id_province = a.id_province) AND (a.id_amphur = h.id_amphur) AND (p.name = '$province') AND (a.name = '$amphur');
Date :
2009-09-23 03:32:17By :
itdekd
Server 05
Load balance : Server 05
