lavarel框架增 删 改 查 以及 分页 搜索(搜索后分页)

//配置

.env配置文件里：

DB_HOST=127.0.0.1
DB_DATABASE=xiaoshixun2
DB_USERNAME=root
DB_PASSWORD=root

routes.php里路由：

Route::any('/','UserController@index' );
Route::any('add','UserController@add' );
Route::any('show','UserController@show' );
Route::any('del','UserController@del' );
Route::any('upd','UserController@upd' );
Route::any('update','UserController@update' );

//控制器里上面引入：

namespace App\Http\Controllers;
use App\User;
use App\Http\Controllers\Controller;
use DB;
use Symfony\Component\HttpFoundation\Request;
//use  Illuminate\Http\Request;

//控制器里面方法：

 //跳转添加页面方法
   public function index()
   {
       return view('user/index');
   }
   //执行添加
   public  function  add(Request $request){
       $username=$request->input('username');
       $pwd=$request->input('pwd');
      $res= DB::table('user')->insert([
           'username' =>$username,
           'pwd' =>$pwd,
       ]);
       if($res){
           return Redirect('show');
       }
       else{
           die('添加失败');
       }

   }
   //分页查询开始
   public function show(){
       $search = isset($_GET['search'])?$_GET['search']:"";//判断是否接过搜索值
       if($search)
       {
           $arr = DB::select("select * from user where username like '%$search%'");//带搜索条件查询
       }else{
           $arr = DB::table('user')->get();//不带搜索条件查询
       }
       //总条数
       $count = count($arr);
       //每页条数
       $mys = 3 ;
       //计算总页数
       $zys = ceil($count/$mys);
       //获取当前页
       $page = isset($_GET['page'])?$_GET['page']:1;
       //偏移量
       $pyl = ($page-1)*$mys;
       if($search)
       {
           $arr = DB::select("select * from user where username like '%$search%' limit $pyl,$mys");//带搜索分页条件查询
           /*foreach($arr as $key => $value) {
               $arr[$key]['username'] = str_replace($search, "<font color='red'>$search</font>", $value['username']);
           }*/
       }else{
           $arr = DB::table('user')->skip($pyl)->take($mys)->get();//带分页条件查询
       }
       //上一页
       $last = $page-1<1?1:$page-1;
       //下一页
       $next = $page+1>$zys?$zys:$page+1;
       // print_R($next);die;
       return view('user/show',['res'=>$arr,'search'=>$search,'last'=>$last,'next'=>$next,'sum_page'=>$zys,'page'=>$page]);
   }
 //分页查询结束
//删除
   public function del(Request $request){
       $id=$request->input('id');
       $res=DB::table('user')->where('id',$id)->delete();
       if($res==1){
           return redirect('show');
       }
   }
   //修改页面
   public function upd(Request $request){
       $id=$request->input('id');
      $arr=DB::table('user')->where('id',$id)->first();
       return view('user/upd',['arr'=>$arr]);
   }
   //执行修改
   public function update(Request $request){
       $id=$request->input('id');
       $username=$request->input('username');
       $pwd=$request->input('pwd');
       $res=DB::table('user')->where('id',$id)->update(array('username'=>$username,'pwd'=>$pwd));
       if($res==1){
           return redirect('show');
       }
   }

//添加页面

<center>
    <table>
        <form action="add" method="get">
            <tr>
                <td>用户名</td>
                <td><input type="text" name="username"/></td>
            </tr>
            <tr>
                <td>密码：</td>
                <td><input type="password" name="pwd"/></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="登录"/></td>
            </tr>
        </form>
    </table>
</center>

//展示页面

<center>
    <div id="div1">
        <input type="text" name="search" value="{{$search}}"/><button οnclick="page(<?php echo $page?>)">搜索</button>
        <table border="1">
        <tr>
            <td>ID</td>
            <td>用户名</td>
            <td>密码</td>
            <td>操作</td>
        </tr>
        @foreach($res as $key=>$val)
        <tr>
            <td>{{$val->id}}</td>
            <td>{{$val->username}}</td>
            <td>{{$val->pwd}}</td>
            <td><a href="{{url('del')}}?id={{$val->id}}">删除</a>||<a href="{{url('upd')}}?id={{$val->id}}">修改</a></td>
        </tr>
        @endforeach
    </table>
    当前页<?php echo $page?>共<?php echo $sum_page?>
    <a href="javascript:void (0)" οnclick="page(1)">首页</a>
    <a href="javascript:void (0)" οnclick="page(<?php echo $last?>)">上一页</a>
    <a href="javascript:void (0)" οnclick="page(<?php echo $next?>)">下一页</a>
    <a href="javascript:void (0)" οnclick="page(<?php echo $sum_page?>)">尾页</a>
    </div>
</center>
<script>
    //分页
    function page(page){
        var search=document.getElementsByName('search')[0].value;
        var ajax=new XMLHttpRequest();
        ajax.open('get','{{url('show')}}?page='+page+'&search='+search);
        ajax.send();
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4&ajax.status==200){
                document.getElementById('div1').innerHTML=ajax.responseText;
            }

        }
    }
</script>

//修改页面

<center>
    <table>
        <form action="{{url('update')}}" method="get">
            <input type="hidden" name="id" value="{{$arr->id}}"/>
            <tr>
                <td>用户名</td>
                <td><input type="text" name="username" value="{{$arr->username}}"/></td>
            </tr>
            <tr>
                <td>密码：</td>
                <td><input type="password" name="pwd" value="{{$arr->pwd}}"/></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="修改"/></td>
            </tr>
        </form>
    </table>
</center>