[PHP] Homebrew fulltext search function (help)

[Jason Morehouse]

Hello,
I'm trying to make up for the lack full text searching in sqlite by 
passing the search off to php with sqlite_create_function.  The parsing 
part works fine, but I'm a little lost with the scoring, if anyone 
perhaps a little better @ math than I am, may be of assistance!

The parsing code below, basically allows you to use a php function 
within a sqlite call.  This pases matched content to a function, where 
the function needs to pass back a score:

sqlite_create_function($sDB, 'fulltext', 'fulltext_step',2);
function fulltext_step($title, $content) {
$words = explode(' ', strtolower('php books'));
$content = explode(' ',strtolower($content));
$content = array_intersect($content,$words);
foreach($content as $wordpos = $word) {
   print $wordpos - $wordbr;
}
}
sqlite_create_function($sDB, 'fulltext', 'fulltext_step',1);
$rs = sqlite_query($sDB,select title fulltext(content) score from page 
where content like '%php%books%' order by score);

while($data = sqlite_fetch_array($rs)) {
   print $data[score] $data[title]br;
}
So basically... the fulltext step builds and array, of how many times a 
word is matched, and at what word position (broken into an array for 
each word)... eg:

array('php'=2,'php'=30,'php'=55)
array('books'=3,'books'=130);
The word php is at position 2, and the word books is at position 3... 
and so on.

What is the best way to return a single score for this page?
It's a bit confusing I suppose, but thanks!
As a side, on a 90meg text table, the parsing function above runs in 
about  0.061858177185059 ms... mysql does in about 0.0039310455322266 
ms.  I'm fine by that.

-Jason
--
Jason Morehouse
Vendorama - Create your own online store
http://www.vendorama.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Homebrew fulltext search function (help)

[Richard Lynch]

Jason Morehouse wrote:
 within a sqlite call.  This pases matched content to a function, where
 the function needs to pass back a score:

 sqlite_create_function($sDB, 'fulltext', 'fulltext_step',2);

 function fulltext_step($title, $content) {
  $words = explode(' ', strtolower('php books'));

   $words = explode(' ' , strtolower($title));

  $content = explode(' ',strtolower($content));
  $content = array_intersect($content,$words);
  foreach($content as $wordpos = $word) {
 print $wordpos - $wordbr;
  }

return count($content);

 }

That's a crude first take.

You could also add mega-points for, say, stristr($title, $content) for an
exact match, or more points for proximity of $word within $content (which
you'd need to do a different algorithm than above) or...

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php