Class: Sortable Elements (sort, ajax grid)

Screenshots:

File	Role	Description
`screenshot1.gif`	Screen	screenshot - no action
`screenshot2.gif`	Screen	screenshot - drag item
`screenshot3.gif`	Screen	screenshot - editing item

Supplied by:

Name:	Sean Dempsey `<e-mail contact>`
Published packages:	2
Country:	United States - PHP jobs in United States
Home page:	`http://www.seandempsey.com/`
Age:	23
All time rank:	920
Week rank:	82

Browse this author's classes

Innovation Award:

PHP Programming Innovation award nominee

February 2008
Number 2

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

Groups:

HTML	HTML generation and processing	View top rated classes
Databases	Database management, accessing and searching	View top rated classes
AJAX	Interact with the Web server without page reloading	View top rated classes

Detailed description:

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.

Freshmeat project:

Project record:	`sortable_elements`
Popularity score:	26.08 (0.04%)
Popularity rank:	43,868 (PHP Classes: 334)
Vitality score:	0.00 (0.00%)
Rating:	Not yet rated Please rate this class in Freshmeat

User ratings:

There are not enough user ratings to display for this class.

Applications that use this class:

No application links were specified for this class.

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

Related links:

Link	Description
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)

Files:

File	Role	Description
`ajax_save.php`	Aux.	ajax file to allow asyncronous editing
`db.php`	Example	sample database connectivity script (with excellent functions for querying a mysql db)
`example.php`	Example	Test script
`js`
`ajax_functions.js`	Data	javascript base ajax functions
`javascript_functions.js`	Data	base javascript functions
`scriptaculous`
`builder.js`	Data	part of scriptaculous package
`controls.js`	Data	part of scriptaculous package
`dragdrop.js`	Data	part of scriptaculous package
`effects.js`	Data	part of scriptaculous package
`prototype.js`	Data	part of scriptaculous package
`scriptaculous.js`	Data	part of scriptaculous package
`slider.js`	Data	part of scriptaculous package
`sound.js`	Data	part of scriptaculous package
`unittest.js`	Data	part of scriptaculous package
`sortable_elements.css`	Data	css file to assist visualization of sorting
`sorting.inc.php`	Class	Class file
`warning.gif`	Icon	icon to go with report or error message

Download all files: sortable_elements.tar.gz sortable_elements.zip

NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

	Screenshots		Supplied by		Groups		Detailed description		Freshmeat project

Class: Sortable Elements

Screenshots:

Supplied by:

Innovation Award:

Groups:

Detailed description:

Freshmeat project:

User ratings:

Applications that use this class:

Related links:

Files: