PHP Classes

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

Recommend this page to a friend!
  Info   View files Example   Screenshots Screenshots   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 906 All time: 3,906 This week: 135Up
Version License PHP version Categories
full-text-search 1.0GNU General Publi...5PHP 5, Databases, Searching


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.


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

Innovation Award
PHP Programming Innovation award nominee
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
Picture of Taiwo Peace
  Performance   Level  
Name: Taiwo Peace is available for providing paid consulting. Contact Taiwo Peace .
Classes: 3 packages by
Country: Nigeria Nigeria
Age: 29
All time rank: 16556 in Nigeria Nigeria
Week rank: 410 Up12 in Nigeria Nigeria Down
Innovation award
Innovation award
Nominee: 1x

  • search.JPG
  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example Usage
Plain text file fulltextsearch.php Class Main Class
Plain text file SpellCorrector.php Class Spellcorrector class
Accessible without login Plain text file test.sql Test test sql

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:3,906
This week:135Up
User Comments (1)
Thats a very good and useful class ;-)
8 years ago (Josť Filipe Lopes Santos)