PHP MySQL Full Text Search: Perform full text search on MySQL with autocorrect

Recommend this page to a friend!

Download .zip

Info

Example

Screenshots

View files (4)

Download .zip

Reputation

Support forum (2)

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 900		All time: 3,918 This week: 173

Version		License		PHP version		Categories
`full-text-search` 1.0		GNU General Publi...		5		PHP 5, Databases, Searching

Description Author

This class can perform full text searches on MySQL with auto-correct.

It takes a given keyword and performs a SQL query on a given MySQL database table field using full text search matching.

If the search returns no results, the class may fallback to pattern searching.

The class may optionally perform auto-correction of the search keyword using Felipe Ribeiro spell corrector class.

The class can also alter the MySQL table to add a full text search index to the field to be search. If necessary it may alter the table type to MyISAM in case the current table type does not support full text searching.

Recommendations

What is the best PHP auto correct spelling class?
I need search class that suggests available keyword in database

Innovation Award

December 2014
Number 5

Prize: One downloadable copy of CodeLobster Professional

Full text search is a way to perform searches on a database table text field providing results with a given matching accuracy level.

This class can help setting up MySQL database table indexes to make them ready to perform full text searches on given fields.

It can also execute queries to perform the actual full text searches on given table fields for given search keywords. When no results are returned, it falls back performing regular pattern based search.

Manuel Lemos