Jump to content


Photo

Search Form with Dropdown Category and Textbox


  • Please log in to reply
No replies to this topic

#1 pruoccojr

pruoccojr

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 19 November 2013 - 02:44 PM

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="&nbsp;">
	
	<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="&nbsp;">
	<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="&nbsp;">
	
	<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="&nbsp;">
	<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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com