PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2006-08-18 (11 years ago) RSS 2.0 feedStarStarStarStar 60%Total: 7,026 All time: 268 This week: 621Down
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.

Recommendations

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

Name: Stefan Gabos <contact>
Classes: 11 packages by
Country: Romania Romania
Age: 37
All time rank: 311 in Romania Romania
Week rank: 115 Down2 in Romania Romania Down
Innovation award
Innovation award
Nominee: 1x

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,026
This week:0
All time:268
This week:621Down
User Ratings User Comments (2)
 All time
Utility:88%StarStarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:-
Examples:84%StarStarStarStarStar
Tests:-
Videos:-
Overall:60%StarStarStarStar
Rank:1195