DIV CSS 佈局教程網

用 jQuery 實作百度風格導航拖放排序並即時寫入資料庫
編輯:JQuery特效代碼     

本文示範一個類似百度導航的項目排序效果:使用者可以拖動清單中的項目重新排列,放開後透過 Ajax 即時把新順序寫回資料庫,也可透過「儲存」按鈕批次提交,或按「重置」還原預設順序。

在 index.php 中,var autoSave = false; 用來控制是否自動提交。

一、index.php

<?php
require 'db.php';
$query = "SELECT `id`,`order`,`name` FROM `limove` ORDER BY `order`";
$lis = mysql_query($query,$conn);
$li_count = mysql_num_rows($lis);
?>
<!DOCTYPE html>
<html>
<head>
<title>li Move</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script type="text/javascript" src="jquery-1.6.2.min.js"></script>
</head>
<body>
<style>
ul{ border:1px solid red; height:150px; margin:auto; width:745px; }
li{ border:1px solid #AABBCC; float:left; list-style:none outside none; margin:10px; text-align:center; width:120px; cursor:move; }
#reset{ border:1px solid #AABBCC; cursor:pointer; float:right; height:20px; padding:2px; width:40px; }
#save{ border:1px solid #AABBCC; cursor:pointer; float:right; height:20px; padding:2px; width:40px; }
</style>
<div id="reset">Reset</div>
<div id="save">Save</div>
<ul>
<?php
while($li = mysql_fetch_assoc($lis)){
  echo '<li id="'.$li['id'].'" order="'.$li['order'].'">'.$li['name'].'</li>';
}
?>
</ul>
<script type="text/javascript">
$(document).ready(function(){
  $("ul").css({height:<?php echo (ceil($li_count/5)*40+10) ?>});
  var on_move_li = '';
  var on_move_li_offset = '';
  var on_move_li_index = '';
  var autoSave = false;
  function bindMoveListening(){
    $("li").mousedown(function(){
      on_move_li_offset = $(this).offset();
      on_move_li = $(this);
      on_move_li_index = on_move_li.prevAll().length;
      if(on_move_li_index == 0) var index = 1; else var index = on_move_li_index;
      // 建立空 li 佔位
      $("ul").children("li").eq(index-1).after('<li class="dashed" style="border:1px dashed #AABBCC"> </li>')
      on_move_li.addClass('moving').css({left:on_move_li_offset.left,top:on_move_li_offset.top,position:'absolute','z-index':3,border:'1px dashed #AABBCC'});
      $("ul").mousemove(function(e){
        if($(this).find(".moving").length != 0) {
          var clientX = e.clientX-60;
          var clientY = e.clientY-20;
          on_move_li.css({left:clientX,top:clientY});
        }
      });
      $("ul").mouseup(function(e){
        if($(this).find(".moving").length != 0) {
          var clientX = e.clientX;
          var clientY = e.clientY;
          var times = Math.floor((clientY-(on_move_li_offset.top+10))/42);
          var index = (times*5)+(Math.floor((clientX-(on_move_li_offset.left+50))/120)+on_move_li_index);
          if(index > <?php echo $li_count ?>) index = <?php echo $li_count ?>;
          on_move_li.attr('class',null).attr('style',null);
          $(".dashed").remove();
          var fromid = on_move_li.attr('id');
          var fromorder = on_move_li.attr('order');
          var toorder = $("ul").children("li").eq(index).attr('order');
          if(index == on_move_li_index && index>0) index = index-1;
          if(on_move_li_index == 0 && (index == -1||index == 0) ) $("ul").children("li").eq(1).before(on_move_li);
          else if(index == -1) $("ul").children("li").eq(0).before(on_move_li);
          else $("ul").children("li").eq(index).after(on_move_li);
          if(autoSave){
            $.ajax({
              url:'limove_process.php', type:'POST',
              data:{'fromid':fromid,'fromorder':fromorder,'toorder':toorder},
              success:function(newdata){ $("ul").empty().append(newdata); bindMoveListening(); }
            });
          }
        }
      });
    });
    $("#reset").click(function(){
      $.ajax({ url:'limove_reset.php', type:'POST',
        success:function(newdata){ $("ul").empty().append(newdata); bindMoveListening(); } });
    });
    $("#save").click(function(){
      var data = '';
      var lis = $("ul").children("li");
      $.each(lis,function(i){ data += lis.eq(i).attr('id')+','; });
      $.ajax({ url:'limove_save.php', type:'POST',
        data:{'data':data.substr(0,data.length-1)},
        success:function(newdata){ $("ul").empty().append(newdata); bindMoveListening(); } });
    });
  }
  bindMoveListening();
});
</script>
</body>
</html>

二、db.php(資料庫連線)

<?php
static $connect = null;
if(!isset($connect)) {
  $connect = mysql_connect("localhost","root","");
  if(!$connect) { $connect = mysql_connect("localhost","Zjmainstay",""); }
  if(!$connect) { die('無法連線資料庫,錯誤由 /test/db.php 處理'); }
  mysql_select_db("test",$connect);
  mysql_query("SET NAMES utf8",$connect);
  $conn = &$connect;
  $db = &$connect;
}

三、自動提交處理:limove_process.php

拖放完成後,以交易方式更新排序:先將受影響區間的 order 整體位移,再更新被拖動項目的 order,成功則 COMMIT、失敗則 ROLLBACK。

<?php
require 'db.php';
$fromid = $_POST['fromid'];
$fromorder = $_POST['fromorder'];
$toorder = $_POST['toorder'];
$updateorder = $toorder;
$eqf = ''; $eqt = '='; $symbol = '-'; $notZero = 'AND `order`>1';
if($fromorder > $toorder){
  $eqf = '='; $eqt = ''; $symbol = '+';
  $fromorder = $toorder; $toorder = $_POST['fromorder'];
  $updateorder = $fromorder; $notZero = '';
}
mysql_query("START TRANSACTION",$conn);
$query = "UPDATE `limove` SET `order`=`order`{$symbol}1 WHERE (`order`>{$eqf}{$fromorder} AND `order`<{$eqt}{$toorder} {$notZero})";
$return1 = mysql_query($query,$conn);
$query = "UPDATE `limove` SET `order`={$updateorder} WHERE `id`={$fromid}";
$return2 = mysql_query($query,$conn);
if($return1 && $return2){ mysql_query("COMMIT",$conn); } else { mysql_query("ROLLBACK",$conn); }
$query = "SELECT `id`,`order`,`name` FROM `limove` ORDER BY `order`";
$lis = mysql_query($query,$conn);
while($li = mysql_fetch_assoc($lis)){ echo '<li id="'.$li['id'].'" order="'.$li['order'].'">'.$li['name'].'</li>'; }
exit(0);

四、儲存按鈕處理:limove_save.php

<?php
require 'db.php';
$data = explode(',',$_POST['data']);
mysql_query("START TRANSACTION",$conn);
$return = 1;
foreach($data as $order => $id){
  $order++;
  $query = "UPDATE `limove` SET `order`={$order} WHERE `id`={$id}";
  $return = mysql_query($query,$conn) && $return;
}
if($return){ mysql_query("COMMIT",$conn); } else { mysql_query("ROLLBACK",$conn); }
$query = "SELECT `id`,`order`,`name` FROM `limove` ORDER BY `order`";
$lis = mysql_query($query,$conn);
while($li = mysql_fetch_assoc($lis)){ echo '<li id="'.$li['id'].'" order="'.$li['order'].'">'.$li['name'].'</li>'; }
exit(0);

五、重置按鈕處理:limove_reset.php

<?php
require 'db.php';
mysql_query("UPDATE limove SET `order`=`id`");
$query = "SELECT `id`,`order`,`name` FROM `limove` ORDER BY `order`";
$lis = mysql_query($query,$conn);
while($li = mysql_fetch_assoc($lis)){ echo '<li id="'.$li['id'].'" order="'.$li['order'].'">'.$li['name'].'</li>'; }
exit(0);

程式執行畫面

目錄包含的檔案如下圖:

程式運行後界面:

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved