Laravel实现搜索的时候分页并携带参数
Laravel  /  管理员 发布于 7年前   132
筛选分页每页的条数: 路由: 后端接口: ##效果图: 前端完整代码:
Copyright·© 2019 侯体宗版权所有·
粤ICP备20027696号
Route::get('customer/index/{customer_type?}', 'CustomerController@index');
public function index($customer_type = null) { $search = request('search'); $perPage = request('perPage') ? request('perPage') : 10; $customer_type = $customer_type ? $customer_type : request('customer_type'); $data = Customer::select(['id', 'email', 'user_name', 'nick_name', 'phone', 'create_time']) ->where('customer_type', '=', $customer_type) ->where(function ($query) use ($search) { if ($search) { $query->where('user_name', 'like', '%' . $search . '%') ->orWhere('nick_name', 'like', '%' . $search . '%') ->orWhere('phone', 'like', '%' . $search . '%') ->orWhere('email', 'like', '%' . $search . '%'); } }) ->orderBy('create_time', 'desc') ->paginate($perPage); //追加额外参数,例如搜索条件 $appendData = $data->appends(array( 'search' => $search, 'customer_type' => $customer_type, 'perPage' => $perPage, )); return view('admin/customerList', compact('data')); }
@extends('admin.master')@section('content')