index.php中 var autosave = false; 控制不自动提交。
index.php
复制代码 代码如下:
li move
reset
save
db.php
复制代码 代码如下:
$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`$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['name'].'';
}
exit(0);
保存按钮处理文件 limove_save.php
复制代码 代码如下:
$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['name'].'';
}
exit(0);
重置按钮处理文件 limove_reset.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['name'].'';
}
exit(0);
jquery-1.6.2.min.js文件下载： jquery-1.6.2.min.js
软件包下载：limove_jb51.rar
目录包含文件，如下图：
程序运行后界面：
作者：zjmainstay
出处：http://www.cnblogs.com/zjmainstay/