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
pagination numbering pattern
Hello,I have following code which works great for pagination. but i have small issue now.Now the output is coming like this Quotemypage.php?page=2I want it like thisQuotemypage.php/2code-Code:
Opening Multiple Files/Links in Order.
I want to open links in order/one-by-one and check each for a specific string.Example: If i open CL, search for ads pertaining to video games. Returns 20 results. I grab these links. Now i want to
Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g
I am investigating how to run a Java stored procedure in multithread mode.I know that if I change the program to be multithreaded, the Database runs it fine, but it will not show any concurrency
Search function
I am looking for some guidance from the experts.I am trying to create a search function. It will only be searching one table. The search criteria consists of two drop down menus. Each menu lists
php forms and database navigatio
Hello,I'm new to php and i'd like to post the following.I have written code to get records from a DB and i need one record at a time to be filled in a form i created. Then the next record should be
Output Full URL of Current Page
Let's say I am currently viewing a dynamic page: http://www.mydomain.com/directory/index.php?type=flowers I want this URL to be output on the page, but not including the end parameters.
Why use interfaces in PHP (OOP)
I am learning OOP in PHP and its been a pretty good learning experience so far. What I didn't understand at all is interfaces. I understand the implications of multiple inheritance, and interface is
Find current logon time
Hi,
Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line 21Heres the code:Code: <body
HTML Viewer HIDE scrollbar
How can I disable scrollbars in a HTML Viewer control? I can't hide them. Even i have enough space but i am getting this grey inactive scrollbar....