PHP MySQL full text search

Asked By Emma Marie 10 points N/A Posted on - 10/17/2013

Hello Experts,

I need to do PHP MySQL full text search in a large database that is constantly changing. Please suggest me the best MySQL built in method to search this kind of databases. Waiting to hear from experts.

Thanks, Emma Marie

• Status: Open
• Question Views: 1016
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PHP

Answered By Alexander Jose 0 points N/A #189506

PHP MySQL full text search

I would suggest you to do your full-text search by downloading Sphinx. It is a very fast means and plugs directly to MySQL and PostgreSQL, MSSQL, ODBC and XML pipe. It handles some major sites like ljseek.com (120+ GB database) and rss-spider.com. It is available for Linux, Windows and Mac OS. It provides not only full text search but many other categories. Download sphinx from internet, Install and enjoy your search.

 

Another option is ZEND framework which belongs to Lucene class. It is 100% PHP server and provides with Lucene Binary Compatible Index.

About Alexander Jose

Questions
0

Answers
100

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/18/2013
• Question Category: PHP