Login   Register  
PHP Classes
elePHPant
Icontem

phpSortTable: Show MySQL query results in sortable 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 (13)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2007-02-23 (7 years ago) RSS 2.0 feedNot enough user ratingsTotal: 938 This week: 1All time: 3,533 This week: 1,485Up
Version License PHP version Categories  
phpsorttable 1.1Freely Distributable4.0HTML, Databases
Description Author  

!!! NOTICE: I suggest to use my other Class phpSortable under the site http://www.phpclasses.org/browse/package/3704.html. It is better and has a Database abstraction feature. I keep this package always updated, but not the phpSortTable.

This class can be used to display MySQL database query results in HTML tables with columns that can be sorted.

It executes MySQL queries and generates an HTML table to display the results.

The table headers show the result column names as links that the user can click to execute the query again sorting the results by the clicked column.
Each row may have optional columns with links to other pages, like for instance to edit and delete the table row.

The table may be limited to a given number of rows per page using additional links to browse multiple pages of results.

Picture of Wagner O. Wutzke
Name: Wagner O. Wutzke <contact>
Classes: 3 packages by
Country: Germany Germany
Age: ???
All time rank: 79453 in Germany Germany
Week rank: 1128 Down54 in Germany Germany Down

Screenshots  
  • ss_phpSortTable.jpg
  Files folder image Files  
File Role Description
Files folder imageexamples (3 files)
Files folder imagephpSortTable (5 files, 1 directory)

  Files folder image Files  /  examples  
File Role Description
  Plain text file example_01.php Example example of use for the class
  Plain text file example_02.php Example another example on using this class
  Plain text file howto.php Example how to use the class

  Files folder image Files  /  phpSortTable  
File Role Description
Files folder imageimg (5 files)
  Plain text file changes.txt Data changes history
  Plain text file php_sort_column.php Class help class file
  Plain text file php_sort_table.css Data CSS file
  Plain text file php_sort_table.php Class phpSortTable class file
  Plain text file readme.txt Data readme file

  Files folder image Files  /  phpSortTable  /  img  
File Role Description
  Image file add.gif Icon icon image
  Image file asc.gif Icon icon image
  Image file delete.gif Icon icon image
  Image file desc.gif Icon icon image
  Image file edit.gif Icon icon image

 Version Control Unique User Downloads Download Rankings  
 0%Total:938All time:3,533
 This week:1This week:1,485Up