个非常好用上下排序箭头,大家可以看下了,一定让你眼前一亮了。。。
此函数有五个参数,分别是当前排序的ID值,位置,箭头方向,分页数,参数。
function uporder($PID,$Place,$Direction,$Page,$Param)
{ global $pl; $objResponse = new xajaxResponse(); if(!$PID) { $objResponse->addAlert("对不起,参数错误!"); return $objresponse->getXML(); } if($Direction=="up") {$sql = "select * from jj_properties where Place<$Place order by Place desc limit 1";} else {$sql = "select * from jj_properties where Place>$Place order by Place asc limit 1";} $result = $pl->query($sql); if($rs=$pl->fetch_array($result)) { $Place1 = $rs["Place"]; $PID1 = $rs["ID"]; $query = "update jj_properties set Place='{$Place}' where id=$PID1"; //与排序的记录交换位置 $result1 = $pl->query($query); $query1 = "update jj_properties set Place='{$Place1}' where id=$PID"; $result = $pl->query($query1); } $objResponse->script("xajax_ShetuList('','{$Page}','{$Param}')"); return $objResponse->getXML(); }本文出自网站家园,专为人员提供技术问答的网站。
网址: