pruoccojr Posted November 19, 2013 Share Posted November 19, 2013 MySQL Database Version 5.0 Hello, I currently have a search form for my database with 4 input fields and 4 submit buttons which display results for Number, Customer, Contact, and Keyword: // Make connection to Database require("globals.php"); //this has all our configuration options. require_login(); //function called to make sure the user is logged in. $db = new DB(); //set up a new database connection $has_results = false; if(isset($_POST['submit'])) { //form posted. $where = array(); $form = array(); foreach($_POST as $key=>$value) { $form[$key] = $db->clean_input($value); } if(isset($form['bynumber']) && $form['bynumber']!="") { $where[] = " JobNumber = ".$form['bynumber']; } if(isset($form['bycustomer']) && $form['bycustomer']!="") { $where[] = "Customer like '%".$form['bycustomer']."%' "; } if(isset($form['bycontact']) && $form['bycontact']!="") { $where[] = "Contact like '%".$form['bycontact']."%' "; } if(isset($form['bykeyword']) && $form['bykeyword']!="") { $where[] = "JobInstruct like '%".$form['bykeyword']."%' "; } $sql = "SELECT * FROM OrderInfo"; if(count($where)>0) { $sql .= " WHERE ".implode(" OR ",$where); } $sql .= " ORDER BY JobNumber DESC"; $rs = $db->query($sql); if($db->num_rows($rs)>0) { $has_results = true; } } include(INCLUDE_PATH."/header.php"); //global header file <form autocomplete="off" action="search.php" method="post"> <h2>Number:</h2> <input type="text" class="search-field" name="bynumber" value="<?=@$form['bynumber']?>"> <input type="submit" name="submit" class="submitbutton" value=" "> <h2>Customer:</h2> <input type="text" class="search-field" name="bycustomer" value="<?=@$form['bycustomer']?>"> <input type="submit" name="submit" class="submitbutton" style="margin:0;" value=" "> <div style="clear:both; padding-bottom:18px;"></div> <h2>Contact:</h2> <input type="text" class="search-field" name="bycontact" value="<?=@$form['bycontact']?>"> <input type="submit" name="submit" class="submitbutton" value=" "> <h2>Keyword:</h2> <input type="text" class="search-field" name="bykeyword" value="<?=@$form['bykeyword']?>"> <input type="submit" name="submit" class="submitbutton" style="margin:0;" value=" "> <div style="clear:both; padding-bottom:18px;"></div> </form> What I would like to do is minimize the form by having 1 dropdown menu with the options being Number, Customer, Contact, and Keyword, and 1 textbox which would search for words within the chosen option. My issue is that this code (which is only part of a larger project) was written by a freelancer that we can no longer get in contact with and I don't really know much about writing PHP. I'm not asking anybody to do the work for me so I can take it and run, but I would be very grateful if somebody can walk me through the process so that I can learn for myself - assuming it's something simple enough to teach. Any help at all is greatly appreciated. Thank you Quote Link to comment https://forums.phpfreaks.com/topic/284076-search-form-with-dropdown-category-and-textbox/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.