NYCPHP Meetup

[Peter Sawczynec]

Okay so here's how this shaped up, in case this info can ever help you too.

I have MySQL Cookbook and the solid explanation there about full-text
searching is real good, 
including (very importantly) the config tweak on how to get MySQL full text
search to include 3-letter words.


But, the zend tutorial pointed out by Craig Thomas jumps right in quite on
the money:
a) builds a quick form, 
b) introduces and uses Boolean full text searching too, 
c) also offers relevancy in the result sets, 
http://www.zend.com/zend/tut/tutorial-ferrara1.php


This other tutorial (though based on another pre-existing code project),
also shows very nicely:
a) how to splice in a list of words to ignore, 
b) word weighting, 
c) how to apply word stems, 
http://www.symfony-project.com/askeet/21



Errata:

Neat explanation.
http://www.devarticles.com/c/a/MySQL/Getting-Started-With-MySQLs-Full-Text-S
earch-Capabilities/


A super looking "does it all" search engine PHP project:
http://us2.php.net/mnogosearch


And a search tools compendium:
http://www.searchtools.com/tools/tools.html


Gracias y buenos noches.




-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of tedd
Sent: Thursday, July 20, 2006 12:47 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] PHP/SQL Full Text Search on MySQL


At 10:39 AM -0400 7/20/06, Peter Sawczynec wrote:
>Has anyone come across a simple PHP/SQL class or basic script that 
>handles MySQL 4.x full text searching and maybe even returns results 
>with relevancy?
> 
>Or maybe you've seen an excellent tutorial on this topic?
> 
>It does not have to be a big deal, I don't need a spider or document 
>searching, just full text searching on a full text indexed MySQL table.
> 
>You know, just asking...
> 
>Warmest regards,
> 
>Peter Sawczynec,

Peter:

An excellent write-up and example is shown in "MySQL Cookbook" by Paul
DuBois re O'Reilly. You can get via Amazon for $22.99 used.

I'm currently discovering what that is about myself.

tedd
-- 
----------------------------------------------------------------------------
--------
http://sperling.com  http://ancientstones.com  http://earthstones.com
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php