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 !

Free DataGrids

Nitobi Ajax DataGrid

nitobi

Download | Demo

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

slgrid

Download | Demo

Pros:

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

Cons :

  • No Integrated Search Functionality

PHPMyDataGrid

slgrid

Download | Demo

Pros:

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

Cons :

  • No Multiple Field Sorting
  • No Several Grids Sorting

FlexiGrid

slgrid

Download | Demo

Pros:

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

Cons :

  • Non Editable
  • No Multi Coloumn Sorting

Rico 2.0

slgrid

Download | Demo

Pros:

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

Cons :

  • Difficult to implement

Data Grid

slgrid

Download | Demo

Pros:

  • Easy Implementation
  • Ability To Display Image
  • Sorting

Cons :

  • PHP 5 Only
  • In Integrated Editing Codes

Open Crypt DataGrid

slgrid

Download | Demo

Pros:

  • Inbuilt Search
  • Sorting
  • Supports Older Browsers
  • Open Source

Cons :

  • Non Editable

Premium DataGrids

Seven Scripts Table Editor

nitobi

Buy ($25) | Demo

Pros:

  • Rich Ajax Interface
  • Inline Editing
  • Large DB Support

Cons :

  • No Sorting Capabilities
  • No Import/Export Options Available

SQLMaestro Feature Matrix

nitobi

Buy ($69) | Demo

Pros:

  • Wizard Based Implementation
  • High Security
  • Supports Multiple Databases
  • Master Detail Presentation
  • Many Export Options

Cons :

  • No Inline Editing

MySQL Ajax Editor

nitobi

Buy ($19) | Demo

Pros:

  • File Upload
  • Easy Setup
  • Complex Multiple Joins

Cons :

  • No Inline Editing
  • No Import/Export Options Available

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.