order('sort desc') ->paginate(10); $this->assign('list',$list); return view(); } public function add(){ if(request()->isPost()){ $user = new LinksModel(); $data = input('post.'); $where=[ 'title'=>$data['title'], ]; $links = $user->where($where)->find(); if(empty($links)){ $user->save($data); return 1; }else{ return 2;//标题不能重复 } } return view(); } public function edit(){ $user = new LinksModel(); $id = input('id'); $list = $user->where('id',$id)->find(); if(request()->isPost()){ $data = input('post.'); if($user->update($data)){ return 1;//修改成功 }else{ return 2;//修改失败 } } $this->assign([ 'list'=>$list, ]); return view(); } public function del(){//删除 $user = new LinksModel(); $id = input('id'); $del=$user->where('id',$id)->delete(); if($del){ return ['data'=>200,'msg'=>'删除成功']; }else{ return ['data'=>0,'msg'=>'删除失败']; } } //更新排序 public function sort(){ if(request()->isPOST()){ $data=input(); //获取ajax提交所有数据 $table=db('links'); //要更新的表 $cate=new Catetree; //实例化拓展类 使用排序方法 $cate->cateSort($data['sort'],$table); return 1; } } }