关于PHP+jQuery-ui拖动浮动层排序并保存到数据库实例

  
 
   
 
Module: 
 
 
 
  
 

$(function() { $(".m_title").bind('mouseover', function() { $(this).css("cursor", "move") }); var $show = $("#loader"); //进度条 var $orderlist = $("#orderlist"); var $list = $("#module_list"); $list.sortable({ opacity: 0.6, revert: true, cursor: 'move', handle: '.m_title', update: function() { var new_order = []; $list.children(".modules").each(function() { new_order.push(this.title); }); var newid = new_order.join(','); var oldid = $orderlist.val(); $.ajax({ type: "post", url: "update.php", data: { id: newid, order: oldid }, //id:新的排列对应的ID,order：原排列顺序 beforeSend: function() { $show.html(" 正在更新"); }, success: function(msg) { $show.html(""); } }); } }); });

$order = $_POST['order']; $itemid = trim($_POST['id']); if (!empty($itemid)) { if ($order != $itemid) { $query = mysql_query("update sortlist set sort='$itemid' where id=1"); if ($query) { echo $itemid; } else { echo "none"; } } }