Search functionality in Laravel – Just Laravel

Here we ‘ll see how to implement search functionality in Laravel. we ‘ll search the data from the database and show the search results in a table.

Working Demo      Project on Github

You can also watch this video on YouTube here

Search form :

First, let’s create a form for search field,

<form action="/search" method="POST" role="search">
    {{ csrf_field() }}
    <div class="input-group">
        <input type="text" class="form-control" name="q"
            placeholder="Search users"> <span class="input-group-btn">
            <button type="submit" class="btn btn-default">
                <span class="glyphicon glyphicon-search"></span>
            </button>
        </span>
    </div>
</form>

Search action :

When the search button is clicked, it goes to the route search where the logic for fetching data from database is present,

Route::any('/search',function(){
    $q = Input::get ( 'q' );
    $user = User::where('name','LIKE','%'.$q.'%')->orWhere('email','LIKE','%'.$q.'%')->get();
    if(count($user) > 0)
        return view('welcome')->withDetails($user)->withQuery ( $q );
    else return view ('welcome')->withMessage('No Details found. Try to search again !');
});

this logic searches the table User for name and email with the input we provide, here we use LIKE operator for searching data,
after fetching the data the data is sent to welcome view, along with the message when no search results are found.

Here all the logic is written in routes file itself, if we want to create a controller we can do it, here only just one simple logic, so we didn’t use a controller.

Search results :

Welcome view for showing search results will look like,

<div class="container">
    @if(isset($details))
        <p> The Search results for your query <b> {{ $query }} </b> are :</p>
    <h2>Sample User details</h2>
    <table class="table table-striped">
        <thead>
            <tr>
                <th>Name</th>
                <th>Email</th>
            </tr>
        </thead>
        <tbody>
            @foreach($details as $user)
            <tr>
                <td>{{$user->name}}</td>
                <td>{{$user->email}}</td>
            </tr>
            @endforeach
        </tbody>
    </table>
    @endif
</div>

The routes file looks like,

<?php
use App\User;
use Illuminate\Support\Facades\Input;

Route::get ( '/', function () {
    return view ( 'welcome' );
} );
Route::any ( '/search', function () {
    $q = Input::get ( 'q' );
    $user = User::where ( 'name', 'LIKE', '%' . $q . '%' )->orWhere ( 'email', 'LIKE', '%' . $q . '%' )->get ();
    if (count ( $user ) > 0)
        return view ( 'welcome' )->withDetails ( $user )->withQuery ( $q );
    else
        return view ( 'welcome' )->withMessage ( 'No Details found. Try to search again !' );
} );

for different types of routing check previous post on routing.

Now when someone queries the database, we can see the appropriate results.

Working Demo      Project on Github

Look at the screenshots below,

Search functionality in laravel – jusLaravel.comSearch functionality in laravel – jusLaravel.comSearch functionality in laravel – jusLaravel.comSearch functionality in laravel – jusLaravel.comSearch functionality in Laravel – justlaravel.com

Working Demo      Project on Github

That’s it, folks. We have successfully implemented simple search functionality for fetching data from database in Laravel.

Feel free to browse previous posts on custom authentication with validation, routing, and pagination.