Query result table display class (metabase, split)

Name:	Query result table display class Support forum
Base name:	`querytabledisplay`
Description:	Outputs tables with the result of database queries
Related top rated classes:	metabase, split
Version:	`-`
Required PHP version:	`-`
License:	BSD License
All time users:	6547 users
All time rank:	154
Week users:	6 users
Week rank:	1291

	Screenshots		Author		Groups		Detailed description		Freshmeat project

	User ratings		Dependencies		Trackback		Applications		Files

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
`databasetable.gif`	Screen	Example of the listing of database query results showing alternated row colors and highlight color on the row below the mouse

Author

Name:	Manuel Lemos `<e-mail contact>`
Published packages:	29 Browse this author's classes
Country:	Portugal - PHP jobs in Portugal
Home page:	`http://www.ManuelLemos.net/`
Age:	40
All time rank:	1
Week rank:	2

Groups

	HTML	HTML generation and processing	View top rated classes
	Databases	Database management, accessing and searching	View top rated classes

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.

Freshmeat project

Project record:	`querytabledisplayclass`
Popularity score:	49.3
Vitality score:	5.65

User ratings

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (75.0%)`	`Sufficient (72.9%)`	`-`	`Sufficient (64.6%)`	`-`	`-`	`Not sure (51.3%)`	1166
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...

Latest blog trackback links

Applications that use this class

No application links were specified for this class.

If you know an application of this package, send a message to the author to add a link here.

Files

File	Role	Description
`currencies.schema`	Data	Schema definition of an example currencies database
`databasetableclass.php`	Class	Query result table display class
`database_setup.php`	Conf.	Database configuration definitions
`setup_currency_database.php`	Aux.	Script to setup the example currencies database
`test_database_table.php`	Example	Example script that shows how to use the class
`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.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: Query result table display class