Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 2

By Hardik Savani | January 19, 2017 | | 12101 Viewer | Category : PHP Laravel Javascript Bootstrap jQuery MySql JSON Ajax


Share this post:


After complete 4 steps in our Part 1, we have to proceed next step from Part 2. In this part we write code for how to manage controller method and how to give response them. We also write code for view blade layout files.

This part is hart of "Laravel 5 dynamic autocomplete search using select2 JS Ajax" article, In this part you will see the logic of database and blade template. So you have to follow this bellow remaining steps.

Step 5: Create Controller

In this point, now we should create new controller as Select2AutocompleteController in this path app/Http/Controllers/Select2AutocompleteController.php. this controller will manage layout and select2 ajax request, So run bellow command for generate new controller:

php artisan make:controller Select2AutocompleteController

Ok, now put bellow content in controller file:

app/Http/Controllers/Select2AutocompleteController.php

<?php


namespace App\Http\Controllers;


use Illuminate\Http\Request;

use DB;


class Select2AutocompleteController extends Controller

{

/**

* Show the application layout.

*

* @return \Illuminate\Http\Response

*/

public function layout()

{

return view('select2');

}


/**

* Show the application dataAjax.

*

* @return \Illuminate\Http\Response

*/

public function dataAjax(Request $request)

{

$data = [];


if($request->has('q')){

$search = $request->q;

$data = DB::table("categories")

->select("id","name")

->where('name','LIKE',"%$search%")

->get();

}


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

}

}

Step 6: Create View

In Last step, let's create one blade file that will render view of autocomplete task. In this file i used cdn of bootstrap, jquery and select2 plugin.

resources/views/select2.blade.php

<html lang="en">


<head>

<title>Laravel 5 - Dynamic autocomplete search using select2 JS Ajax</title>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>

<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" />

<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" rel="stylesheet" />

<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>

</head>


<body>


<div class="container">


<h2>Laravel 5 - Dynamic autocomplete search using select2 JS Ajax</h2>

<br/>

<select class="itemName form-control" style="width:500px;" name="itemName"></select>


</div>


<script type="text/javascript">


$('.itemName').select2({

placeholder: 'Select an item',

ajax: {

url: '/select2-autocomplete-ajax',

dataType: 'json',

delay: 250,

processResults: function (data) {

return {

results: $.map(data, function (item) {

return {

text: item.name,

id: item.id

}

})

};

},

cache: true

}

});


</script>


</body>

</html>

Now we are ready to run our example so run bellow command ro quick run:

php artisan serve

Now you can open bellow URL on your browser:

http://localhost:8000/select2-autocomplete

I hope it can help you...







We are Recommending you: