PHP Classes

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

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (15)   DownloadInstall with Composer Download .zip   Reputation   Support forum (10)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 7,088 All time: 275 This week: 177Up
Version License Categories
datagridclass 1.0.0Free To Use But R...HTML, Databases
Description 

Author

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.

Picture of Stefan Gabos
Name: Stefan Gabos <contact>
Classes: 12 packages by
Country: Romania Romania
Age: 44
All time rank: 312 in Romania Romania
Week rank: 312 Down3 in Romania Romania Down
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Recommendations

read html files
I need to read and publish html file content

Display multiple table records with HTML
How to display multiple table records in an HTML page?

Screenshots  
  • screenshot.gif
  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 folder image Files  /  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 folder image Files  /  includes  
File Role Description
  Plain text file class.xtemplate.php Aux. XTemplate class
  Plain text file license.txt Lic. XTemplate class' license file

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

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

  Files folder image Files  /  templates  /  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 folder image Files  /  templates  /  default  /  img  
File Role Description
  Image file down.gif Data icon
  Image file up.gif Data icon

 Version Control Unique User Downloads Download Rankings  
 0%
Total:7,088
This week:0
All time:275
This week:177Up
User Ratings User Comments (2)
 All time
Utility:85%StarStarStarStarStar
Consistency:79%StarStarStarStar
Documentation:-
Examples:81%StarStarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1382