Login   Register  
PHP Classes
elePHPant
Icontem

Class: Query result table display class

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Manuel Lemos  >  Query result table display class  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Query result table display class
Base name: querytabledisplay
Description: Outputs tables with the result of database queries
Related classes: , ,
Version: -
PHP version: -
License: BSD License
All time users: 6944 users
All time rank: 218
Week users: 1 user
Week rank: 2420
Picture of Manuel Lemos
Author: Manuel Lemos <e-mail contact>
Packages: 32 Browse this author's classes Browse this author's classes
Country: Portugal Portugal - PHP jobs in Portugal
Age: 43
All time rank: 1
Week rank: 4 Down1 in Portugal Portugal Equal


  Detailed description  
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.

 

  Groups  
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

  Screenshots Screenshots   Freshmeat project   Rate classes User ratings  
  Dependencies   Trackback   Applications   Files Files  
  Files folder image Screenshots  
Example of the listing of database query results showing alternated row colors and highlight color on the row below the mouse
File Role Description
Accessible without login Image file databasetable.gif Screen Example of the listing of database query results showing alternated row colors and highlight color on the row below the mouse


  Freshmeat project  
Query result table display class
Project record: querytabledisplayclass
Popularity score: 38.78
Vitality score: 3.48

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (76.9%)
Sufficient (75.0%)
-
Sufficient (67.3%)
-
-
Not sure (52.7%)
1311
Month:
Not yet rated by the users

  Packages needed by this class  
Class Dependency Why it is needed
Metabase
Required
Database independent abstraction layer used to access many SQL databases
Table wrapper base class
Required
Base class to present the query results in HTML tables

  Trackback links  
Link Description
Php Hey, all i need to do is show all the information in an MySQL table in an HTML table, regardless of the number of rows...

  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.
  Files folder image Files  
File Role Description
Plain text file currencies.schema Data Schema definition of an example currencies database
Plain text file databasetableclass.php Class Query result table display class
Plain text file database_setup.php Conf. Database configuration definitions
Plain text file setup_currency_database.php Aux. Script to setup the example currencies database
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.

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