Login   Register  
PHP Classes

PHP data grid class: Display MySQL query results in HTML tables

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Stefan Gabos
Name: Stefan Gabos <e-mail contact>
Packages: 11 Browse all classes by Stefan Gabos Browse all classes by
Country: Romania Romania - PHP jobs in Romania
Age: 34
All time rank: 321 in Romania Romania
Week rank: 71 Down1 in Romania Romania Equal
Innovation award
Innovation award
Nominee: 1x

  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
This 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.

A special column may be displayed with check box inputs to let the user choose specific rows to perform additional operations on the selected rows.

The content of the fields may be changed using custom callback functions.

The Javascript to handle row click events may also be customized.

Additional columns may be added to the generated table using a customization sub-class.

  Classes of Stefan Gabos  >  PHP data grid class  >  Download Download .zip .tar.gz  >  Support forum Support forum (11)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: PHP data grid class
Base name: datagridclass
Description: Display MySQL query results in HTML tables
Version: 1.0.0
PHP version: -
License: Free To Use But Restricted
All time users: 6383 users
All time rank: 296
Week users: 2 users
Week rank: 1095 Down
  Groups   Screenshots Screenshots   Freshmeat project  
  Rate classes User ratings   Applications   Related links   Files Files  

Group folder image HTML HTML generation and processing View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes

  Files folder image Screenshots  
File Role Description
Accessible without login Image file screenshot.gif Screen /examples/screenshot.gif

  Freshmeat project  
PHP data grid class
Project record: phpdatagrid
Popularity score: 93.24
Vitality score: 1.82

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (87.5%) Good (80.0%) - Good (82.5%) - - Sufficient (60.0%) 862
Month: Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
manual of the class manual of the class

  Files folder image Files  
File Role Description
Files folder imageexamples (6 files)
Files folder imageincludes (2 files)
Files folder imagelanguages (1 file)
Files folder imagetemplates (1 directory)
Plain text file class.datagrid.php Class class source
Plain text file License Lic. license file

  Files  /  Files folder image examples  
File Role Description
  Plain text file example.sql Data test sql file
  Plain text file example1.php Example example 1
  Plain text file example2.php Example example 2
  Plain text file example3.php Example example 3
  Plain text file example4.php Example example 4
  Plain text file readme.txt Data read me for how to use the examples

  Files  /  Files folder image includes  
File Role Description
  Plain text file class.xtemplate.php Aux. XTemplate class
  Plain text file license.txt Lic. XTemplate class' license file

  Files  /  Files folder image languages  
File Role Description
  Plain text file english.php Data default language file

  Files  /  Files folder image templates  
File Role Description
Files folder imagedefault (2 files, 1 directory)

  Files  /  templates  /  Files folder image default  
File Role Description
Files folder imageimg (2 files)
  Plain text file style.css Data default template stylesheet
  Plain text file template.xtpl Data default template file

  Files  /  templates  /  default  /  Files folder image img  
File Role Description
  Image file down.gif Data icon
  Image file up.gif Data icon

Install with Composer Install with Composer - Download Download all files: datagridclass.tar.gz datagridclass.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.