PHP/MySQL Search Engine - Recommendations

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
nyfael
Forum Commoner
Posts: 32
Joined: Thu Sep 21, 2006 2:28 am

PHP/MySQL Search Engine - Recommendations

Post by nyfael »

Hi,

I've started to build my own search engine and realized reinventing the wheel wasn't the smartest idea. I want a very good Search Engine, not something basic - I was wondering what ones were out there and what were recommended.

Preferrably something that uses RegExp, as you have much more control than using LIKE in MySQL.

Thanks,
Kerry
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Integrate Google.
nyfael
Forum Commoner
Posts: 32
Joined: Thu Sep 21, 2006 2:28 am

Post by nyfael »

They have a script that I can use to integrate to search my database?

-Kerry
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Re: PHP/MySQL Search Engine - Recommendations

Post by Chris Corbyn »

nyfael wrote:Preferrably something that uses RegExp, as you have much more control than using LIKE in MySQL.
AFAIK, google won't read your database no. It will read your web pages though.

As for using LIKE. That's not a very quick way to search in MySQL. You probably want a FULLTEXT search if your table type allows it. Also, for the record MySQL has REGEXP support ;)
nyfael
Forum Commoner
Posts: 32
Joined: Thu Sep 21, 2006 2:28 am

Post by nyfael »

I know, I want a premade search engine that can read my database (MySQL) that uses RegExp, mine uses RegExps right now, but I could seriously contiue improving this for months if not years to get up to some of the best ones today... which is a waste of time and money.

FULLTEXT search - how do I check if I have that functionality?

Thanks,
Kerry
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

nyfael wrote:I know, I want a premade search engine that can read my database (MySQL) that uses RegExp, mine uses RegExps right now, but I could seriously contiue improving this for months if not years to get up to some of the best ones today... which is a waste of time and money.

FULLTEXT search - how do I check if I have that functionality?

Thanks,
Kerry
I'm not aware of any premade search engines that you can use but I guess there will be some search APIs available.

As for FULLTEXT, read the manual ;)

http://dev.mysql.com/doc/refman/5.0/en/ ... earch.html
MySQL Manual wrote:Full-text indexes can be used only with MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.
nyfael
Forum Commoner
Posts: 32
Joined: Thu Sep 21, 2006 2:28 am

Post by nyfael »

You don't think there are any out there? There must be, so many sites have them, I'm making an article directory site, and there are many out there that have this functionality, and I highly doubt their programmers each made their own.

Thanks for that! Very useful, I've started reading over it.

-Kerry
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

If you want to search your database, it is going to be highly specific. I doubt there are any generic database search engines out there. Creating a fulltext search engine is actually quite simple, give it a try.
nyfael
Forum Commoner
Posts: 32
Joined: Thu Sep 21, 2006 2:28 am

Post by nyfael »

It doesn't have to be specific at all, I just would like to be able to specify the source of what its searching through, in this case, tables in my database.

I haven't been able to figure out if my MySQL supports FULLTEXT (I am using a MyISAM table). Still trying to understand that.

-Kerry
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

nyfael wrote:I haven't been able to figure out if my MySQL supports FULLTEXT (I am using a MyISAM table). Still trying to understand that.
This was answered in a previous post :?
nyfael
Forum Commoner
Posts: 32
Joined: Thu Sep 21, 2006 2:28 am

Post by nyfael »

I know - haven't finished reading it. Hence trying :)

-Kerry
Post Reply