PHP Classes

phpMyDataGrid - AJAX Enabled Datagrid: Edit MySQL data in a table using AJAX for updates

Recommend this page to a friend!
  Info   View files Example   Screenshots Screenshots   View files View files (42)   DownloadInstall with Composer Download .zip   Reputation   Support forum (73)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 69%Total: 25,630 This week: 1All time: 21 This week: 108Down
Version License PHP version Categories
phpmydatagrid 1.0.2BSD License4.3HTML, Databases, AJAX


This class can be used to Edit MySQL data in a table using AJAX for updates.

It can connect to a MySQL database directly or using ADODB and executes a query to retrieve data from a given table.

The MySQL table fields to display in the data grid table columns are configurable. The data from certain columns be displayed as images, totals or values calculated according to a given formula.

The data may also be displayed as bar charts.

The listing may have links to sort, add, edit, delete, search and view individual table records. The listing colors may be alternated and the rows may be highlighted when the user drags the mouse pointer over them. The links may be displayed with given icon images. The presentation of several aspects may be defined using CSS styles.

The record rows may be selected using respective form checkbox inputs.

A form may be presented to search for records with user defined values in given columns.

The records being listed or edited in place may be updated using AJAX request to avoid page reloading in any type of browser.

It may also show links or a form select input to go to the other pages when the listing split into multiple pages.

The text messages shown with the listing can be displayed in multiple languages. Currently English, Dutch, German, Spanish, French, Italian, Czech and Portuguese are built-in supported idioms.


HTML5/PHP5.5 compliant datagrid
PHP5.5 compliant datagrid

Picture of Gustavo Arcila
Name: Gustavo Arcila <contact>
Classes: 3 packages by
Country: Colombia Colombia
Age: 48
All time rank: 391 in Colombia Colombia
Week rank: 114 Down1 in Colombia Colombia Equal
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

  • sample_ajax_edition.png
  • sample_barchart.png
  • sample_barchart_images.png
  • sample_datagrid.png
  • sample_edit.png
  • sample_search_by.png
  Files folder image Files  
File Role Description
Files folder imagecss (1 file)
Files folder imageimages (19 files)
Files folder imagejs (1 file)
Files folder imagedocumentation (1 file)
Plain text file discount_code.txt Data Discount codes for ultimate version
Plain text file phpmydatagrid.class.php Class Main Class
Plain text file sample1.php Example Sample of use
Plain text file sample10.php Example Sample of use
Plain text file sample11.php Example Sample of use
Plain text file sample12.php Example Sample of use
Plain text file sample13.php Example Sample of use
Plain text file sample14.php Example Sample of use
Plain text file sample15.php Example Sample of use
Plain text file sample2.php Example Sample of use
Plain text file sample3.php Example Sample of use
Plain text file sample4.php Example Sample of use
Plain text file sample5.php Example Sample of use
Plain text file sample6.php Example Sample of use
Plain text file sample7.php Example Sample of use
Plain text file sample8.php Example Sample of use
Plain text file sample9.php Example Sample of use
Plain text file test.sql Data Data file
Plain text file ru_utf8.php Aux. UTF 8 file with russian translation
Plain text file ru_utf8_instructions.txt Doc. Instructions to russian

  Files folder image Files  /  css  
File Role Description
  Plain text file dgstyle.css Data Styles file

  Files folder image Files  /  images  
File Role Description
  Image file add.png Icon Icon Image
  Image file ajax.gif Icon Animated Image
  Image file asc.png Icon Icon Image
  Image file cancel.png Icon Icon Image
  Image file close.png Icon Icon Image
  Image file desc.png Icon Icon Image
  Image file down.png Icon Icon Image
  Image file down_off.png Icon Icon Image
  Image file edit.png Icon Icon Image
  Image file erase.png Icon Icon Image
  Image file locate.png Icon Icon Image
  Image file minidown.png Icon Image Icon
  Image file miniup.png Icon Image Icon
  Image file poweredby.png Icon Image Icon
  Image file save.png Icon Icon Image
  Image file search.png Icon icon image
  Image file up.png Icon Image Icon
  Image file up_off.png Icon Image Icon
  Image file view.png Icon Image Icon

  Files folder image Files  /  js  
File Role Description
  Plain text file dgscripts.js Data JavaScripts

  Files folder image Files  /  documentation  
File Role Description
  Plain text file documentation.txt Data Documentation

 Version Control Unique User Downloads Download Rankings  
This week:1
All time:21
This week:108Down
User Ratings User Comments (15)
 All time
very good
11 years ago (savvy)
Very Good and usefull class.
11 years ago (Federico Franco Jaramillo)
Excelente, aunque alguna funcionalidad mas no estaria mal.
12 years ago (Tony L. Requena)
Great,owsome work done.
13 years ago (ChandrakantH)
13 years ago (utkarsh13)
A valuable code to solve the huge problem of displaying tabbe...
14 years ago (Mauricio Lorca)
great work
14 years ago (arnol)
thanks for posting this article also sharing this class code.
14 years ago (clifton)
excellent support, clear and easy to manage,
14 years ago (Maria Parr)
he ralizado las pruebas, sin embargo, al momento de registrar...
14 years ago (marcos)
Nice for programmer
14 years ago (Yan Vedo Dirgantara Kondera)
Package muy interesante.
14 years ago (Jacques SAINT-PIERRE)
not truely cross browser compatible.
15 years ago (Josh Glasser)
This a great package .
15 years ago (koko)
Best AJAX enabled DB class
15 years ago (Nicolas Chapleau)