PHP Classes

PHP Search MySQL Tables: Search for text in all tables of a MySQL database

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 44%Total: 3,187 All time: 1,113 This week: 124Up
Version License PHP version Categories
search-mysql-tables 1Free For Educatio...4Databases, Utilities and Tools, Searc...
Description 

Author

This class can be used to search for text in all tables of MySQL databases.

It can retrieve the list of tables and fields of a one or more MySQL databases.

The class can execute queries to perform searches for a given keyword in any of the fields of all records of all tables of the specified databases.

Innovation Award
PHP Programming Innovation award winner
May 2010
Winner


Prize: One license of ScriptCase Enterprise edition
Sometimes you need to find where in a database it was stored a certain text but you do not know which fields of what tables may contain that text.

This class implements a brute force solution to search for a given text in all fields of all tables of a MySQL database.

Manuel Lemos
Picture of Er. Rochak Chauhan
  Performance   Level  
Name: Er. Rochak Chauhan <contact>
Classes: 54 packages by
Country: India India
Innovation award
Innovation award
Nominee: 15x

Winner: 3x

Recommendations

search string from whole databse mysql
would like to search in whole database a string

  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example Script
Plain text file PhpSearchMysqlTables.inc.php Class 100

 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,187
This week:0
All time:1,113
This week:124Up
 User Ratings  
 
 All time
Utility:66%StarStarStarStar
Consistency:66%StarStarStarStar
Documentation:-
Examples:50%StarStarStar
Tests:-
Videos:-
Overall:44%StarStarStar
Rank:2792