Login   Register  
PHP Classes
elePHPant
Icontem

Sortable Elements: Display MySQL records in a sortable HTML table

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 (17)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2008-01-21 (6 years ago) RSS 2.0 feedNot enough user ratingsTotal: 2,250 This week: 1All time: 1,622 This week: 1,364Up
Version License PHP version Categories  
sortable_elements 1.0GNU General Public Lice...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: 30
All time rank: 25428 in United States United States
Week rank: 160 Up16 in United States United States Up
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,250All time:1,622
 This week:1This week:1,364Up
 User Comments (1)