In this tutorial you will learn about the Laravel 8 Autocomplete Search from Database Tutorial and its application with practical example.
In this Laravel 8 Autocomplete Search using Jquery UI tutorial I will show you how to create autocomplete input or search box using jquery ui in laravel 8. In this tutorial you will learn to create autocomplete input box using jquery ui in laravel 8. In this article we will be creating dynamic database driven ajax jquery autocomplete in Laravel.
In this example we will be using autocomplete jquery ui plugin. The jquery autocomplete plugin is used to create dynamic autocomplete input with several options. In this example you will learn how to implement jquery autocomplete in laravel.
Laravel 8 Autocomplete Search from Database Tutorial
In this article, I will show you to create a dynamic database driven ajax jquery autocomplete in Laravel 8. You will also learn to create a dynamic search dropdown autocomplete which will fetch options from database table using jquery autocomplete.
- Step 1 – Install Laravel 8 App
- Step 2 – Database Configuration Database
- Step 3 – Make Model and Migration
- Step 4 – Make Routes
- Step 5 – Create Controller
- Step 6 – Create Blade View
- Step 7 – Implement jQuery Ajax Code
- Step 8 – Run Development Server
Step 1 – Install Laravel 8 App
First of all we need to create a fresh laravel project, download and install Laravel 8 using the below command
1 |
composer create-project --prefer-dist laravel/laravel blog |
Step 2 – Database Configuration Database
Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.
1 2 3 4 5 6 |
DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=here your database name here DB_USERNAME=here database username here DB_PASSWORD=here database password here |
Step 3 – Make Model and Migration
Now, in this step we will create model and migration file. Please run the following command:
1 |
php artisan make:model Product -m |
Now, open product.php file and add the following code into it, which is placed on app/model directory:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; class Product extends Model { use HasFactory; protected $fillable = [ 'name' ]; } |
After that, open create_products_tables.php and add the following code into it, which is placed on database/migration directory:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
<?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateProductsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('products', function (Blueprint $table) { $table->id(); $table->string('name'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('products'); } } |
Step 4 – Create Routes
After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.
routes/web.php
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
<?php use Illuminate\Support\Facades\Route; use App\Http\Controllers\AutoCompleteController; /* |-------------------------------------------------------------------------- | Web Routes |-------------------------------------------------------------------------- | | Here is where you can register web routes for your application. These | routes are loaded by the RouteServiceProvider within a group which | contains the "web" middleware group. Now create something great! | */ Route::get('search', [AutoCompleteController::class, 'index'])->name('search'); Route::get('autocomplete', [AutoCompleteController::class, 'autocomplete'])->name('autocomplete'); |
Step 5 – Create Controller
Now, lets create a controller named AutoCompleteController using command given below –
1 |
php artisan make:controller AutoCompleteController |
Then open AutoCompleteController.php and put the following code into this file, which is placed on app/http/controllers directory:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\Product; class AutoCompleteController extends Controller { /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { return view('autocomplete-search'); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function autocomplete(Request $request) { $res = Product::select("name") ->where("name","LIKE","%{$request->term}%") ->get(); return response()->json($res); } } |
Step 6 – Create Blade View
In this step we will create blade file, Go to resources/views directory and create blade view file name autocomplete-search.blade.php. Then put the following code into autocomplete-search.blade.php:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
<!DOCTYPE html> <html> <head> <title>Laravel 8 Autocomplete Textbox From Database with jQuery Ajax</title> <meta name="csrf-token" content="{{ csrf_token() }}"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"> <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"> <script src="https://code.jquery.com/jquery-1.12.4.js"></script> <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script> <script type="text/javascript"> var siteUrl = "{{url('/')}}"; </script> </head> <body> <div class="container mt-4"> <div class="card"> <div class="card-header text-center font-weight-bold"> <h2>Laravel 8 Autocomplete Textbox From Database using jQuery ajax</h2> </div> <div class="card-body"> <form name="autocomplete-textbox" id="autocomplete-textbox" method="post" action="#"> @csrf <div class="form-group"> <label for="exampleInputEmail1">Search Product By Name</label> <input type="text" id="name" name="name" class="form-control"> </div> </form> </div> </div> </div> <script src="{{ asset('auto.js') }}"></script> </body> </html> |
Step 7 – Implement jQuery Ajax Code
Then add the following code in auto.js file:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
$(document).ready(function() { $( "#name" ).autocomplete({ source: function(request, response) { $.ajax({ url: siteUrl + '/' +"autocomplete", data: { term : request.term }, dataType: "json", success: function(data){ var resp = $.map(data,function(obj){ return obj.name; }); response(resp); } }); }, minLength: 2 }); }); |
Step 8 – Run Development Server
Now we are ready to run our example so lets start the development server using following artisan command –
1 |
php artisan serve |
Now, open the following URL in browser to see the output –
1 |
http://localhost:8000/search |