PHP Classes

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

Recommend this page to a friend!
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 53%Total: 7,155 All time: 272 This week: 49Up
Version License Categories
querytabledisplay 1.0.0BSD LicenseHTML, Databases
Description 

Author

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 <contact>
Classes: 45 packages by
Country: Portugal Portugal

Recommendations

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

Screenshots (1)  
  • databasetable.gif
  Files folder image Files (7)  
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.

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadquerytabledisplay-2008-06-08.zip 16KB
Downloadquerytabledisplay-2008-06-08.tar.gz
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  
 0%
Total:7,155
This week:0
All time:272
This week:49Up
 User Ratings  
 
 All time
Utility:78%StarStarStarStar
Consistency:76%StarStarStarStar
Documentation:-
Examples:69%StarStarStarStar
Tests:-
Videos:-
Overall:53%StarStarStar
Rank:2158