This package can be used to display MySQL database query result data in an HTML table grid.
There are classes to define details of the headers and body of table grid.
There is also a class for executing MySQL database queries and return the results in a bi-dimensional array.
The data grid classes can be customized to specify presentation details such as the CSS classes or styles to be used to render the different parts of the table grid, alternate styles for each row, data pagination, etc..
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.
This class can be used to list data in an HTML table that can be edited using AJAX.
It supports list page scrolling, column sorting, and in-place editing of data cells using form fields to alter the values and AJAX requests to save the changed values to the server.
This package can be used to display and edit data from a database in a grid using the Zend Framework. It features:
* Simplified grid data presentation just by specifying the source database table
* Multiple Sources (DB, Array, JSON, CSV, XML)
* Template based presentation
* Filter data by user selected fields
* Data validation (when performing CRUD operations)
* Automatic pagination of results
* Support for extra listing column fields
* List sorting by field
* Configurable field titles
* Support for SQL aggregation expressions (MAX, COUNT, MIN, AVG, etc…)
* Internationalization support
* Export results in multiple formats: XML, HTML table, PDF, Excel, Word, etc..
* Cache support
* Plug-ins to format content: date, bool, currency, etc..
* Doctrine Support
* Zend_Form for CRUD operations
* Zend_Config Support
* Multiple Instances per page (no conflicts at all…)
* Support for Extra Rows
* Conditional Fields Presentation
* Option for detailed view
* PRG Form processing
* Render specific parts separately (filters, titles, pagination, etc…)
* Conditional Fields Rendering
* jqGrid Rendering
* Open Flash Chart support
Browse the data in a MySQL table using HTML tables
This class can be used to browse data from a given MySQL table to display it using HTML tables.
The class executes a SELECT SQL query to retrieve data from a given table.
The data is retrieved into an array of a limited number of rows that corresponds to the current result page to display.
The data is displayed in an HTML table with configurable width, color, border width, cell padding and cell spacing, and the number of records to display per page.
The class also outputs links to navigate between the different table pages.
Stumble It!
Bookmark in del.icio.us
1. 
