Skip to content

Instantly share code, notes, and snippets.

@winex01
Forked from imranismail/autocomplete.php
Created November 7, 2017 03:37
Show Gist options
  • Save winex01/715a5fdd9ba53c21dd18387b5a7bf1b1 to your computer and use it in GitHub Desktop.
Save winex01/715a5fdd9ba53c21dd18387b5a7bf1b1 to your computer and use it in GitHub Desktop.
Laravel And JqueryUI's Autocomplete Plugin
//SearchController.php
public function autocomplete(){
$term = Input::get('term');
$results = array();
$queries = DB::table('users')
->where('first_name', 'LIKE', '%'.$term.'%')
->orWhere('last_name', 'LIKE', '%'.$term.'%')
->take(5)->get();
foreach ($queries as $query)
{
$results[] = [ 'id' => $query->id, 'value' => $query->first_name.' '.$query->last_name ];
}
return Response::json($results);
}
//View
{{ Form::open(['action' => ['SearchController@searchUser'], 'method' => 'GET']) }}
{{ Form::text('q', '', ['id' => 'q', 'placeholder' => 'Enter name'])}}
{{ Form::submit('Search', array('class' => 'button expand')) }}
{{ Form::close() }}
//Route
Route::get('search/autocomplete', 'SearchController@autocomplete');
//Javascript
$(function()
{
$( "#q" ).autocomplete({
source: "search/autocomplete",
minLength: 3,
select: function(event, ui) {
$('#q').val(ui.item.value);
}
});
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment