帮助搜索页面 [英] 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屋！
