Laravel 6 autocomplete search example tutorial

February 2, 2020 XpertPhp Comments 0 Comment

In this article, We will explain to you how to create ajax autocomplete search example in laravel 6 using typeahead js. we can easily create the ajax autocomplete example using jquery in laravel 6.

Now, we will use bootstrap typeahead js. The bootstrap typeahead js provides inbuilt functionality, so we can easily create dynamic bootstrap autocomplete search examples in laravel.

So let’s follow the below step.

Overview
Step 1: Install Laravel
Step 2: Setting Database Configuration
Step 3: Create Table using migration
Step 4: Create Route
Step 5: Create a Model and Controller
Step 6: Create Blade Files
Step 7: Run The Application

Step 1: Install Laravel
We are going to install laravel 6, so first open the command prompt or terminal and go to xampp htdocs folder directory using the command prompt. after then run the below command.

composer create-project --prefer-dist laravel/laravel laravel6_autocomplete

1	composer create-project --prefer-dist laravel/laravel laravel6_autocomplete

Step 2: Setting Database Configuration
After the complete installation of laravel. we have to database configuration. now we will open the .env file and change the database name, username, password in the .env file. See below changes in a .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name(laravel6_autocomplete)
DB_USERNAME=Enter_Your_Database_Username(root)
DB_PASSWORD=Enter_Your_Database_Password(root)

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name(laravel6_autocomplete)

DB_USERNAME=Enter_Your_Database_Username(root)

DB_PASSWORD=Enter_Your_Database_Password(root)

Step 3: Create Table using migration
Now, We need to create a migration. so we will below command using create the students table migration.
After complete migration. we need below changes in the database/migrations/create_students_table file.

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateStudentsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('students', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('first_name');
            $table->string('last_name');
            $table->string('email');
            $table->string('mobile');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('students');
    }
}
?>

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateStudentsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('students', function (Blueprint $table) {

$table->bigIncrements('id');

$table->string('first_name');

$table->string('last_name');

$table->string('email');

$table->string('mobile');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('students');

}

Run the below command. after the changes above file.

php artisan migrate

1	php artisan migrate

Step 4: Create Route
Add the following route code in the “routes/web.php” file.

<?php
/*
|--------------------------------------------------------------------------
| 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('student', 'StudentController@index');
Route::get('autocomplete', 'StudentController@autocomplete')->name('autocomplete');
?>

<?php

|--------------------------------------------------------------------------

| 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('student', 'StudentController@index');

Route::get('autocomplete', 'StudentController@autocomplete')->name('autocomplete');

Step 5: Create a Model and Controller
Here below command help to create the controller and model.

php artisan make:controller StudentController --resource --model=Student

1	php artisan make:controller StudentController --resource --model=Student

Student.php

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Student extends Model
{
    protected $fillable = [
        'first_name',
        'last_name',
        'email',
        'mobile'
    ];
}
?>

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Student extends Model

{

protected $fillable = [

'first_name',

'last_name',

'email',

'mobile'

];

}

StudentController.php

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Validator,Redirect,Response,File;
use App\Student;

class StudentController extends Controller
{
    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('student');
    }


    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Http\Response
     */
    public function autocomplete(Request $request)
    {
	$search_text = $request->get('query');
        $student_data = Student::where('name', 'LIKE', '%'. $search_text. '%')->get();
        return response()->json($student_data);
    }
}
?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator,Redirect,Response,File;

use App\Student;

class StudentController extends Controller

{

/**

* Show the application dashboard.

* @return \Illuminate\Http\Response

public function index()

{

return view('student');

}

/**

* Show the application dashboard.

* @return \Illuminate\Http\Response

public function autocomplete(Request $request)

{

$search_text = $request->get('query');

$student_data = Student::where('name', 'LIKE', '%'. $search_text. '%')->get();

return response()->json($student_data);

}

Step 6: Create Blade Files
So finally, first we will create the student.blade.php files in “resources/ views/student/” directory.

<DOCTYPE html>
<html>
<head>
    <title>Laravel 6 Autocomplete Search Example Tutorial</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-3-typeahead/4.0.1/bootstrap3-typeahead.min.js"></script>  
	<script type="text/javascript">
		var path = "{{ route('autocomplete') }}";
		$('input.typeahead').typeahead({
			source:  function (query, process) {
				return $.get(path, { query: query }, function (data) {
					return process(data);
				});
			},
			highlighter: function (item, data) {
				var parts = item.split('#'),
				html = '<div class="row">';
				html += '<div class="col-lg-12">';
				html += '<span>'+data.first_name+' '+'+data.last_name+'</span>';
				html += '</div>';
				html += '</div>';
				return html;
			}
		});
	</script>
</head>
<body>
<div class="container">
  <h2>Laravel 6 Autocomplete Search Example Tutorial</h2> 
        <div class="form-group">
            <input type="text" class="form-control typeahead">
        </div>
    </div>
</body>
</html>

<html>

<head>

<title>Laravel 6 Autocomplete Search Example Tutorial</title>

var path = "{{ route('autocomplete') }}";

$('input.typeahead').typeahead({

source: function (query, process) {

return $.get(path, { query: query }, function (data) {

return process(data);

});

highlighter: function (item, data) {

var parts = item.split('#'),

html = '<div class="row">';

html += '<div class="col-lg-12">';

html += '<span>'+data.first_name+' '+'+data.last_name+'</span>';

html += '</div>';

return html;

}

});

</script>

</head>

<body>

<h2>Laravel 6 Autocomplete Search Example Tutorial</h2>

</div>

</body>

</html>

Step 7: Run The Application
So finally, first we will create the image.blade.php files in “resources/ views/student/” directory.

php artisan serve

1	php artisan serve

Now we will run our example using the below Url in the browser.

http://127.0.0.1:8000/student

1	http://127.0.0.1:8000/student

Please follow and like us:

Related posts: