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.