/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id, Request $request) { $characters = Accounts::join('UsersChars', 'Accounts.CustomerID', '=', 'UsersChars.CustomerID')->where('UsersChars.CharID', $id)->get(); //$characters = UsersChars::where('UsersChars.CharID', $id)->get(); //dd($characters); return view('charactersView', compact('characters'))->with(['success' => $request->input('success')]); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function find(Request $request) { $accounts = Accounts::join('UsersData', 'Accounts.CustomerID', '=', 'UsersData.CustomerID')->where('Accounts.email', 'like', '%' . $request->input('search') . '%')->paginate(20); //->get(); //dd($accounts); return view('accounts', compact('accounts')); }