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 (11 years ago) RSS 2.0 feedStarStarStarStar 66%Total: 9,348 All time: 156 This week: 781Down
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.

Name: Tomasz Wilk <contact>
Classes: 1 package by
Country: Poland Poland
Age: 37
All time rank: 2532 in Poland Poland
Week rank: 1198 Down34 in Poland Poland Down

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,348
This week:0
All time:156
This week:781Down
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:609
 
nice
1 month ago (muabshir)
80%StarStarStarStarStar
Hi.
7 years ago (Alexander Farennikov)
27%StarStar