PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2005-12-06 (10 years ago) RSS 2.0 feedStarStarStarStar 66%Total: 9,342 All time: 155 This week: 923Down
Version License Categories
dbsearch 1.0.0GNU General Publi...Databases, Searching
Description Author

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

Screenshots  
  • 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  
 0%
Total:9,342
This week:0
All time:155
This week:923Down
User Ratings User Comments (2)
 All time
Utility:81%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:85%StarStarStarStarStar
Examples:86%StarStarStarStarStar
Tests:-
Videos:-
Overall:66%StarStarStarStar
Rank:604
 
nice
6 days ago (muabshir)
80%StarStarStarStarStar
Hi.
7 years ago (Alexander Farennikov)
27%StarStar