PHP switch function help

Posted on 16th Feb 2014 07:03 pm by admin

Hi, I am trying to create a search function for a directory website. On the search function on html page I have a dropdown menu. From this you can select one OF 3 options - shoes, handbags, shoes and handbags. I have a php process form page where it takes this infor before runninng a query in the sql database.

My question is that I would like the one option to have multiple values - when user clicks shoes, the query will search for a field containing shoes (this bit is fine) but also I want it to select another field to search for a value - this field will depend upon the what option the user picked in the question. The problem being, that unless i rename the fields in the table from lets say, Sbrand to Shoes and Hbrand to handbags i'm not sure how to action

What I need is that if value on option was shoe then I need it linked to pick from Sbrand Now I think that I can use a switch function but the current issue is that I must have it in the wrong place as when I tried it as per below code, it appears that the search is looking for a field called the option value so the switch is not working. Perhaps I need to move the switch function from the php process page to the html page but I’m not sure

Any help much appreciated

HTML code………… this works on a method=”get”

<select name="type">
<option value="none">-- Please Select --</option>
<option value="Shoes">Shoes</option>
<option value="Handbags">Handbags</option>
<option value="Shoes and Handbags">Shoes and Handbags</option>
</select>



Here’s the PHP code

$search_type=$db->escapeString($_GET['type']);
switch ($type){
case "Shoes":
echo "Sbrand";
break;
case "Handbags":
echo "Hbrand";
break;
case "Shoes and Handbags":
echo "SHbrand";
break;
}



$result=$db->query("SELECT Sbrand, Hbrand, SHbrand, SB, Retailer, Address, Town, County, Postcode, Postcode_code, Phone, Website FROM database WHERE SB LIKE 'type' AND $search_type LIKE '%$searchterm%'");




Any help much appreciated as i am new to this

Your Answer:

Login to answer

Other forums

TimeZoneOffset
Hello,

Please i need your help. I have a system that users can use to punch in and out. This

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

A problem with my GD class
Hello,

I created a nice (and simple for now) GD class.
The problem is , it works great on

ASP.NET Validation Event Cycle
Hi,
I have asp button as follow:

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type

Revoking alter any table from a schema
Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL oper

Simpler method of getting variables from mysql
Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

How to disable direct access to a file
Suppose I've 2 Files. 1.php & 2.php

I don't want anybody to access 2.php directly fr

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q