点击搜索跳转到当前页面并刷新table内容

港控/mmm° 2023-02-12 08:28 13阅读 0赞

如下图：当我们点击搜索时，跳转到当前页面并刷新table内容  
可以这样来做：

带上搜索时的参数即可。当跳转到后台后自动按条件去搜索内容，然后输出table中不一样的数据。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQzMzk3MA_size_16_color_FFFFFF_t_70]  
后台代码：

public function userList()
        { 
    // print_r(request()->param());
    
            $product_name = request()->param()['product_name']??'';
            $role_name = request()->param()['role_name']??'';
    
            $user_info = db('user')->alias('u')
                ->join('role r','u.role_id=r.id')
                ->field('u.id, u.name,u.phone,u.email,u.remarks,u.create_time,r.name as role_name')
                ->order('u.id aec');
            if(!empty($product_name)){ 
                $user_info = $user_info->where('u.name','like','%'.$product_name.'%');
            }
            if(!empty($role_name)){ 
                $user_info = $user_info->where('u.role_id',$role_name);
            }
    
            $user_info = $user_info->where(['u.is_del'=>0])
                        ->paginate(10);
    
            $role_info = db('role')
                ->field('id, name')
                ->where(['is_del'=>0])
                ->select();
    
    
            $this->assign('role_info', $role_info);
    
    
            $this->assign('user_info', $user_info);
    
            return view('user/userlist');
        }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQzMzk3MA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200525155617281.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjQzMzk3MA==,size_16,color_FFFFFF,t_70