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

Did you know?Explore Trending and Topic pages for more stories like this.
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
No comments posted yet

Your Answer:

Login to answer
308 Like 52 Dislike
Previous forums Next forums
Other forums

If statement help please.
Hello on my site I have 2 content boxes. 1 is for the main content (which is the biggest one) and th

Functions Not Loading Into Div
I had some help doing some of this but what I'm trying to do is get my functions to retrieve its val

iMatch stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea

How do I give a developer access to a specific directory and nothing else?
I want to give a develop access to a specific directory and nothing else

I can give them an F

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

string to currency format
Hi guys...

Actually I chunk out some data from txtfile and one of the data contains amount va

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

Help With editting and deleting form
So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.png
This table

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash