Query result table display class

Recommend this page to a friend!

Stumble It!

Bookmark in del.icio.us

Classes of Manuel Lemos

Query result table display class

Download .tar.gz .zip

Support forum

Blog

Latest changes

Name:	Query result table display class Support forum
Base name:	`querytabledisplay`
Description:	Outputs tables with the result of database queries
Related classes:	metabase, last row, result
Version:	`-`
PHP version:	`-`
License:	BSD License
All time users:	6961 users
All time rank:	221
Week users:	0 users
Week rank:	2403

	Author

Name:	Manuel Lemos `<e-mail contact>`
Packages:	32 Browse all classes by Manuel Lemos
Country:	Portugal - PHP jobs in Portugal
Age:	43
All time rank:	1
Week rank:	4	1 in Portugal

	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		Screenshots		Freshmeat project		User ratings

	Dependencies		Trackback		Applications		Files

	Groups

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

	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

	Freshmeat project

Project record:	`querytabledisplayclass`
Popularity score:	39.24
Vitality score:	3.4

	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%)`	1322
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.