PHP Classes

Query result table display class: Outputs tables with the result of database queries

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 52%Total: 7,154 All time: 271 This week: 455Down
Version License Categories
querytabledisplay 1.0.0BSD LicenseHTML, Databases


Class that outputs a table with the data from the result rows of a database query. It features:

- Database independency (works with any DBMS supported by Metabase).
- Splits the display of the result rows in multiple pages of configurable number of rows displaying automatic links to Next, Previous, First, Last, etc.. pages.
- Arbitrary column display display.
- Automatic alignmnent of columns according to their data types.-
- Configurable colors for the table headers and data alternating between even and odd rows.

Picture of Manuel Lemos
  Performance   Level  
Name: Manuel Lemos is available for providing paid consulting. Contact Manuel Lemos .
Classes: 45 packages by
Country: Portugal Portugal
Age: 55
All time rank: 1
Week rank: 4 Down1 in Portugal Portugal Equal


Detect file encoding and convert it to UTF-8 without BOM
I am unable to detect file encoding, that needs to be converted

  • databasetable.gif
  Files folder image Files  
File Role Description
Accessible without login Plain text file currencies.schema Data Schema definition of an example currencies database
Plain text file databasetableclass.php Class Query result table display class
Accessible without login Plain text file database_setup.php Conf. Database configuration definitions
Accessible without login Plain text file setup_currency_database.php Aux. Script to setup the example currencies database
Accessible without login Plain text file test_database_table.php Example Example script that shows how to use the class
Accessible without login HTML file test_database_table_page.html Output HTML output of the class example script. 16KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
Metabase Download .zip .tar.gz Database independent abstraction layer used to access many SQL databases Required
Table wrapper base class Download .zip .tar.gz Base class to present the query results in HTML tables Required
 Version Control Unique User Downloads Download Rankings  
This week:0
All time:271
This week:455Down
 User Ratings  
 All time