Top 6 free Ajax & PHP Powered MySQL Table Editor / Viewer

 PHP and MySQL are one of the most used serverside language-database duo. I’m pretty sure if you are reading this article you are well aware of that, so coming to the point, in this article i’m going to help you find your perfect PHP powered and AJAX juiced MySQL table viewer for your next web development project or your already implemented website.

Why do we even need Data Grids when we have PhpMyAdmin ?

PhpMyAdmin is MySQL db management software created in PHP, its used for creating DB’s, editing, managing, etc but it is suitable for a programmer who has the knowledge of the PhpMyAdmin’s advanced user interface and of-course MySQL itself, but imagine how difficult will it be for a normal user to even understand the layout and structure of PhpMyAdmin just to check or edit his sites users DB.

In other hand data-grid’s are small scripts which can be integrated in any part of your admin panel or your main site which facilitates tabular and arranged view of data in ANY way you want it to be. For example a pre-created datagrid may be integrated in admin panel for managing the users of a site by the admin. Its Easy, Fast and facilitates better user interface.

OK, So how’s will this roundup help me?

In this roundup i will cover up 15 php powered grid viewer and editor both free and premium, with a narrow overview of their pros and cones. You can use this scripts in creating a better dataview for your next site, or even still a complete site based on it, for example, imagine you want to create a addressbook site, you can use this datagrids and add proper query to only show the addresses added by the respective users, you can even edit permission’s to give them ability to add new address, names etc. Imagination is your Fuel !

                                                                Grid

https://www.nitobi.com/blogs-sub/andre/index_php/2006/09/21/grid-32-is-gonna-rock-you

Pros:

• Rich Ajax Interface
• Integrates with DreamWeaver
• Cross Platform Support
• Highly Extendable

Cons :

• Knowledge of Ajax and XML http request required for integration
• No inbuilt search functionality

slGrid

Pros:

• Easy Integration
• Selective Non-Editable Fields
• Export To XLS
• Filters Support

Cons :

• No Integrated Search Functionality

PHPMyDataGrid

https://www.gurusistemas.com/documentation.php

Pros:

• Very Easy Integration
• Numerous Examples
• Inline Editing
• Image and Bar Chart Support

Cons :

• No Multiple Field Sorting
• No Several Grids Sorting

FlexiGrid

https://groups.google.com/g/flexigrid

https://github.com/paulopmx/Flexigrid/

Pros:

• Multi Platform Support
• Open Source
• Superb Interface
• Created Using JQuery

Cons :

• Non Editable
• No Multi Coloumn Sorting

Rico 2.0

https://openrico.sourceforge.net/examples/index.html

https://openrico.sourceforge.net/examples/welcome_zh.html

Pros:

• Multi Platform Support
• Multi DB Support
• Opensource
• Very Extensive and Complex Functions Support

Cons :

• Difficult to implement

Data Grid

https://web.archive.org/web/20120202164509/http://www.bluefrog.ca/2008/12/eyedatagrid-control/

Pros:

• Easy Implementation
• Ability To Display Image
• Sorting

Cons :

• PHP 5 Only
• In Integrated Editing Codes

Author’s Choice

I’m sure you’d like to know my opinion on this data-grids, personally i always favor open-source counterparts, in free sections mt favorites are Rico 2.0 and Nitobi, both are little hassle to implement but i like how customizable they are, they have most functions of the paid counterparts, moreover as they are free i can even edit their codes to match my needs and use them on any project without any extra cost.

In paid section i’d choose SQL Maestro just for the sake that its easy to implement, secure and has vast options.

For those of you needing only viewer with no editing options i recommend free version of SQL Maestro or Flexi Grid.

Thanks for reading and hope i could help you a little bit on this topic.