Needle in a Haystack

Comprehensive Search on MYSQL Database.

select * from anywhereindb where anyfield like %search_text%

Sometime we need to find out a small piece of string in big Database. Like where is the configuration is saved, or where is Jon's Date of birth is saved. This code is search all the tables and all the rows and columns in a MYSQL Database. The code is written in PHP. For faster result, we are only searching in the varchar field. (if anyone needs to search in other field, he can just comment the varchar selecting part.)

This code is written to help out the web developers as tool.

How To

Install

Download the anywhereindb.php
Drop it in your htdocs or www folder, and run it in your browser
Give your Database connection information
It's ready for work, search any string

Working

Collapse All Result

This will hide all the search result, and show how many results are there in each table

Expand All Result

This will show all the search result.

SQL

This is will show/hide SQL query for the particular tables result.

Result

This is will show/hide the particular tables result.

Helpful for whom

searching a data in the database
understanding a new system
quickly find out a setting string in the database

History

In my office Blueliner Bangladesh, Aktar vai always needed a code to find out a string from any where from his database. in other words, search all the tables and all the rows of DB for that search string. So, Mahbub Vai asked me to write a code to the job.

The code was done long time ago. but i did not shared it with anyone. Today, I have published the code in google code. It needs a good documentation.

Russel vai, gave the text based UI a nice look.(i asked him not to use any image and stuff) Initial project was Aktar vai's idea and without help of Mahbub vai, Miraz vai it might not be done.

Thanks goes all of my co-worker in Blueliner Bangladesh for this project.

Enjoy the code. please report bugs.

Download count of older version was 1883 Download !

---- Thank You. Nafis Ahmad