Login   Register  
PHP Classes
elePHPant
Icontem

SQL Table: Output SQL query results as HTML tables

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2011-05-01 (3 years ago) RSS 2.0 feedStarStarStar 52%Total: 2,613 All time: 1,351 This week: 1,496Down
Version License PHP version Categories  
sqltable 0.8GNU Lesser General Publ...4.0HTML, Databases
Description Author  

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.

Picture of Peter Klauer
Name: Peter Klauer <contact>
Classes: 18 packages by
Country: Germany Germany
Age: 56
All time rank: 312 in Germany Germany
Week rank: 244 Down6 in Germany Germany Down
Innovation award
Innovation award
Nominee: 3x

Screenshots  
  • sqltable.jpg
  • Katalog2.gif
  • Katalog1.gif
  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

 Version Control Reuses Unique User Downloads Download Rankings  
 0%1Total:2,613All time:1,351
 This week:0This week:1,496Down
 User Ratings  
 
 All time
Utility:79%StarStarStarStar
Consistency:77%StarStarStarStar
Documentation:55%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:52%StarStarStar
Rank:1451