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: 816 This week: 1All time: 4,141 This week: 497Up
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: 28
All time rank: 17136 in Nigeria Nigeria
Week rank: 227 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

Downloadfull-text-search-2014-12-18.zip 40KB
Downloadfull-text-search-2014-12-18.tar.gz 39KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:816
This week:1
All time:4,141
This week:497Up
User Comments (1)
Thats a very good and useful class ;-)
4 years ago (José Filipe Lopes Santos)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.