I have write code of search bar in laravel, I am doing pagination manually, but my search function is not working,
here is my code of view file
<form action="{{url('search-department')}}" method="GET" role="search">
<div class="form-group">
<input type="text" class="form-control" name="q" placeholder="Search Department">
</div>
</form>
My Controller File Is
//Code For Insert record in collection
public function storeDepartment(Request $request)
{
$department = new Department();
$department->createdBy = $request->get('createdBy');
$department->nameOfDepartment = $request->get('nameOfDepartment');
$department->save();
return redirect('list-department')->with('Success', 'Department Added Successfully!');
}
//Code For Seach
public function search(Request $request)
{
$q = Input::get('q');
if ($q != '') {
$listOfDepartment = Department::where('nameOfDepartment', 'like', '%' . $q . '%')
->orwhere('createdBy', 'like', '%' . $q . '%')
->paginate(2);
if (count($listOfDepartment) > 0) {
return view('pages.department')->withData($listOfDepartment);
}
// return view('pages.department')->withMessage("No Data Found");
}
}
and route is
Route::get('search-department', 'DepartmentController@search');
I think You should try this code.
In view
<form role="search" method="GET">
<div class="form-group">
<input type="hidden" name="_token" value="{{csrf_token()}}">
<input type="text" class="form-control" name="q" placeholder="Search Department">
</div>
</form>
And in Controller
public function search(Request $request)
{
$listOfDepartment = Department::select('*');
if(isset($request->q) && !empty($request->q))
{
$q = $request->q;
$listOfDepartment = $listOfDepartment->where('nameOfDepartment', 'like', '%' . $q . '%');
$listOfDepartment = $listOfDepartment->orWhere('createdBy', 'like', '%' . $q . '%');
}
$listOfDepartment = $listOfDepartment->->paginate(2);
if (count($listOfDepartment) > 0) {
return view('pages.department')->withData($listOfDepartment);
}
// return view('pages.department')->withMessage("No Data Found");
}
Hope This will help you.