Projects / PHP Data Grid Class

PHP Data Grid Class

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
Operating Systems
Implementation

Recent releases

  •  15 May 2007 08:52

    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.

    •  05 Mar 2007 09:27

      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.

      •  06 Sep 2006 12:15

        No changes have been submitted for this release.

        Screenshot

        Project Spotlight

        OpenStack4j

        A Fluent OpenStack client API for Java.

        Screenshot

        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.