/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $search = \Request::get('search'); //<-- we use global request to get the param of URI if ($search) { $allCompanies = Company::whereRaw('store_name = ?', [$search])->orderBy('id', 'desc')->paginate(5); } else { $allCompanies = Company::orderBy('id', 'desc')->paginate(5); } return view('company.index', ['companies' => $allCompanies]); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $requested = Input::get('request'); if ($requested == null || $requested == '' || $requested == 'showAll') { $companies = Company::orderBy('name')->paginate(15); $keyword = ''; } else { $keyword = Input::get('keyword'); $companies = Company::whereRaw('name like ? order by name', array('%' . $keyword . '%'))->paginate(15)->appends(Input::except('page')); } return view('company.list', compact('companies', 'keyword')); }