PHP Classes

SQLite Full Text Search: Add Full Text Search SQL commands to SQLite

Recommend this page to a friend!
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,598 All time: 2,460 This week: 455Up
Version License Categories
sqlite_fulltextsearc 1.0GNU General Publi...Databases


The class implements a User Defined Function (UDF) that adds full text search SQL commands to SQLite.

This User Defined Function allows to execute a simple full text search queries against the text fields of SQLite database tables.

Innovation Award
PHP Programming Innovation award nominee
June 2005
Number 6

Prize: One copy of the Maguma Workbench
SQLite is a library that can be embedded in applications to make it work as a database management system.

PHP 5 comes with the SQLite library as a built-in extension. The current versions allow developers to write user defined functions (UDF) to implement new SQLite SQL commands that can be used immediately in any SQL queries.

This class takes advantages of this possibility to implement the necessary SQLite SQL commands to provide full text search support.

Manuel Lemos
Picture of Filippo Toso
Name: Filippo Toso <contact>
Classes: 20 packages by
Country: Italy Italy
Age: 44
All time rank: 151 in Italy Italy
Week rank: 38 Down2 in Italy Italy Down
Innovation award
Innovation award
Nominee: 5x

  Files folder image Files  
File Role Description
Accessible without login Plain text file sqlite_fulltextsearch.class.php Class sqlite_fulltextsearch Class file
Accessible without login Plain text file sqlite_fulltextsearch.sample.php Example sqlite_fulltextsearch Sample File
Accessible without login Plain text file sqlite_fulltextsearchex.class.php Class Extended class with exponential word prominence calculation

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:2,460
This week:455Up