public function index(Request $request) { $search = \Request::get('search'); //<-- we use global request to get the param of URI if ($search) { $allCostStatus = CostStatus::whereRaw('status_name = ?', [$search])->orderBy('id', 'asc')->paginate(5); } else { $allCostStatus = CostStatus::orderBy('id', 'asc')->paginate(5); } return view('CostStatus.index', ['CostStatuses' => $allCostStatus]); }