PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2014-12-18 (4 years ago) RSS 2.0 feedNot enough user ratingsTotal: 833 This week: 1All time: 4,098 This week: 359Up
Version License PHP version Categories
full-text-search 1.0GNU General Publi...5PHP 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
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
Name: Taiwo Peace <contact>
Classes: 3 packages by
Country: Nigeria Nigeria
Age: 29
All time rank: 16986 in Nigeria Nigeria
Week rank: 323 Up4 in Nigeria Nigeria Up
Innovation award
Innovation award
Nominee: 1x

 

Screenshots  
  • 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  
 0%
Total:833
This week:1
All time:4,098
This week:359Up
User Comments (1)
Thats a very good and useful class ;-)
4 years ago (Josť Filipe Lopes Santos)
70%StarStarStarStar