PHP Classes

phpSortTable: Show MySQL query results in sortable 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 54%Total: 956 All time: 3,773 This week: 455Up
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

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

  Files folder image Files (14)  /  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 (14)  /  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 (14)  /  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

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
 Version Control Unique User Downloads Download Rankings  
 0%
Total:956
This week:0
All time:3,773
This week:455Up
 User Ratings  
 
 All time
Utility:83%StarStarStarStarStar
Consistency:66%StarStarStarStar
Documentation:-
Examples:66%StarStarStarStar
Tests:-
Videos:-
Overall:54%StarStarStar
Rank:2023