PHP - Listbox Search Function Help

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?

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.

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

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

This topic has been moved to Third Party PHP Scripts.

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

So I have a basic search form that goes through and does a mySQL like '%$sanitizedInput%' to column in the table.

The problem I have is that if I have two rows, one with a value "green" and the second "blue", and I do a search for "green", it shows the green result, if I do a search for "blue", it shows the blue result, but if i do a search for "green blue" it returns no results.

Any ideas on how to fix this?

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%'");

Hey guys for a project im making a search filter function. Only one filter seems to be working and that's the genre filter :(

 

This is my code:

	function filterFilms(){
	global $conn;
	$loop = 0;
	if(isset($_POST['titel']) && !empty($_POST['titel'])){
	$titel = sanatize($_POST['titel']);
	}
	 
	if(isset($_POST['genre']) && !empty($_POST['genre'])){
	$genre = sanatize($_POST['genre']);
	}
	 
	$sql = "SELECT TOP 20 *
	From
	Movie Inner Join
	Movie_Director On Movie_Director.movie_id = Movie.movie_id
	Inner Join
	Movie_Genre On Movie_Genre.movie_id = Movie.movie_id
	Inner Join
	Person On Movie_Director.person_id = Person.person_id";
	 
	if(isset($titel) && !empty($titel)){
	if($loop == 0){
	$sql .= " WHERE ( title = ':titel' OR title like ':titel')";
	$loop++;
	}
	else{
	$sql .= " AND ( title = ':titel' OR title like ':titel')";
	}
	}
	 
	if(isset($genre) && !empty($genre)){
	if($loop == 0){
	$sql .= " WHERE genre_name = :genre";
	$loop++;
	}
	else{
	$sql .= " AND genre_name = :genre";
	}
	}
	$query = $conn->prepare($sql);
	if(isset($titel) && !empty($titel)){
	$query->bindValue('titel', $titel,PDO::PARAM_STR);
	}
	 
	if(isset($genre) && !empty($genre)){
	$query->bindParam('genre', $genre,PDO::PARAM_STR);
	}
	$query->execute();
	$rows = $query->fetchAll();
	return $rows;
	}
	

 

Anyone any idea??

 

I' stuck with writing function for searching replaced numbers and would really appreciate if someone can tell me what I'm doing wrong.   My table structure looks like:

CREATE TABLE servis.zamjene_brojeva (
  id INT(11) NOT NULL AUTO_INCREMENT,
  vrijeme TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  pocetni_broj VARCHAR(55) DEFAULT NULL,
  zamjenski_broj VARCHAR(55) DEFAULT NULL,
  glavni_broj VARCHAR(55) DEFAULT NULL,
  postoji_zamjena INT(1) DEFAULT NULL,
  PRIMARY KEY (id)
)

My function looks like this:

//funkcija za traženje zamjene brojeva
function zamjena_broja($kataloski_broj){
    
    //Traženje zamjenskog broja
    $upit_zamjena = "SELECT pocetni_broj, zamjenski_broj, glavni_broj
                     FROM zamjene_brojeva
                     WHERE glavni_broj = '$kataloski_broj'";
    $rezultat_zamjena = mysql_query($upit_zamjena) or die (mysql_error());
    $row = mysql_fetch_array($rezultat_zamjena);
        $kataloski_broj = $row["zamjenski_broj"];
        
    $broj_zamjena = mysql_num_rows($rezultat_zamjena);
    
        return $kataloski_broj;
    
    //Traženje druge zamjene broja
    if ($broj_zamjena <> 0) {
        
            $upit_zamjena = "SELECT pocetni_broj, zamjenski_broj, glavni_broj
                             FROM zamjene_brojeva
                             WHERE pocetni_broj = '$kataloski_broj'";
            $rezultat_zamjena = mysql_query($upit_zamjena) or die (mysql_error());
            $broj_zamjena2 = mysql_num_rows($rezultat_zamjena);
            $row2 = mysql_fetch_array($rezultat_zamjena);
                $kataloski_broj = $row2["zamjenski_broj"];
            
                return $kataloski_broj;
            
            //Traženje treće zamjene
            if ($broj_zamjena2 <> 0) {
                
                     $upit_zamjena = "SELECT pocetni_broj, zamjenski_broj, glavni_broj
                                      FROM zamjene_brojeva
                                      WHERE pocetni_broj = '$kataloski_broj'";
                     $rezultat_zamjena = mysql_query($upit_zamjena) or die (mysql_error());
                     $broj_zamjena3 = mysql_num_rows($rezultat_zamjena);
                     $row3 = mysql_fetch_array($rezultat_zamjena);
                        $kataloski_broj = $row3["zamjenski_broj"];
            
                         return $kataloski_broj;
                
            }
        
    }

}

In pocetni_broj is old number and in glavni_broj is new number. But it can happen that number in glavni_broj is old and I need to search in pocetni_broj to see if there is even newer number and it can happen 5 or 6 times like that.   I need to find all the numbers that are connected, but I'm not getting that. What am I doing wrong?

Looking for help with a small task for my weather station website.
Has already created a MySQL database where values are entered every hour.

Want to see on my website a table with current temperature or other types of measurements for each hour.
The idea is that users select a "Year", "Month" and Which info they want displayed, which is then displayed in an HTML table.
Info that can be chosen from is e.g. temperature, mm rain, air pressure, mm.

A small fee is usually given.

the website:
Se the page

Examples of desired solutions:
http:Sample 1
Sample 2

 

I'm trying to build a search function that will search all columns in a table. Here is what I've got:

Code: [Select]
if (isset($_POST['submitted'])) {
$q = "SELECT * FROM children ";

if(isset($_POST['query'])) {
$q .= "WHERE ";

$all = "SELECT * FROM children WHERE 1";
$r_all = mysqli_query($dbc, $all);

while ($field = $r_all->fetch_field()) { // Get field headers for building query
$f_name = "{$field->name} LIKE {$_POST['query']},:"; // Build query with search string
$fn = explode(":",$f_name); // Need to convert $f_name to an array but this does not convert it to a single array but multiple arrays

$q .= implode("OR", $fn); // Need to insert OR for the db query

} // End while ($field = $r_all->fetch_field())

} // End if(isset($_POST['query']))

} // End if (isset($_POST['submitted']))

The explode function is what is not working for me. It gives me this (sam is the search string I entered into the form):

Code: [Select]
Array ( [0] => child_id LIKE sam, [1] => ) Array ( [0] => first_name LIKE sam, [1] => ) Array ( [0] => second_name LIKE sam, [1] => ) Array ( [0] => last_name1 LIKE sam, [1] => ) Array ( [0] => last_name2 LIKE sam, [1] => ) Array ( [0] => gender LIKE sam, [1] => ) Array ( [0] => dob LIKE sam, [1] => )

so instead of getting one array with each string being a value I get multiple arrays. Any ideas?

//get the search variable from the FORM$function_keywords = mysql_real_escape_string($_POST['function_keywords']);//trim whitespace from the stored variable$trimmed = trim($function_keywords);//separate key-phrases into keywords$trimmed_keywords = explode(" ",$trimmed);// Build SQL Query for each keyword enteredforeach ($trimmed_keywords as $trimm){// MySQL "MATCH" is used for full-text searching.//this code is ebv weird , should check out soon!$query = "SELECT * ,   MATCH (function_description) AGAINST ('".$trimm."') AS score   FROM table_name   WHERE MATCH (function_description) AGAINST ('+".$trimm."')   ORDER BY score DESC   "; // Execute the query to  get number of rows that contain search kewords $results=mysql_query ($query,$connection); $row=""; $row =$row . mysql_fetch_array($results, MYSQL_BOTH);} $row_num=mysql_num_rows ($row); if($row_num < 1){    redirect("welcome.php?search=fail"); } else if ($row_num > 1){ ?> <html> <head> <title>Search results</title> </head> <body> <?php  foreach($row as $row_result){ echo "function name : {$row_result['function_name']} --- function Description : {$row_result['function_description']}<br/><br/>"; }?> </body> </html>()

IS there an error on the SQL syntax ? or its about ?  :

Code: [Select]
$results=mysql_query ($query,$connection);
 $row="";
 $row =$row . mysql_fetch_array($results, MYSQL_BOTH);
}
 $row_num=mysql_num_rows ($row);

optionsT Does not show any results.Dont know where is the problem.

<script type="text/javascript" language="javascript">

function AddItemInList(fromLeftToRight, isAll){
	var list1  = document.getElementById('listBoxF');
	var list2  = document.getElementById('listBoxT');
		if(Boolean(fromLeftToRight) == true){
			MoveItems(list1,list2,isAll);
		}else{
			MoveItems(list2,list1,isAll);
		}
		return false;
}
function MoveItems(listFrom, listTo, isAll){
	var toBeRemoved = "";
	if(listFrom.options.length > 0){
		for (i=0; i<listFrom.length; i++){
			if (listFrom.options[i].selected || (isAll == true)){
				if(Exist(listTo, listFrom.options[i].value) == 0){
					listTo[listTo.length] = new Option(listFrom.options[i].text, listFrom.options[i].value, true);
					toBeRemoved = toBeRemoved + listFrom.options[i].value + ';';
				}
			}
		}
	ClearSelection(listTo);
	RemoveFromList(listFrom, toBeRemoved);
	}else{
		alert('Unable to Move Items. List is Empty!');
	}
}
function RemoveFromList(listFrom, items){
	var toBeRemoved = items.split(';');
	for (var i=0; i < toBeRemoved.length; i++){
		for (var j = 0; j < listFrom.length; j++){
			if (listFrom.options[j] != null && listFrom.options[j].value == toBeRemoved[i]){
				listFrom.options[j] = null;
			}
		}
	}
}
function ClearSelection(list){
	list.selectedIndex = -1;
}
function Exist(list, value){
	var flag = 0;
	for (var i=0; i < list.length; i++){
		if (list.options[i].value == value){
			flag = 1;
			break;
		}
	}
	return flag;
}

</script>
    
<?php

$opt = isset($_POST['optionsT']) ? $_POST['optionsT'] : '';


if(!empty($_POST['submit'])){
	print $opt;
}

print"  
<form method=\"POST\">
<table style=\"width:100%\">
  	<tr valign=\"top\">
    	<td>Options</td>
    	<td>
        	<select multiple size=\"5\" name=\"optionsF\" id=\"listBoxF\" style=\"width:350px\">
        		<option value=\"1\">1</option>
        		<option value=\"2\">2</option>
        		<option value=\"3\">3</option>
        		<option value=\"4\">4</option>
        	</select>
      		<div align=\"center\">
        		<input type=\"button\" onclick=\"return AddItemInList(true,true)\" value=\"+ All\">
       	 		<input type=\"button\" onclick=\"return AddItemInList(true,false)\" value=\"+\">
        		<input type=\"button\" onclick=\"return AddItemInList(false,false)\" value=\"-\">
        		<input type=\"button\" onclick=\"return AddItemInList(false,true)\" value=\"- All\">
      		</div>
      		<select multiple size=\"5\" name=\"optionsT[]\" id=\"listBoxT\" style=\"width:350px\">
      		</select>
    	</td>
  	</tr>
	<tr>
    	<td></td>
    	<td><input type=\"submit\" name=\"submit\" value=\"Submit\"></td>
  	</tr>
</table>
</form>";
?>