Login   Register  
PHP Classes
elePHPant
Icontem

Class: SQL Table

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Peter Klauer  >  SQL Table  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Table
Support forum Support forum
Base name: sqltable
Description: Output SQL query results as HTML tables
Related classes: , , , , , , ,
Version: 0.8
PHP version: 4.0
License: GNU Lesser General Public License (LGPL)
All time users: 2418 users
All time rank: 1311
Week users: 2 users
Week rank: 1744
Picture of Peter Klauer
Author: Peter Klauer <e-mail contact>
Packages: 18 Browse this author's classes Browse this author's classes
Country: Germany Germany - PHP jobs in Germany
Age: 53
All time rank: 292 in Germany Germany
Week rank: 143 Down5 Down in Germany Germany
Innovation award
Innovation award
Nominee: 3x


  Detailed description  
This class is meant to output SQL database query results as HTML tables.
It supports displaying a limited range of query result rows per page with buttons to navigate between multiple pages in case the query returned more rows than the specified limit per page.
This class is tested deeply with MySQL and Microsoft SQL server but it may already support other databases.
It allows the customization of the table column headers, turn values into links to other pages or hide certain columns, have javascript onclick events or merge the content of multiple columns into one.

 

  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   Rate classes User ratings   Dependents  
  Applications   Related links   Files Files  
  Files folder image Screenshots  
Using the sqltable::udf one can have forms in a row
File Role Description
Accessible without login Image file Katalog1.gif Screen Using the sqltable::udf one can have forms in a row
Accessible without login Image file Katalog2.gif Screen Using sqltable::udf more than one value per cell can be displayed
Accessible without login Image file sqltable.jpg Screen This is on www.kinderrattat.de story preview page


  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (79.2%)
Sufficient (77.1%)
Not sure (55.0%)
-
-
-
Not sure (52.8%)
1308
Month:
Not yet rated by the users

  Packages that need this class  
Class Dependency Why it is needed
Comment
Required
 Sqltable is needed to display the comment entries.

  Applications that use this class  
Link Description
KinderRatTat Story Table Puts caption, category, date and textpreview into the left cell and an image into the right cell of the table and has no column headers.
Yogalehrer-Online Technews Programmer News Listing
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
sqltable example Homepage showing PHP scripts

  Files folder image Files  
File Role Description
Plain text file class_sqltable.php Class The class file
Accessible without login Plain text file multiplecell.txt Doc. How to have multiple values per cell
Plain text file sqltable.txt Doc. how to use the class and example
Plain text file CHANGELOG.txt Doc. Changes from 2006-2010
Plain text file License_LGPL-3.0.txt Lic. LGPL License

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