/** * Show the form for creating a new resource. * * @param Request $request * @return \Illuminate\Http\Response */ public function find(Request $request) { $givenname = $request->input('givenname'); $surname = $request->input('surname'); $request->flashOnly('givenname', 'surname'); $holderQuery = Holder::with('animals.medications')->where('givenname', 'LIKE', $givenname)->orWhere('surname', 'LIKE', $surname); $holderSql = $holderQuery->toSql(); $holder = $holderQuery->first(); return view('home.index', ['holder' => $holder, 'sql' => $holderSql]); }