gokyon: MySQL Database Navigation and Pagination

Wednesday, June 20, 2012

MySQL Database Navigation and Pagination

PHP Scripts - MySQL Database Navigation and Pagination - CodeCanyon

MySQL Database Navigation and Pagination his title this type of PHPScripts/DatabaseAbstractions This time I will review,made by tmworks, PHPScripts/DatabaseAbstractions is sold at a price of $12 in CodeCanyon.

MySQL Database Navigation and Pagination - CodeCanyon Item for Sale

csv // database // export // mysql // navigation // pagination // query // sql // sql editor // web console // web database //

Created	17 March 10
Last Update	20 August 10
Compatible Browsers	IE7, IE8, IE9, Firefox, Safari, Opera, Chrome
Software Version	PHP 5.3, MySQL 5.x, jQuery
Software Framework	CodeIgniter
Files Included	JavaScript JS, HTML, CSS, PHP, Layered PNG

More Info...MySQL Database Naviga ..

MySQL Database Navigation and Pagination

Introduction

If you are working with hosting MySQL databases, and pick up data from them frequently, this script may make your life easy working with them.

navigate and paginate to your databases tables;
Filter table data on the fly without coding SQL ;
export table data(may contains filter conditions) to csv etc. format;
SQL Editor helps you fire queries from database and export the resultset;
Web based MySQL shell emulator for the command-enthusiast;
download, uncompress and use it. no configuration needed.

This is a drag-drop to use script. Just download the zip and uncompress it to your web directory, than start to use.

This script will populate all databases with your account, you can choose to hide some database by chaning the configuration.

Setting IP whitelist

In most cases, you just want to allow accessing the item at some ips(at home or at work), in this case, please configure the whitelist. All ip addresses not in the whitelist will be denied to access the service. Please go to the installation directory, and open the application/config/config.php file, and find the following line:

$config[‘white_list’]=; i.e. Edit it to $config[‘white_list’]=’192.168.0.1-192.168.0.24;211.157.2.99’;’‘

you may have known, only 192.168.0.1 ~ 192.168.0.24 and 211.157.2.99 allowed to access the service.