PHP Classes

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

Recommend this page to a friend!

  Author Author  
Picture of Er. Rochak Chauhan
Name: Er. Rochak Chauhan is available for providing paid consulting. Contact Er. Rochak Chauhan .
Classes: 53 packages by
Country: India India
Age: 44
All time rank: 21 in India India
Week rank: 93 Down8 in India India Down
Innovation award
Innovation award
Nominee: 14x

Winner: 3x

  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of Er. Rochak Chauhan  >  PHP Search MySQL Tables  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: PHP Search MySQL Tables
Base name: search-mysql-tables
Description: Search for text in all tables of a MySQL database
Version: 1
PHP version: 4
License: Free For Educational Use
All time users: 3183 users
All time rank: 1115
Week users: 0 users
Week rank: 209 Equal
  Groups   Rate classes User ratings   Applications   Files Files  

Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Utilities and Tools General purpose tools to simplify software development View top rated classes
Group folder image Searching Search engines, crawling and indexing View top rated classes


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

  Innovation Award  
PHP Programming Innovation award winner
May 2010

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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (66%) Sufficient (66%) - Not sure (50%) - - Not sure (44%) 2784
Month: Not yet rated by the users

  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.

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

Install with Composer Install with Composer - Download Download all files: search-mysql-tables.tar.gz
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.