Multiple Keywords Search

phpprogrammer

Dear All,

How can we do the searching for multiple key words

any one provides the script or suggest good url

regards
bvsureshbabu

Yamakazi

And on what are you searching? Be more specific please.

phpprogrammer

Dear Friend,

I want to search mysql database using the key wordsand display the results like google.com site

regards
bvsureshbabu

Yamakazi

Ah, then my friend search www.mysql.org for the full text index option. MySQL will create an index for faster searching and only of the index is build you can create a SQL statemant as this:

$sSQL = "select Nid as NID, MATCH (Title, InhoudIndex) AGAINST('$Against' IN BOOLEAN MODE) as score from news where MATCH (Titel, InhoudIndex) AGAINST('$Against' IN BOOLEAN MODE)";

What you do is create a variable against wich contains what you are searching for instance you want to learn about full text indexing so you type: 'mysql full text index'

These words are matched against the full text indexed columns title and inhoudindex. If one of those tables contains one of those words The NID will be returned as well as a score.

Draw backs:

the scores are in the form of 1.55478458 so you have to do some test to create a descent working % score.

Only words longer then 3 characters are index (standard setting)

If more then 50% of you DB is a hit mysql won't return ANY record. This isn't actually a draw back but just a remark.

Hope that helps.

phpprogrammer

Dear Friends,

I found the solution

CODE

<?php
$searchstring=$_GET["searchstring"];
$searchstring=trim($searchstring);
$searchstring=chop($searchstring);
$arrsearchstring=explode(" ",$searchstring);

$search_new_string='';

 for($g=0;$g<count($arrsearchstring);$g++)
  {
    $search_new_string=$search_new_string." Name like '%".$arrsearchstring[$g]."%' or";
   }

$search_new_string=substr($search_new_string,0,-2);

$query="select * from TBL_INGREDIENTS where". $search_new_string;
$result=mysql_query($query);

regards,
bvsureshbabu

ppowell

Originally posted by Yamakazi
Ah, then my friend search www.mysql.org for the full text index option. MySQL will create an index for faster searching and only of the index is build you can create a SQL statemant as this:
$sSQL = "select Nid as NID, MATCH (Title, InhoudIndex) AGAINST('$Against' IN BOOLEAN MODE) as score from news where MATCH (Titel, InhoudIndex) AGAINST('$Against' IN BOOLEAN MODE)";
What you do is create a variable against wich contains what you are searching for instance you want to learn about full text indexing so you type: 'mysql full text index'

These words are matched against the full text indexed columns title and inhoudindex. If one of those tables contains one of those words The NID will be returned as well as a score.

Draw backs:

the scores are in the form of 1.55478458 so you have to do some test to create a descent working % score.

Only words longer then 3 characters are index (standard setting)

If more then 50% of you DB is a hit mysql won't return ANY record. This isn't actually a draw back but just a remark.

Hope that helps. [/B]

This is all fine and dandy, and I'm using it now.

But... this will not work if you need to search more than one keyword. Say for instance your search is for the following:

'test', 'blah', 'tree', 'BlatantlyDifferentKeyword'

And you need to search for any of these. The WHERE MATCH AGAINST criteria according to www.mysql.com only allows for a single keyword (or keyword boolean) match. How about more than one?

Phil

Yamakazi

A rough solution is to do somthing like this:

$aExploded = explode(" ", $txtCrit);
$i = 0;
$j = 0;
while($i < $aExploded){
  $crit = $aExploded[$i];
  //Do match against with the crit here

 //loop over results
  $total[$j] = $returnValue;
  $j += 1;
 //End loop

 $i += 1;
 }

/Filter out any doubles :)

Happy coding