PHP Classes

Database Search: Search for words and phrases in a a MySQL table

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 64%Total: 9,410 All time: 158 This week: 488Down
Version License Categories
dbsearch 1.0.0GNU General Publi...Databases, Searching


This class can be used to search for words and phrases in text fields of a MySQL database table.

It can generate a Web search form with an input field to enter the search text, a submit button and radio buttons to let the user tell whether the search should find records with all the words or at least one of them. The form text and presentation style is configurable with CSS.

The class can perform the search for the specified text with prior cleanup to avoid security exploits. The searched text is stored in a session variable so the user can be reminded of the last search.

The search can treat words separately or as phrases when the user encloses the words in double quotes.

The search results are returned in an array that contains a list of distinct records that matched the searched text.

The table name and the table fields to be searched and the fields to be returned as result of the search are configurable.

Picture of Tomasz Wilk
Name: Tomasz Wilk <contact>
Classes: 1 package by
Country: Poland Poland
Age: 44
All time rank: 2622 in Poland Poland
Week rank: 286 Down9 in Poland Poland Down

  • dbsrch.jpg
  Files folder image Files  
File Role Description
Plain text file DatabaseSearch.php Class DatabaseSearch class definition
Plain text file DatabaseSearchDocumentation.txt Doc. Short manual
Plain text file DbSrchExample.php Example How to use this class.

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:158
This week:488Down
User Ratings User Comments (2)
 All time
7 years ago (muabshir)
14 years ago (Alexander Farennikov)