Connect sortable lists together and update SQL using jQuery UI
Posted
by rebellion
on Stack Overflow
See other posts from Stack Overflow
or by rebellion
Published on 2010-03-22T07:39:47Z
Indexed on
2010/03/22
7:41 UTC
Read the original article
Hit count: 374
I'm using jQuery UI's sortable lists to sort items in a todo list, and the reordering of the lists works like a charm.
I have several UL
lists for each todo category, i.e. Design, Development, etc.
I want to be able to move an item from one category to another, and jQuery UI's sortable lists plugin allows me to do this with the connectWith
option parameter.
But I can't seem to find how to update the database as well. The todo database table has a field for a reference to the category which is laying in it's own table.
This is the current code:
$('.sortable').sortable({
axis: 'y',
opacity: .5,
cancel: '.no-tasks',
connectWith: '.sortable',
update: function(){
$.ajax({
type: 'POST',
url: basepath + 'task/sort_list',
data: $(this).sortable('serialize')
});
}
});
Do I need to add another value to the AJAX's data parameter, or do the sortable plugin this for me in the serialize function?
© Stack Overflow or respective owner