php对数据进行上移下移,ThinkPHP 实现新闻后台数据上移、下移功能

public function moveup(){

//获取上一条新闻信息

$m = M('News');

$dataOri = $m->where('orderid='.$_GET['orderid'])->select();

$map['orderid'] = array('lt',$_GET['orderid']);

$data = $m->where($map)->order('orderid desc')->limit(1)->select();

//echo count($data);

if(count($data)>0){

$newOrderid = $data[0]['orderid'];

$data[0]['orderid'] = $_GET['orderid'];

$m->save($data[0]);

$dataOri[0]['orderid']=$newOrderid;

$m->save($dataOri[0]);

//跳转到显示项目列表页

$this->redirect('/News/index/p/'.$_GET['p']);

}else{

$this->redirect('/News/index/p/'.$_GET['p']);

}

}

public function movedown(){

//获取下一条新闻信息

$m = M('News');

$dataOri = $m->where('orderid='.$_GET['orderid'])->select();

$map['orderid'] = array('gt',$_GET['orderid']);

$data = $m->where($map)->order('orderid asc')->limit(1)->select();

//echo count($data);

if(count($data)>0){

$newOrderid = $data[0]['orderid'];

$data[0]['orderid'] = $_GET['orderid'];

$m->save($data[0]);

$dataOri[0]['orderid']=$newOrderid;

$m->save($dataOri[0]);

//跳转到显示项目列表页

$this->redirect('/News/index/p/'.$_GET['p']);

}else{

$this->redirect('/News/index/p/'.$_GET['p']);

}

}