search engine

Hello,

Do you guy's and girls have some links for me where i can find some info
about a php search engine that searches mysql dbase and web-site. i only
need some examples not complete script's because i already have them and
they need to much configuration to match our site...

Thanks in advance

G

Spam sucks wrote:
> Hello,
>
> Do you guy's and girls have some links for me where i can find some info
> about a php search engine that searches mysql dbase and web-site. i only
> need some examples not complete script's because i already have them and
> they need to much configuration to match our site...
>
> Thanks in advance
>
> G
>
>

MySQL has a "full-text" indexing mechanism that you could try, though
I've never used it; I seem to remember it having a number of
limitations. Also, if you ever move to a different database, you likely
won't have that option.

Another methodology is to build a db table that is essentially a
dictionary of all of the words in the fields you want to search, along
with a corresponding link to the document, and maybe some notion of how
often that word shows up in the document, for ranking purposes. You then
create a cron job to re-index once a day or so...
so, the table records look something like

word page_ids count
baker 4,7,52 1,2,1
dozen 3,7,47 3,2,3


I built a system like that and it seems to work pretty well.

hth
Kurt Milligan