Level 1
thank you all, I have solved this problem I add '%' in value and now it works.
public function fetchingPage(Request $request)
{
$req = $this->request->filter;
$query = Page::where('extras', null);
if ($this->request->has('sort')) {
$sorts = explode(',', $this->request->sort);
foreach ($sorts as $sort) {
list($sortCol, $sortDir) = explode('|', $sort);
$query = $query->orderBy($sortCol, $sortDir);
}
} else {
$query = $query->orderBy('id', 'desc');
}
if ($this->request->filter) {
$query->where(function ($q) use($req) {
$value = $this->request->filter;
$q->where('name', 'like', '%'.$value.'%')
->orWhere('template', 'like', '%'.$value.'%')
->orWhere('slug', 'like', '%'.$value.'%');
});
}
$perPage = $this->request->has('per_page') ? (int) $this->request->per_page : null;
$page = $query->paginate($perPage);
$page->makeVisible(['name', 'template']);
return $page;
}