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 Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 42%Total: 3,189 All time: 1,117 This week: 455Up
Version License PHP version Categories
search-mysql-tables 1Free For Educatio...4Databases, Tools, Searching
Description 

Author

Er. Rochak Chauhan

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 is available for providing paid consulting. Contact Er. Rochak Chauhan .
Classes: 54 packages by
Country: India India
Age: 46
All time rank: 21 in India India
Week rank: 22 Down2 in India India Down

Level 5 StarStarStarStarStar

 Innovation award
Innovation award
Nominee: 15x

Winner: 4x

Recommendations

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

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsearch-mysql-tables-2010-05-02.zip 2KB
Downloadsearch-mysql-tables-2010-05-02.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,189
This week:0
All time:1,117
This week:455Up
 User Ratings  
 
 All time
Utility:62%StarStarStarStar
Consistency:62%StarStarStarStar
Documentation:-
Examples:50%StarStarStar
Tests:-
Videos:-
Overall:42%StarStarStar
Rank:3662
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.