yii框架里ajax分页和搜索 单删 批删

//视图层：

   //上面

<center>
    <div id="div1">
        <input type="text" name="search" value="{{$search}}"/><button οnclick="page(<?php echo $page?>)">搜索</button>
        <table border="1">

 //中间
<td><a href="javascript:void(0)" id="<?php echo $val['id']?>" οnclick="del(this);">删除</a></td>
 </table>
<input type="button" value="批量删除" οnclick="check_del();">
 当前页<?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;
            }

        }
    }
//单删
function del(obj){
    var ids=obj.id;//接id
    ajax=new XMLHttpRequest();//创建ajax
    ajax.open("get","?r=home/del&ids="+ids);
    ajax.send(null);
    ajax.onreadystatechange=function(){
        if(ajax.readyState==4&&ajax.status==200){
            location.href='?r=home/show';
        }
    };
}
//批删
function check_del()
{
    var ids=document.getElementsByName("check[]");//接id
    var str='';//定义一个空变量
    for(var i=0;i<ids.length;i++)
    {
        if(ids[i].checked)
        {
            str=str+','+ids[i].value;
        }
    }
    new_str=str.substr(1);//截取
   // alert(new_str);
    ajax=new XMLHttpRequest();
    ajax.open("get","?r=home/delany&new_str="+new_str);
    ajax.send(null);
    ajax.onreadystatechange=function(){
        if(ajax.readyState==4&&ajax.status==200){
            location.href='?r=home/show';
        }
    }
}

 </script>
//控制器里面方法
  
//分页查询开始
  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");//带搜索分页条件查询
          
     }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 actionDel($ids=""){
    $request=\Yii::$app->request;
    $db=\Yii::$app->db;
    $id=$request->get('ids');
    $res=$db->createCommand("delete from goods where id='$id'")->execute();
    //添加日志
    $session=\Yii::$app->session;
    $suser=$session['us'];
    $content="删除了"."id为".$id."的数据";
    $time=date("Y-m-d H:i:s",time());
    $brr=$db->createCommand()->insert("active",[
        "suser"=>$suser,
        "content"=>$content,
        "time"=>$time,
    ])->execute();
    if($res && $brr){
        echo 1;
    }
    else{
        echo 2;
    }

}
//批删
public function actionDelany(){
    $request=\Yii::$app->request;
    $db=\Yii::$app->db;
    $ids=$request->get('new_str');
    //print_r($ids);die;
    $res=$db->createCommand("delete from goods where id in($ids)")->execute();
    //添加日志
    $session=\Yii::$app->session;
    $suser=$session['us'];
    $content="删除了"."id为".$ids."的数据";
    $time=date("Y-m-d H:i:s",time());
    $brr=$db->createCommand()->insert("active",[
        "suser"=>$suser,
        "content"=>$content,
        "time"=>$time,
    ])->execute();
    if($res&&$brr){
        echo 1;
    }
    else{
        echo 2;
    }
}