001.
<html>
002.
<head>
003.
<title>ค้นหา</title>
004.
<style type=
"text/css"
>
005.
th {font-family:sans-serif;
006.
font-size:12px;
007.
}
008.
</style>
010.
<script type=
"text/javascript"
>
011.
google.load(
"jquery"
,
"1.3.2"
);
012.
</script>
013.
<script type=
"text/javascript"
>
014.
function
get_search (p, t){
015.
var
p = $(
"#price"
).val();
016.
var
t = $(
"#txtKeyword"
).val();
017.
018.
if
(p.length==0 && t.length==0){
019.
alert(
'โปรดเลือกราคาหรือชื่อหอพักที่ต้องการค้นหา'
);
020.
}
021.
022.
}
023.
</script>
024.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=windows-874"
></head>
025.
<body>
026.
<form name=
"frmSearch"
method=
"post"
action=
"<?=$_SERVER['PHP_SELF']?>"
onSubmit=
"get_search (price, txtKeyword)"
>
027.
<table width=
"641"
border=
"0"
cellpadding=
"0"
cellspacing=
"0"
>
028.
<tr>
029.
<th width=
"631"
>ราคาห้องพัก
030.
<select name=
"price"
id=
"price"
>
031.
<option value=
""
>- เลือกราคา -</option>
032.
<option value=
"1"
<?
if
(
$price
==1){?>selected<? }?>>น้อยกว่า1000</option>
033.
<option value=
"2"
<?
if
(
$price
==2){?>selected<? }?>>1001-1500</option>
034.
<option value=
"3"
<?
if
(
$price
==3){?>selected<? }?>>1501-2000</option>
035.
<option value=
"4"
<?
if
(
$price
==4){?>selected<? }?>>2001-2500</option>
036.
<option value=
"5"
<?
if
(
$price
==5){?>selected<? }?>>2501-3000</option>
037.
<option value=
"6"
<?
if
(
$price
==6){?>selected<? }?>>มากกว่า 3000</option>
038.
</select>
039.
ค้นหา
040.
<input name=
"txtKeyword"
type=
"text"
id=
"txtKeyword"
value=
"<?=$_POST["
txtKeyword
"];?>"
>
041.
<input type=
"submit"
value=
"Search"
></th>
042.
</tr>
043.
</table>
044.
</form>
045.
<? @
include
(
"connect.php"
); ?>
046.
047.
<?
048.
if
(
$_REQUEST
[
'price'
]!=
''
){
049.
$price
=
$_REQUEST
[
'price'
];
050.
switch
(
$price
){
051.
case
1:
052.
$where
=
" WHERE price_prd < 1000 "
;
053.
break
;
054.
case
2:
055.
$where
=
" WHERE price_prd BETWEEN 1001 AND 1500 "
;
056.
break
;
057.
case
3:
058.
$where
=
" WHERE price_prd BETWEEN 1501 AND 2000 "
;
059.
break
;
060.
case
4:
061.
$where
=
" WHERE price_prd BETWEEN 2001 AND 2500 "
;
062.
break
;
063.
case
5:
064.
$where
=
" WHERE price_prd BETWEEN 2501 AND 3000 "
;
065.
break
;
066.
case
6:
067.
$where
=
" WHERE price_prd > 3000 "
;
068.
break
;
069.
}
070.
}
071.
if
(
$_REQUEST
[
"txtKeyword"
] !=
""
){
072.
073.
$detail
=
$_REQUEST
[
"txtKeyword"
];
074.
$where
=
" WHERE (name_prd LIKE '%"
.
$detail
.
"%') "
;
075.
}
076.
if
(
$_REQUEST
[
'price'
]!=
''
&&
$_REQUEST
[
"txtKeyword"
] !=
""
){
077.
078.
$price
=
$_REQUEST
[
'price'
];
079.
$name_prd
=
$_REQUEST
[
"txtKeyword"
];
080.
switch
(
$price
){
081.
case
1:
082.
$where
=
" WHERE price_prd < 1000 OR name_prd LIKE '%"
.
$name_prd
.
"%' "
;
083.
break
;
084.
case
2:
085.
$where
=
" WHERE price_prd BETWEEN 1001 AND 1500 OR name_prd LIKE '%"
.
$name_prd
.
"%'"
;
086.
break
;
087.
case
3:
088.
$where
=
" WHERE price_prd BETWEEN 1501 AND 2000 OR name_prd LIKE '%"
.
$name_prd
.
"%'"
;
089.
break
;
090.
case
4:
091.
$where
=
" WHERE price_prd BETWEEN 2001 AND 2500 OR name_prd LIKE '%"
.
$name_prd
.
"%'"
;
092.
break
;
093.
case
5:
094.
$where
=
" WHERE price_prd BETWEEN 2501 AND 3000 OR name_prd LIKE '%"
.
$name_prd
.
"%'"
;
095.
break
;
096.
case
6:
097.
$where
=
" WHERE price_prd > 3000 OR name_prd LIKE '%"
.
$name_prd
.
"%'"
;
098.
break
;
099.
}
100.
}
101.
102.
?>
103.
104.
105.
<table border=
"0"
cellpadding=
"0"
cellspacing=
"1"
>
106.
<tr>
107.
<th width=
"92"
bgcolor=
"#FBFCE4"
> <div align=
"center"
>รหัสหอพัก</div></th>
108.
<th width=
"97"
bgcolor=
"#FBFCE4"
> <div align=
"center"
>ชื่อหอพัก </div></th>
109.
<th width=
"140"
bgcolor=
"#FBFCE4"
> <div align=
"center"
>ประเภทหอพัก </div></th>
110.
<th width=
"83"
bgcolor=
"#FBFCE4"
> <div align=
"center"
>ราคา</div></th>
111.
<th width=
"110"
bgcolor=
"#FBFCE4"
> <div align=
"center"
>รูปภาพ </div></th>
112.
<th width=
"170"
bgcolor=
"#FBFCE4"
> <div align=
"center"
>รายละเอียด</div></th>
113.
</tr>
114.
<?
115.
if
(
$price
!=
''
||
$txtKeyword
!=
''
){
116.
$strSQL
=
"SELECT * FROM tb_product "
;
117.
$strSQL
.=
" LEFT JOIN tb_type ON tb_product .ref_id_type = tb_type.id_type"
;
118.
$strSQL
.=
" $where"
;
119.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
120.
$Num_Rows
= mysql_num_rows(
$objQuery
);
121.
122.
$Per_Page
= 10;
123.
124.
$Page
=
$_GET
[
"Page"
];
125.
if
(!
$_GET
[
"Page"
])
126.
{
127.
$Page
=1;
128.
}
129.
130.
$Prev_Page
=
$Page
-1;
131.
$Next_Page
=
$Page
+1;
132.
133.
$Page_Start
= ((
$Per_Page
*
$Page
)-
$Per_Page
);
134.
if
(
$Num_Rows
<=
$Per_Page
)
135.
{
136.
$Num_Pages
=1;
137.
}
138.
else
if
((
$Num_Rows
%
$Per_Page
)==0)
139.
{
140.
$Num_Pages
=(
$Num_Rows
/
$Per_Page
) ;
141.
}
142.
else
143.
{
144.
$Num_Pages
=(
$Num_Rows
/
$Per_Page
)+1;
145.
$Num_Pages
= (int)
$Num_Pages
;
146.
}
147.
148.
$strSQL
.=
" order by id_prd ASC LIMIT $Page_Start , $Per_Page"
;
149.
$objQuery
= mysql_query(
$strSQL
);
150.
151.
$bg
= 1;
152.
while
(
$objResult
= mysql_fetch_array(
$objQuery
)) {
$bg
++;
153.
if
(
$bg
%2==0){
154.
$bgr
=
'#FFF'
;
155.
}
else
{
156.
$bgr
=
'#EBEBEB'
;
157.
}
158.
?>
159.
<tr bgcolor=
"<?=$bgr?>"
>
160.
<td height=
"50"
><div align=
"center"
><?=
$objResult
[
"id_prd"
];?></div></td>
161.
<td><div align=
"center"
><?=
$objResult
[
"name_prd"
];?></div></td>
162.
<td><div align=
"center"
><?=
$objResult
[
"name_type"
];?></div></td>
163.
<td><div align=
"center"
><?=
$objResult
[
"price_prd"
];?></div></td>
164.
<td align=
"right"
><div align=
"center"
><img src=
"photo/<?=$objResult["
photo_prd
"];?>"
width=
"40"
/></div></td>
165.
<td>[ <A HREF=
'search_view.php?id_prd=<?=$objResult["id_prd"];?>'
>แสดงรายละเอียด </A>] </div></td>
166.
</tr>
167.
<? }}?>
168.
</table>
169.
<br>
170.
Total <?=
$Num_Rows
;?> Record : <?=
$Num_Pages
;?> Page :
171.
<?
172.
if
(
$Prev_Page
)
173.
{
174.
echo
" <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> "
;
175.
}
176.
177.
for
(
$i
=1;
$i
<=
$Num_Pages
;
$i
++){
178.
if
(
$i
!=
$Page
)
179.
{
180.
echo
"[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]"
;
181.
}
182.
else
183.
{
184.
echo
"<b> $i </b>"
;
185.
}
186.
}
187.
if
(
$Page
!=
$Num_Pages
)
188.
{
189.
echo
" <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> "
;
190.
}
191.
192.
?>
193.
194.
</body>
195.
</html>