PHP Classes

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-07-03 (10 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,573 All time: 2,381 This week: 1,110Up
Version License Categories  
sqlite_fulltextsearc 1.0GNU General Publi...Databases
Description Author  

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 Setec Astronomy
Name: Setec Astronomy <contact>
Classes: 20 packages by
Country: Italy Italy
Age: ???
All time rank: 141 in Italy Italy
Week rank: 81 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  
 0%Total:1,573All time:2,381
 This week:0This week:1,110Up