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,271 All time: 1,661 This week: 1,016Up
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
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

Downloadsortable_elements-2008-01-21.zip 94KB
Downloadsortable_elements-2008-01-21.tar.gz 89KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,271
This week:0
All time:1,661
This week:1,016Up
User Ratings User Comments (1)
 All time
Utility:87%StarStarStarStarStar
Consistency:81%StarStarStarStarStar
Documentation:-
Examples:68%StarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1298
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Related pages  
Class Walkthough / Demo
Detailed walkthough of how to use the class.
Download Working Demo
A working demo with all files in proper directories (with scriptaculous included)