/** * search all posts base on the request value * * @param SearchRequest $request * @return \Illuminate\View\View */ public function getSearch(SearchRequest $request) { $states = State::all(); $value = $request->get('t'); /*$posts = Post::where('title', 'LIKE', '%' . $value . '%') ->orWhere('id', $value) ->orWhere('content', 'LIKE', '%' . $value . '%') ->whereNull('deleted_at')->paginate(config('traydes.posts_per_page'));*/ $posts = Post::where(function ($query) use($value) { $query->orWhere('id', $value); $query->orWhere('content', 'LIKE', '%' . $value . '%'); })->whereNull('deleted_at')->paginate(config('traydes.posts_per_page')); $count = $posts->total(); return view('index.view', ['posts' => $posts, 'value' => $value, 'count' => $count, 'states' => $states]); }
/** * delete a specific post * * @param Request $request * @return \Illuminate\Http\RedirectResponse */ public function postRemovePost(Request $request) { $post = Post::find($request->get('id')); $post->delete(); return redirect('user/my-posts')->with('success', 'Post Successfully Deleted'); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($cat_id, $id) { $post = Post::find($id); return view('user.posts.show', ['post' => $post]); }