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
Not enough user ratingsTotal: 955 All time: 3,763 This week: 328Up
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: 87355 in Germany Germany
Week rank: 703 Up28 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:955
This week:0
All time:3,763
This week:328Up