PHP - Mysql - Search Function - Table

I have a kind of search and react on my site. The user can search for a number in a column as below

$search = mysqli_real_escape_string($link, $_POST["query"]);

$query = "SELECT * FROM $table[$i] WHERE oemnr LIKE '".$search."%' ORDER BY model";

 

The code works fine but I want to expand the function to get match for other numbers also. The oemnr column today can be 12345 which shows up if the user type 12.... 

I want to expand the oemnr column as

12345/03124/34713, numbers separated with / or another character.

If the user type 03... or 34... I want to find and show 12345 because it is on the same row and corresponds to the numbers on the same row. Is it possible to do in mysql? In php that kind of operation can be done with the explode function but I don't know how to use with mysql.

Edited February 14 by jigga

Need some help I have 2 tables in a database and I need to search the first table and use the results from that search, to search another table, can this be done? and if it can how would you recommend that I go about it?

Thanks For Your Help Guys! 

 The result pages is supposed to have  pagination like google  help me please

 

Can anyone post a generic update function to update mysql table.
The manual approach:

update $tablename
set $column1='a', $column2='b'
where $id=$value;

Hello

I have three tables

User

diysmps

usergroup


usergroupid is common in the three tables.

diysmps is joined on usergroup, so running this sql



SELECT
diysmps.name,
diysmps.email,
diysmps.sumbit,
diysmps.message,
diysmps.ID,
usergroup.title
FROM diysmps
INNER JOIN usergroup ON diysmps.usergroupid = usergroup.usergroupid
ORDER BY diysmps.ID DESC

see results i get in picture attached. the result (PENDIN REGISTRATION) is what i need to be updated WHEN the user register to the forums.

when the user register to the forums, an account with his EMAIL will be created into the (USER) table.

So, I need to look out for the email FROM (diysmps TABLE) into the user table _search user table for email from diysmps table_ and if found to update the USERGROUPID in (diysmps TABLE) withe the USERGROUPID from (USER) table (related to the email searched)

so, when user registers, status from PENDING REGISTRATION to REGISTERED will be shown

I know it looks complex for me, but thats how i can describe

Thanks all

Hi guys!

I want to improve the search function of a wordpress site with AliPlugin. The products shown are completely off topic, you have to be very accurate to get what you need, if you are too accurate of course, you will get nothing.

 

The site is: http://www.beta.cfcbazar.com

Its the site for testing.

 

Can anyone help me please?

I have been using this code which i found on here which I have gotten to work with my website but I would just like to know how I can make it so that when I click the search button it can take me to a new page which will show the results in a table.

Code: [Select]
<?php
// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT id, product_name, product_price, product_description FROM product WHERE ";
      
      // grab the search types.
      $types = array();
      $types[] = isset($_GET['name'])?"`product_name` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['price'])?"`product_price` LIKE '%{$searchTermDB}%'":'';
      $types[] = isset($_GET['description'])?"`product_description` LIKE '%{$searchTermDB}%'":'';
      
      $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
      
      if (count($types) < 1)
         $types[] = "`product_name` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked
      
          $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `product_name`"; // order by title.

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['product_name']}<br />{$row['product_price']}<br />{$row['product_description']}<br /><br />";
            $i++;
         }
      }
   }
}

<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="get" name="searchForm" id="searchForm">
    Search For:
    <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" />
    <br />
    <br />
    <input type="submit" name="submit" value="Search!" />
  </form>
  <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>
I would be very grateful if someone could help me to get this done.

Edit (KP): Next time, please use code tags.

Ok i have seen many  solutions for  using a search function to post onto webpage directly from the mysql db but my question is is there a way to seach  the results that were already outputted via a php query,  for instance i have a query that returns

1	MisFit_Kay1	811
2	sajoma	806
3	Atlfan	708
4	karlsbad70	633
5	Booo	570
6	MisFit_Mimi_shg	541
7	PRO_Viking	540
8	tm7_cryzal	540
9	TM7__mina	499
10	PRO_DRFRANK	488
11	PRO_FLAK	488
12	Mhoram	464
13	TM7__CEDAR	462
14	ProSultan	456
15	UBG_Steely1	450

but with lots more results  now what im hoping for is a point in a direction where i could add a search box that will  highlight the name   from the list provided .  any help will be appreciated
Edited by Justafriend, 20 October 2014 - 01:56 AM.

hi im just trying to do a search on a database and display results based on what the user selected:

form code:
Code: [Select]
html>
<body>
<form action="search.php" method="POST">

Type of property:
   <select name="Type_of_Property">
                            <option>Terraced</option>
<option>Detached</option>
<option>Semi-Detached</option>
<option>Bungalow</option>
<option>Flat </option>                     


</select>
 <p><input type="submit" value="Send Details" name="B1"></p>

</form>
php code:
Code: [Select]
<html>

<body>
<?php
error_reporting(E_ALL);


mysql_connect("localhost", "root") or die(mysql_error()); // makes a connection
mysql_select_db("estate_agents") or die('I cannot connect to the database because: ' . mysql_error()); //conects to the database

$result = mysql_query("SELECT * FROM properties WHERE Type_of_Property ='".$_POST['Type_of_Property']);


echo "<table border=1>\n";
echo "<tr><td>Address 1</td><td>Address 2</td><td>Postcode</td><td>Type of Property</td><td>Number of Bedrooms</td><td>Number of Bathrooms</td></tr>\n";
 
while ($row = mysql_fetch_row($result)) {


}
print  "Data base updated with: " .$_POST["Type_of_Property"] ;
?>

</body>
</html>
the propbelm im having is being able to display the results in the table in the while loop

any help is appreciated thank you

Hi,

im trying to do a search function that will search through the database
Examples : table game with id, name
                 I want to get the ID by searching with keywords
                 BUT my keywords is like 'battle field' and I search only 'battle'
                 How do I get battle field ID from the database with just 'battle' ?

Please help me out or show me tutorials.

thanks.

Hi,
I am trying to build a search function and so far I have it working with just one DB field but I need it to search for different fields.

This is my search form:

Code: [Select]
<form action="t_articulo_Results.php" method="get" name="SearchForm" id="SearchForm">
          <label>
            <input type="text" name="S_articulo_esp" id="S_articulo_esp" value="search" size="30" />
             <input type="hidden" name="Search" id="Search" value="Buscar" />
            </label>
          </form>
where the field "S_articulo_esp" is a text field to enter the search criteria.

This is the code on my results page inclung query:

Code: [Select]
<?php 

$MySearch_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search"]) && $_GET["Search"] != "")) {
  $MySearch = new FilterDef;
  $MySearch->initializeQueryBuilder("MYSQL","1");
  //keyword array declarations

  //comparison list additions
  $MySearch->addComparisonFromEdit("company_name","S_articulo_esp","AND","Includes",0);

  //save the query in a session variable
  if (1 == 1) {
    $_SESSION["MySearch_t_articulo_Results"]=$MySearch->whereClause;
  }
}
else     {
  $MySearch = new FilterDef;
  $MySearch->initializeQueryBuilder("MYSQL","1");
  //get the filter definition from a session variable
  if (1 == 1)     {
    if (isset($_SESSION["MySearch_t_articulo_Results"]) && $_SESSION["MySearch_t_articulo_Results"] != "")     {
      $MySearch->whereClause = $_SESSION["MySearch_t_articulo_Results"];
    }
    else     {
      $MySearch->whereClause = $MySearch_DefaultWhere;
    }
  }
  else     {
    $MySearch->whereClause = $MySearch_DefaultWhere;
  }
}
$MySearch->whereClause = str_replace("\\''", "''", $MySearch->whereClause);
$MySearchwhereClause = '';
?>


<?php
$maxRows_RecordSett_articulo = 10;
$pageNum_RecordSett_articulo = 0;
if (isset($_GET['pageNum_RecordSett_articulo'])) {
  $pageNum_RecordSett_articulo = $_GET['pageNum_RecordSett_articulo'];
}
$startRow_RecordSett_articulo = $pageNum_RecordSett_articulo * $maxRows_RecordSett_articulo;

mysql_select_db($database_MySQLconnect, $MySQLconnect);
$query_RecordSett_articulo = "SELECT id_cliente, company_name, cliente_calle, cliente_numero, cliente_local, cliente_poblacion, cliente_cp, cliente_pais, cliente_tel, cliente_fax, cliente_movil, cliente_personadecontacto, cliente_email, cliente_web FROM t_clientes ORDER BY company_name ASC";
setQueryBuilderSource($query_RecordSett_articulo,$WADbSearch1,false);
$query_limit_RecordSett_articulo = sprintf("%s LIMIT %d, %d", $query_RecordSett_articulo, $startRow_RecordSett_articulo, $maxRows_RecordSett_articulo);
$RecordSett_articulo = mysql_query($query_limit_RecordSett_articulo, $MySQLconnect) or die(mysql_error());
$row_RecordSett_articulo = mysql_fetch_assoc($RecordSett_articulo);

if (isset($_GET['totalRows_RecordSett_articulo'])) {
  $totalRows_RecordSett_articulo = $_GET['totalRows_RecordSett_articulo'];
} else {
  $all_RecordSett_articulo = mysql_query($query_RecordSett_articulo);
  $totalRows_RecordSett_articulo = mysql_num_rows($all_RecordSett_articulo);
}
$totalPages_RecordSett_articulo = ceil($totalRows_RecordSett_articulo/$maxRows_RecordSett_articulo)-1;
?>
please note this line
   
Code: [Select]
$MySearch->addComparisonFromEdit("company_name","S_articulo_esp","AND","Includes",0);//comparison list additions

because here is where I am getting confused . How can I add more fields to it?

Thanks

I was showing a friend what I've been working on, and as I watched him type in an entry to search - then not get a result that I know was indeed in the database I realized I needed to accommodate "user laziness."  He didn't use punctuation. So I'm trying to figure out how to make that a nonfactor in searches.

In other words, my database may have an entry called "St. Patrick's Cathedral"
If somebody types "st patricks cathedral" I want the result to still show up.

Here's what I'm using right now:

Code: [Select]
if(isset($_POST[submitted])) {
$item = $_REQUEST['find'];
$filter1 = trim($_POST['filter1']);
if ($filter1 == 'sci-names') {

$data = mysql_query("SELECT * FROM table WHERE CONCAT(taxonomic_genus,' ',scientific_name) LIKE '%$item%'");

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=346179.0

<script type="text/javascript">

function listBoxSearch(){
	
	var input =  document.getElementById('searchBox'),
        output = document.getElementById('listBoxF');
		
	if(input.value != ''){
		
		for (var i = 0; i < output.options.length; i++){
			
			if(output.options[i].text.substring(0, input.value.length).toUpperCase() == input.value.toUpperCase()){
				
				output.options[output.options.length] = new Option(output.options[i].innerHTML, output.options[i].text);
			
			}
		}
		
		
		if (output.options.length == 1) {
		    output.selectedIndex = 0;
		}
		 
   }

}
	
</script>

It dosen`t work. It should work like this[DEMO in attached filed] Attached Files  listbox_with_keybord_search.htm   7.9KB   3 downloads

Won't let me type in this box more then 1 line  .  See Post 3,4

Thanks