PHP Classes

phpSortTable: Show MySQL query results in sortable HTML tables

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (13)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 54%Total: 956 This week: 1All time: 3,771 This week: 560Up
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: 87455 in Germany Germany
Week rank: 411 Up15 in Germany Germany Up

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:956
This week:1
All time:3,771
This week:560Up
 User Ratings  
 
 All time
Utility:83%StarStarStarStarStar
Consistency:66%StarStarStarStar
Documentation:-
Examples:66%StarStarStarStar
Tests:-
Videos:-
Overall:54%StarStarStar
Rank:1983