I want to have a autocomplete search input with jQuery and Laravel. But I'm getting an error when the user write at least 2 letters in the search input:
GET http://proj.test/autocomplete-search?term=ca 500 (Internal Server Error)
Do you know where is the issue? I want to show the conferences based on the letters inserted by the user in the search form.
The search input:
<div class="col col-md-6">
<h4 class="text-white text-center font-weight-bold">Search</h4>
<form class="main-search">
<input type="text" id="search" class="autocomplete dropdown-toggle" placeholder="Conference, Citiy, Category">
</form>
</div>
Laravel routes:
Route::get('/autocomplete-search', 'AutocompleteController@search');
Laravel AutomcompleteController:
class AutocompleteController extends Controller
{
public function search(Request $request){
$search = $request->term;
$conferences = Conference::where('name', 'LIKE', '%'.$search.'%')->get();
$data= [];
foreach ($conferences as $key => $value){
$data[] = ['id'=>$value->id, 'value' => $value->id + " " + $value->name];
}
//dd($data);
return response($data);
}
}
jquery:
$("#search").autocomplete({
source: "{{ URL::to('autocomplete-search') }}",
minLength: 2,
select:function(key, value)
{
console.log(value);
}
});
EDIT: In the Network tab the error shows as:
{message: "A non-numeric value encountered", exception: "ErrorException",…}
and points to this line:
{function: "search", class: "App\Http\Controllers\AutocompleteController", type: "->"}". In "$data[] = ['id'=>$value->id, 'value' => $value->id + " " + $value->name];