PHP Data Grid Class can be used to display MySQL query results in HTML tables. It executes a given SQL SELECT query and generates an HTML table defined by a template to display the query results. The results table also shows links to navigate between query result pages. The number of result rows to display per page is configurable. The results can be sorted by columns that the user may choose by clicking on column links. The list of sortable columns may be restricted.
|Tags||Software Development Libraries php classes|
|Operating Systems||OS Independent|
Release Notes: Arrays can now be passed to the grid for displaying. Setting the the default sort column now works correctly. The layout of check all/uncheck all/invert buttons can now also be set from the template. The form action can now be set when instantiating the data grid and the template can now be set by using the newly added method, "setTemplate()". The language can now be set with the "setLanguage()" method. Romanian, Spanish, and Simplified Chinese translations were added.
Release Notes: The "useSEO" property was added. If you set this property to TRUE, the script will append a parameter to the URL (configured by using the newly added "URLa" property) when navigating through pages, making the data grid search-engine friendly. The posibility to order results by multiple columns was added. The datagrid would crash if single quotes were used anywhere. You can now specify columns in the form of tablename.columnname. HTML attributes and callback functions can now be set to multiple columns at once.
No changes have been submitted for this release.