Search by Queries/Bugs/Errors

Laravel 9 pagination with search filter

Sometimes we have to filter data from a table in Laravel using the search keyword provided by users. Here we provide search functionality with pagination in Laravel 9.

Answers 1

Pagination with search filter in Laravel 9

//Run below command to make HomeController

php artisan make:controller HomeController

routes\web.php

use App\Http\Controllers\HomeController;
Route::any('/home', [HomeController::class, 'index'])->name('user');

app\Http\Controllers\HomeController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\User;
class HomeController extends Controller
{
    public function index(Request $request){
        $users = User::paginate(2);
        $search = $request->q;
        
        if($search!=""){
            $users = User::where(function ($query) use ($search){
                $query->where('name', 'like', '%'.$search.'%')
                    ->orWhere('email', 'like', '%'.$search.'%');
            })
            ->paginate(2);
            $users->appends(['q' => $search]);
        }
        else{
            $users = User::paginate(2);
        }

        return view('home', compact('users'));
    }
}

resources\views\home.blade.php

<form action="{{ route('user') }}" method="POST">
    @csrf
    <input type="text" name="q" placeholder="search by user name and email..." />
    <button type="submit"> Search </button>
</form>
<table class="table table-bordered">
    <thead>
        <tr>
            <th>First Name</th>
            <th>Email</th>
        </tr>
    </thead>
    <tbody>
        @foreach($users as $user)
        <tr>
            <td>{{ $user->name }}</td>
            <td>{{ $user->email }}</td>
        </tr>
        @endforeach
    </tbody>
</table>
<div>
    {{ $users->links() }}
</div>

You have to create a controller using php artisan make:controller HomeController.

Define route in web.php

Create controller method in HomeController class.

You also have to create a blade file home.blade.php in resources/views directory.

Back to code snippet queries related laravel

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Nodejs Php Python Sql Typescript Wordpress

Laravel 9 pagination with search filter

Pagination with search filter in Laravel 9

Give answer to above query by entering the title (optional) and body

Random Code Snippet Queries: Laravel

Related Queries

Laravel 9 pagination with search filter

Pagination with search filter in Laravel 9

Give answer to above query by entering the title (optional) and body

Random Code Snippet Queries: Laravel

Insert Link

Insert Image URL

Related Queries