PHP Classes
elePHPant
Icontem

Sortable Elements: Display MySQL records in a sortable HTML table

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (17)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2008-01-21 (8 years ago) RSS 2.0 feedStarStarStar 58%Total: 2,270 All time: 1,656 This week: 899Up
Version License PHP version Categories
sortable_elements 1.0GNU General Publi...3.0HTML, Databases, AJAX
Description Author

This class can be used to display MySQL database table records in an HTML table that can be sorted by dragging rows.

It generates HTML and Javascript to display the records of a MySQL table in HTML table rows that can be dragged to sort the table elements.

The class sends AJAX requests to send changes of the table elements to the server so the changes can be stored in the MySQL table without having to reload the page.

Innovation Award
PHP Programming Innovation award nominee
February 2008
Number 2


Prize: One book of choice by Packt
There are plenty of solutions to display data from databases in table grids that allow the user to according to the values a given column.

This package provides a solution to different problem, which is the need that certain applications have to let their users sort data to their own criteria.

The package provides an elegant user interface that lets users drag the entries of the listed database records and drop them in whatever position the users want. The class uses AJAX to commit the sorting changes without reloading the current page.

Manuel Lemos
Picture of Sean Dempsey
Name: Sean Dempsey <contact>
Classes: 3 packages by
Country: United States United States
Age: 31
All time rank: 24127 in United States United States
Week rank: 300 Down33 in United States United States Down
Innovation award
Innovation award
Nominee: 1x

Screenshots  
  • screenshot3.gif
  • screenshot2.gif
  • screenshot1.gif
  Files folder image Files  
File Role Description
Files folder imagejs (2 files)
Files folder imagescriptaculous (9 files)
Plain text file ajax_save.php Aux. ajax file to allow asyncronous editing
Plain text file db.php Example sample database connectivity script (with excellent functions for querying a mysql db)
Plain text file example.php Example Test script
Plain text file sortable_elements.css Data css file to assist visualization of sorting
Plain text file sorting.inc.php Class Class file
Image file warning.gif Icon icon to go with report or error message

  Files folder image Files  /  js  
File Role Description
  Plain text file ajax_functions.js Data javascript base ajax functions
  Plain text file javascript_functions.js Data base javascript functions

  Files folder image Files  /  scriptaculous  
File Role Description
  Plain text file builder.js Data part of scriptaculous package
  Plain text file controls.js Data part of scriptaculous package
  Plain text file dragdrop.js Data part of scriptaculous package
  Plain text file effects.js Data part of scriptaculous package
  Plain text file prototype.js Data part of scriptaculous package
  Plain text file scriptaculous.js Data part of scriptaculous package
  Plain text file slider.js Data part of scriptaculous package
  Plain text file sound.js Data part of scriptaculous package
  Plain text file unittest.js Data part of scriptaculous package

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,270
This week:0
All time:1,656
This week:899Up
User Ratings User Comments (1)
 All time
Utility:87%StarStarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:-
Examples:68%StarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1201