帮助搜索页面 [英] help with a search page
问题描述
以下页面每次只返回搜索框。香港专业教育学院尚未尝试用b $ b代码进行文本搜索,但我希望它可以过滤掉
类别,但它只是没有显示任何内容。任何想法'的任何1? TIA
< body bgcolor ="#8C999B">
<?php
$ for = $ _GET [''for''];
$ catagory = $ _GET [''catagory''];
?>
< div align = center>
< form action ="<?php $ PHP_SELF?>"方法= QUOT; GET"> < br>< table
bgcolor ="#FFF8D7" cellpadding = 6>
< tr> < TD> < / TD> < / TR> < TR> < TD> < div align = center>搜索:
< / div>< / td> < TD> < div align = center> Catagory:< / div>< / td> < / td>
< / tr> < TR> < td>
< INPUT name = for value =<?php echo(" $ for"); ?>>
< / td> < td>
< SELECT NAME = catagory SIZE = 1>
< OPTION SELECTED>搜索所有Catagories< OPTION>花卉
创作
< OPTION>装饰照明
< OPTION>厨具&陶器
< OPTION> Fancy Goods&家具
< / SELECT>
< / td> < td>
< INPUT TYPE =提交VALUE ="搜索">
< / td>
< /表格>
< tr> < TD> < / TD> < / tr>
< / table>
< / div>
<?php if(empty($ _ GET [ ''catagory''])){退出; }
$ search_catagory = $ _GET [''catagory'']; $ search_for = $ _GET [''for''];
$ dbcnx = @mysql_connect(" a"," b"," c"); $ select =
@mysql_select_db(" houseproudlancs_co_uk1");
switch($ search_catagory){
case" Search所有Catagories":
$ filter_catagory =" *" ;
休息;
case" Floral Creations":
$ filter_catagory =" floral";
休息;
案例装饰照明:
$ filter_catagory =" lighting";
休息;
caseKitchenware&陶器:
$ filter_catagory =" kitchen" ;;
break;
case" Fancy Goods&家具":
$ filter_catagory =" furniture" ;;
break;
默认值:
echo(" ;< P>过滤器类别没有匹配任何内容< / P>"); echo
(" $ search_catagory");
echo(" $ filter_catagory");
break;
}
$ command =" SELECT * FROM stock WHERE 1 AND''catagory''=
\" $ filter_catagory \" ORDER BY`id`" ;; $ qresult = mysql_query($ command)
或die(mysql_error()); echo("< center>< table width = 80%
cellpadding = 5>"); $ tablebgcolor =" #FFF8D7" ;;
while($ row = mysql_fetch_array($ qresult)){
if($ tablebgcolor =="# FFF8D7"){//黄色
$ tablebgcolor ="#C5C8FF" ;; //蓝色
}其他{
$ tablebgcolor ="#FFF8D7" ;;
}?>
>
< tr>< td> < table border = 0 cellspacing = 3 width = 100%bgcolor =<?php
echo(" $ tablebgcolor"); ?>> < TR>< TD> <表> < tr>
< td>< pre>名称:< / pre>< / td> < td>< b><?php echo($ row
[" name"]); ?>< / B个< / TD>< / TR>< TR> < td>< pre>说明:
< / pre>< / td> < td><?php echo($ row [" description"]); ?>
< / td>< / tr>< tr> < td>< pre> Catagory:< / pre>< / td> < td><?php echo
($ row [" catagory"]); ?> < / TD>< / TR>< TR> < td>< pre>价格:
£< / pre>< / td> < td><?php echo($ row [" price"]); ?>
< / td>< / tr>< tr> < td>< pre> P& P:£< / pre>< / td> < td><?php echo
($ row [" pandp"]); ?> < / td>< / tr>< tr>
<?php $ quantity = $ row [" quantity"];
if($ quantity !=" 0"){?>
< td>< pre>数量:< / pre>< / td> < td><?php echo($ row
[" quantity"]); ?> < / td>< / tr>< tr><?php}?>
< td>< pre>产品ID:< / pre>< / td> ; < TD> <?php echo($ row
[" id"]); ?> < / td>< / tr>< tr>< td>
<?php if($ quantity ==" 0"){?>
< td>< b> < font color =#DD0000>暂时缺货
< / b>< / font>< / tr>< tr>
<?php}?>
< / td>< / tr>< / table>
< / td>< td width = 30%>
<?php $ pictureid = $ row [" id"]; ?>
<?php $ picturepath =" ./ images /" 。 $ pictureid。 " .JPG英寸; ?>
<?php
if(file_exists($ picturepath)){
echo("< div align = \\ \\ n \ n \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ '图片
产品''>< / a>< font size = 2>< br>点击图片查看完整
尺寸A新窗口< / font>< / div>");
} else {
echo("< div align = \" center \ ">< img src = \" /images/nopic.png\"
height = 200 alt =''没有可用图片''>< / a> < font
size = 2>< br>对不起,没有可用的图片
商品< / font>< / div>");
}
?>
< / td>< / tr>< / table>< / td>< / tr>
<?php}?>
< / table>< / center>
the page below returns just the search box everytime. ive not attempted to
code the text search yet, but i want it to beable to filter out the
category''s, but its just not showing any. any idea''s any1? TIA
<body bgcolor="#8C999B">
<?php
$for = $_GET[''for''];
$catagory = $_GET[''catagory''];
?>
<div align=center>
<form action="<?php $PHP_SELF ?>" method="GET"> <br><table
bgcolor="#FFF8D7" cellpadding=6>
<tr> <td> </td> </tr> <tr> <td> <div align=center> Search For:
</div></td> <td> <div align=center> Catagory: </div></td> </td>
</tr> <tr> <td>
<INPUT name=for value=<?php echo ("$for"); ?>>
</td> <td>
<SELECT NAME=catagory SIZE=1>
<OPTION SELECTED>Search All Catagories <OPTION>Floral
Creations
<OPTION>Decorative Lighting
<OPTION>Kitchenware & Crockery
<OPTION>Fancy Goods & Furniture
</SELECT>
</td> <td>
<INPUT TYPE=submit VALUE="Search">
</td>
</form>
<tr> <td> </td> </tr>
</table>
</div>
<?php if (empty($_GET[''catagory''])) { exit; }
$search_catagory = $_GET[''catagory'']; $search_for = $_GET[''for''];
$dbcnx = @mysql_connect("a", "b", "c"); $select =
@mysql_select_db("houseproudlancs_co_uk1");
switch ($search_catagory) {
case "Search All Catagories":
$filter_catagory = "*" ;
break;
case "Floral Creations":
$filter_catagory = "floral";
break;
case "Decorative Lighting":
$filter_catagory = "lighting";
break;
case "Kitchenware & Crockery":
$filter_catagory = "kitchenware";
break;
case "Fancy Goods & Furniture":
$filter_catagory = "furniture";
break;
default:
echo ("<P> Filter Catagory Didn''t Match Anything </P>"); echo
("$search_catagory");
echo ("$filter_catagory");
break;
}
$command = "SELECT * FROM stock WHERE 1 AND ''catagory'' =
\"$filter_catagory\" ORDER BY `id`"; $qresult = mysql_query($command)
or die(mysql_error()); echo ("<center><table width=80%
cellpadding=5>"); $tablebgcolor = "#FFF8D7";
while ($row = mysql_fetch_array($qresult)) {
if ($tablebgcolor == "#FFF8D7"){ //yellow
$tablebgcolor = "#C5C8FF"; //blue
} else {
$tablebgcolor = "#FFF8D7";
} ?>
<tr ><td> <table border=0 cellspacing=3 width=100% bgcolor=<?php
echo ("$tablebgcolor"); ?>> <tr><td> <table> <tr>
<td><pre>Name: </pre></td> <td><b><?php echo ($row
["name"]); ?></b> </td></tr><tr> <td><pre>Description:
</pre></td> <td><?php echo ($row ["description"]); ?>
</td></tr><tr> <td><pre>Catagory: </pre></td> <td><?php echo
($row ["catagory"]); ?> </td></tr><tr> <td><pre>Price:
£</pre></td> <td><?php echo ($row ["price"]); ?>
</td></tr><tr> <td><pre>P&P: £</pre></td> <td><?php echo
($row ["pandp"]); ?> </td></tr><tr>
<?php $quantity = $row ["quantity"];
if ($quantity != "0") { ?>
<td><pre>Quantity: </pre></td> <td><?php echo ($row
["quantity"]); ?> </td></tr><tr><?php } ?>
<td><pre>Product ID: </pre></td> <td> <?php echo ($row
["id"]); ?> </td></tr><tr><td>
<?php if ($quantity == "0") { ?>
<td><b> <font color=#DD0000> Temporarily Out Of Stock
</b></font></tr><tr>
<?php } ?>
</td></tr></table>
</td><td width=30%>
<?php $pictureid = $row ["id"]; ?>
<?php $picturepath = "./images/" . $pictureid . ".jpg"; ?>
<?php
if (file_exists($picturepath)) {
echo ("<div align=\"center\"><a href=\"$picturepath\"
target=LargeImage><img src=$picturepath height=200 alt=''Image
Of Product''></a><font size=2><br>Click The Image To See It Full
Size In A New Window</font></div>");
} else {
echo ("<div align=\"center\"><img src=\"/images/nopic.png\"
height=200 alt=''No Picture Available''></a><font
size=2><br>Sorry, There Is No Picture Available For This
Item</font></div>");
}
?>
</td></tr></table></td></tr>
<?php } ?>
</table></center>
推荐答案
for =
_GET [''for''];
_GET[''for''];
catagory =
catagory =
这篇关于帮助搜索页面的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!