PHP - Moved: 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?

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?

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

<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

This topic has been moved to Miscellaneous.

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

This topic has been moved to Ajax Help.

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

This topic has been moved to Miscellaneous.

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

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to MySQL Help.

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

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?

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

 

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??