使用Laravel分页的表搜索

use Illuminate\Support\Facades\DB;
use Illuminate\Pagination\Paginator;

public function index()
{
    $data = DB::table('table_name')->paginate(10);
    return view('index', ['data' => $data]);
}

@foreach($data as $item)
    // 显示数据
@endforeach

{{ $data->links() }}

use Illuminate\Support\Facades\DB;

public function search(Request $request)
{
    $keyword = $request->input('keyword');
    $data = DB::table('table_name')->where('column_name', 'like', '%'.$keyword.'%')->paginate(10);
    return view('search', ['data' => $data]);
}

<form action="{{ route('search') }}" method="GET">
    <input type="text" name="keyword" placeholder="请输入关键词">
    <button type="submit">搜索</button>
</form>

@foreach($data as $item)
    // 显示搜索结果
@endforeach

{{ $data->links() }}