Re: Advanced search scripts

Well, for this example, you could use mySQL, but really, I would be looking to utilise this on any database. Personally, I don't think this would be database dependent (unless you have other ideas). Adam On Wednesday, October 9, 2002, at 08:46 PM, John W. Holmes wrote:

What database are you using? ---John Holmes...

-----Original Message----- From: Adam Royle [mailto:ifunk@myrealbox.com] Sent: Wednesday, October 09, 2002 2:09 AM To: php-db@lists.php.net Subject: [PHP-DB] Advanced search scripts I was wondering if anyone has some resources (links or scripts) on 'advanced site searches'. Something that is similar to the way regular search engines process requests. ie. "phrase or two" word +required -"not included" Also, returning details of that search, say for example returning 10

words

before and 10 words after and displaying it in search results. The

ability

to search similar words (eg. ignoring punctuation) would be cool

aswell.

I am interested in this for database (all text fields), and also

searching

text files on filesystem. Now, I'm not trying to recreate Google or anything, and this is just

for

my own research (at this time), but I eventually would like to be able

to

create a smarter site searching engine. Can anyone give suggestions? or any links to tutorials (or books) I have used regex a little bit before, but not in PHP (only ASP and JavaScript). Adam