PHP Classes

SQL Table: Output SQL query results as HTML tables

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 50%Total: 2,671 All time: 1,432 This week: 455Up
Version License PHP version Categories
sqltable 0.8GNU Lesser Genera...4.0HTML, Databases
Description 

Author

Peter Klauer

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: 66
All time rank: 352 in Germany Germany
Week rank: 195 Down8 in Germany Germany Down
Innovation award
Innovation award
Nominee: 3x

Screenshots (3)  
  • Katalog1.gif
  • Katalog2.gif
  • sqltable.jpg
  Files folder image Files (8)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsqltable-2011-05-01.zip 89KB
Downloadsqltable-2011-05-01.tar.gz
Install with ComposerInstall with Composer
 Version Control Reuses Unique User Downloads Download Rankings  
 0%1
Total:2,671
This week:0
All time:1,432
This week:455Up
 User Ratings  
 
 All time
Utility:75%StarStarStarStar
Consistency:73%StarStarStarStar
Documentation:56%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:50%StarStarStar
Rank:2706
  

  Applications that use this package  
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.
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.


  Other classes that need this package  
Class Why it is needed Dependency
Comment Sqltable is needed to display the comment entries. Required

  Related pages  
Homepage showing PHP scripts