DaniWeb Forum Index > Web Development > PHP

Search with multiple search terms used

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Sep 2009

Posts: 11

Reputation: empoor is an unknown quantity at this point

Solved Threads: 0

empoor

Offline

Newbie Poster

Search with multiple search terms used

Sep 17th, 2009

Hi. I tried looking for this problem on Google, and found a lot, but nothing that actually seems to work. I basically have a search script that works fine when using one keyword, but when one uses more than that, it returns every single row per keyword. So a search for "hello kitty" doesn't look for "hello" and "kitty", but for "hello" and then another time for "kitty".

I know there's something wrong with my code, but, what? And how can I solve this issue.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
// get the search variable from URL
$var = @$_GET['q'] ;
// trim whitespace from the stored variable
$trimmed = trim($var);  
// separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);
 
// build SQL Query for each keyword entered 
foreach ($trimmed_array as $trimm)
{
 
	$query = "SELECT * FROM (articles LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE text LIKE '%$trimm%' ORDER BY issue DESC" ;
 
	// and then the queries and everything; with which nothing's wrong
 
}
// get the search variable from URL
$var = @$_GET['q'] ;
// trim whitespace from the stored variable
$trimmed = trim($var);  
// separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);

// build SQL Query for each keyword entered 
foreach ($trimmed_array as $trimm)
{
	
	$query = "SELECT * FROM (articles LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE text LIKE '%$trimm%' ORDER BY issue DESC" ;

	// and then the queries and everything; with which nothing's wrong

}

Can someone help me?

Last edited by empoor; Sep 17th, 2009 at 5:16 pm. Reason: clarification

Cordialement,

Remy L. Overkempe
Martian Prince

•

Join Date: Apr 2005

Posts: 1,403

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 225

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Re: Search with multiple search terms used

Sep 17th, 2009

Explode on spaces and use ORs for the extra terms. http://php.net/explode

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.

•

Join Date: Sep 2009

Posts: 11

Reputation: empoor is an unknown quantity at this point

Solved Threads: 0

empoor

Offline

Newbie Poster

Re: Search with multiple search terms used

Sep 18th, 2009

•

Originally Posted by ShawnCplus

Explode on spaces and use ORs for the extra terms. http://php.net/explode

I'm already using explode to separate terms. And shouldn't it be "AND", 'cause I want the results to match all the results. It's basically already doing an "OR" search, which results in duplicate search results showing.

Cordialement,

Remy L. Overkempe
Martian Prince

•

Join Date: Sep 2009

Posts: 11

Reputation: empoor is an unknown quantity at this point

Solved Threads: 0

empoor

Offline

Newbie Poster

Re: Search with multiple search terms used

Sep 19th, 2009

I have solved the issue myself by trying to fix things with experimentation.

My first problem was that the code I used to remove duplicate entries from the search array was basically looping twice. So, I edited the source to keep it from looping twice.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
	do
		{
			$adid_array[] = $row['page_id'];
		}
 
	while($row = mysql_fetch_array($numresults));
	do
		{
			$adid_array[] = $row['page_id'];
		}
	
	while($row = mysql_fetch_array($numresults));

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
	$tmparr = array_unique($adid_array); 
	$i = 0; 
	foreach ($tmparr as $newarr_v)
		{ 
			$newarr[$i] = $newarr_v; 
			$i++; 
		}
	$tmparr = array_unique($adid_array); 
	$i = 0; 
	foreach ($tmparr as $newarr_v)
		{ 
			$newarr[$i] = $newarr_v; 
			$i++; 
		}

And then I use newarr to execute the search query (with foreach).

Secondly, because this is my first experience with building a search page, I used stock code and didn't notice that it was erroneously building a query for each keyword entered, instead of a query that incorporates all keywords (if multiple). So I removed

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
foreach ($search_array as $search_keyword)
foreach ($search_array as $search_keyword)

, and wrote a little code to separate each keyword with AND.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$var = addslashes(htmlspecialchars($_GET['q'])) ;
// trim whitespace from the stored variable
$trimmed = trim($var);  
// separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);
// count keywords
$trimm_total = count($trimmed_array);
$i = 0;
$searchstring = '';
 
// looping to get the search string
foreach ($trimmed_array as $trimm)
{ 
	if ($i != 0 and $i != $wordcount)
	{ 
		$searchstring .= " AND ";
	} 
 
	$searchstring .= "text LIKE '%$trimm%' OR page_title LIKE '%$trimm%' OR author LIKE '%$trimm%'"; 
 
	// incrementing the value 
	$i = $i + 1; 
}
$var = addslashes(htmlspecialchars($_GET['q'])) ;
// trim whitespace from the stored variable
$trimmed = trim($var);  
// separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);
// count keywords
$trimm_total = count($trimmed_array);
$i = 0;
$searchstring = '';

// looping to get the search string
foreach ($trimmed_array as $trimm)
{ 
	if ($i != 0 and $i != $wordcount)
	{ 
		$searchstring .= " AND ";
	} 

	$searchstring .= "text LIKE '%$trimm%' OR page_title LIKE '%$trimm%' OR author LIKE '%$trimm%'"; 
	
	// incrementing the value 
	$i = $i + 1; 
}

And now it finally works.

Last edited by empoor; Sep 19th, 2009 at 5:29 am. Reason: clarification

Cordialement,

Remy L. Overkempe
Martian Prince

•

Join Date: Dec 2008

Posts: 37

Reputation: dasatti is an unknown quantity at this point

Solved Threads: 2

dasatti

Offline

Light Poster

Re: Search with multiple search terms used

Sep 19th, 2009

Try this

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
// get the search variable from URL
$var = @$_GET['q'] ;
// trim whitespace from the stored variable
$trimmed = trim($var);  
// separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);
 
// build SQL Query for each keyword entered
$query = "SELECT * FROM (articles LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE";
 
$first = true;
foreach ($trimmed_array as $trimm)
{
                if(!$first)
	{
	    $query . = " AND ";
	}
                 else
                 {
                     $first = false;
                 }
 
 
	$query = $query . " text LIKE '%$trimm%' " ;
 
	// and then the queries and everything; with which nothing's wrong
 
}
$query = $query. " ORDER BY issue DESC";
// get the search variable from URL
$var = @$_GET['q'] ;
// trim whitespace from the stored variable
$trimmed = trim($var);  
// separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);

// build SQL Query for each keyword entered
$query = "SELECT * FROM (articles LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE";
 
$first = true;
foreach ($trimmed_array as $trimm)
{
                if(!$first)
	{
	    $query . = " AND ";
	}
                 else
                 {
                     $first = false;
                 }
	
	 
	$query = $query . " text LIKE '%$trimm%' " ;
 
	// and then the queries and everything; with which nothing's wrong
 
}
$query = $query. " ORDER BY issue DESC";

Last edited by dasatti; Sep 19th, 2009 at 7:38 am.

maSteR of aLL, jAck oF NoNe

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes