/** * GET /posts * Get a listing of all posts. * * @return Response */ public function index() { $posts = $this->post->with('tags', 'series')->published()->latest()->paginate(10); $page = Input::get('page'); $title = $page ? "All posts (Page {$page})" : 'All posts'; return View::make('posts.index', compact('posts'))->withTitle($title); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $post = Post::where('id', '=', $id)->first(); $answer = Post::where('id', '=', $post->accepted_answer_id)->first(); $answers = Post::with(array('votes'))->where('parent_id', '=', $post->id)->where('id', "<>", $post->accepted_answer_id)->get(); $tags = Tag::all(); $data = array('post' => $post, 'answer' => $answer, 'answers' => $answers, 'tags' => $tags); return View::make('public.question.index', $data); }
/** * Display posts by category */ public function getByCategory($category = 'all') { if ($category == 'all') { $posts = Post::with('user')->orderBy('id', 'desc')->paginate(15); } else { $posts = Post::with('user')->where('category', $category)->orderBy('id', 'desc')->paginate(15); } return View::make('posts.index')->with(['posts' => $posts, 'category' => $category]); }
public function postsApi() { $posts = \Post::with(['user' => function ($query) { // getting the ID field is necessary $query->select(['id', 'username']); // user_id is required to enable eager loading }])->get(['id', 'title', 'status', 'user_id']); return \Response::json($posts); }
public function index() { // hard-coding autologin of User #2, // so we don't have to implement Auth for the scope of this demo. $user = User::find(2); Auth::login($user); // get recent posts, and eager load texts $posts = Post::with('text')->orderBy('created_at', 'desc')->get(); $this->layout->content = View::make('home')->with('posts', $posts); }
public function show($id) { $user = User::find($id); $posts = Post::with('user')->where('user_id', $id)->orderBy('created_at', 'desc')->paginate(4); if ($user != null) { return View::make('showuser')->with('user', $user)->with('posts', $posts); } else { App::abort(404); } }
public function index() { // Eloquent collection // $posts = Post::all(); $posts = Post::with('user')->paginate(2); // Pagination collection // $perPage = Input::get('per-page'); you then pass $perpage into the paginate // $posts = Post::paginate(2); return View::make('posts.index')->with(array('posts' => $posts)); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $query = Post::with('user'); if (Input::has('search')) { $query->where('title', 'like', '%' . Input::get('search') . '%'); $query->orWhere('body', 'like', '%' . Input::get('search') . '%'); } $posts = $query->orderBy('id', 'desc')->paginate(14); return View::make('posts.index')->with('posts', $posts); }
/** * Define your route model bindings, pattern filters, etc. * * @param \Illuminate\Routing\Router $router * @return void */ public function boot(Router $router) { parent::boot($router); $router->bind('post', function ($value) { return Post::with('user')->where('slug', $value)->first(); }); $router->bind('comment', function ($value) { return Comment::with('user')->where('id', $value)->first(); }); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { if (Auth::id() != $id) { Log::info('This user id is not equal'); return Redirect::action('UsersController@show', Auth::id()); } $post = Post::with('user')->get(); $user = User::find($id); return View::make('users.edit', compact('user')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $query = Post::with('user'); if (Input::has('search')) { $search = Input::get('search'); $query->where('title', 'like', "%{$search}%")->orWhere('body', 'like', "%{$search}%"); } $posts = $query->orderBy('created_at', 'desc')->paginate(5); return View::make('posts.index')->with('posts', $posts); }
/** * Display a listing of the resource. * * @return Response */ public function index() { // $posts = Post::paginate(4); // $data = array( // 'posts'=> $posts // ); // return View::make('posts.index')->with($data); $posts = Post::with('user')->orderBy('created_at', 'desc')->paginate(4); return View::make('posts.index')->with('posts', $posts); }
public function blog($page = 1) { $limit = 5; $offset = ($page - 1) * $limit; $posts = Post::take($limit)->skip($offset)->active()->orderBy('created_at', 'desc')->get(); Paginator::setBaseUrl(Config::get('app.url') . '/blog'); Paginator::setCurrentPage($page); $totalItems = Post::with('id')->active()->count(); $paginator = PrettyPaginator::make($posts->toArray(), $totalItems, $limit); return View::make('blog.blog', ['posts' => $posts, 'paginate' => $paginator]); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $search = Input::get('search'); if ($search) { $query = Post::with('user')->where('title', 'LIKE', '%' . $search . '%')->orWhere('body', 'LIKE', '%' . $search . '%')->orWhere('location', 'LIKE', '%' . $search . '%'); } else { $query = Post::with('user'); } $posts = $query->orderBy('created_at', 'desc')->paginate(30); return View::make('posts.index')->with(['posts' => $posts, 'search' => $search]); }
public function search() { $search = Input::get('search'); $searchTerms = explode(' ', $search); $queryPost = Post::with('user'); foreach ($searchTerms as $term) { $queryPost->where('title', 'LIKE', '%' . $term . '%')->orWhere('content', 'LIKE', '%' . $term . '%'); } $posts = $queryPost->orderBy('created_at', 'desc')->get(); $tags = Tag::with('posts')->paginate(8); return View::make('search', compact('posts', 'tags')); }
public function newPosts() { if (Auth::check()) { $auth_user_id = Auth::user()->id; $posts = Post::with(array('user', 'follows' => function ($query) use($auth_user_id) { $query->where('user_id', '=', $auth_user_id); }))->orderBy('created_at', 'desc')->paginate(25); } else { $posts = Post::with('user')->paginate(25); } return View::make('new', compact('posts')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { //show all listings here $query = Post::with('user'); $search = Input::get('search'); if (Input::has('search')) { $query->where('title', 'like', '%' . $search . "%")->orWhere('body', 'like', '%' . $search . "%")->orWhereHas('user', function ($q) use($search) { $q->where('first_name', 'like', '%' . $search . "%")->orWhere('last_name', 'like', '%' . $search . "%"); }); } $posts = $query->orderBy('created_at', 'desc')->paginate(10); return View::make('posts.index')->with('posts', $posts); }
public function index() { $query = Post::with('user'); if (Input::has('search')) { $query->where('title', 'like', '%title%'); $query->orWhere('body', 'like', '%body%'); $query->orWhereHas('user', function ($q) { $q->where('email', 'like', '%bee%'); }); } $posts = $query->paginate(4); // $posts = Post::with('user')->orderBy('updated_at', 'desc')->paginate(4); return View::make('posts.index')->with('posts', $posts); }
public function search() { $search = Input::get('search'); $searchTerms = explode(' ', $search); $queryPost = Post::with('user'); $queryUser = User::with('post'); foreach ($searchTerms as $term) { $queryPost->where('title', 'LIKE', '%' . $term . '%')->orWhere('body', 'LIKE', '%' . $term . '%')->orWhere('location', 'LIKE', '%' . $term . '%'); $queryUser->where('username', 'LIKE', '%' . $term . '%')->orWhere('email', 'LIKE', '%' . $term . '%')->orWhere('location', 'LIKE', '%' . $term . '%'); } $resultsPost = $queryPost->orderBy('created_at', 'desc')->get(); $resultsUser = $queryUser->orderBy('created_at', 'desc')->get(); return View::make('search')->with(['resultsPost' => $resultsPost, 'resultsUser' => $resultsUser]); }
public function displayAllPosts() { $postViews = array(); $posts = Post::with('author', 'tags')->get(); foreach ($posts as $post) { Log::debug('Rendering a post: Title = ' . $post->title . '; Author = ' . $post->author->name . '; Created at = ' . $post->created_at . '; Tags:'); foreach ($post->tags as $tag) { Log::debug('Tag = ' . $tag->name); } $postView = View::make('post')->with('post', $post)->with('author', $post->author)->with('tags', $post->tags); array_push($postViews, $postView); } return View::make('home')->with('posts', $postViews); }
public function displayTag($tag) { $query = Post::with('user'); if (strpos($tag, "+")) { $firstKey = substr($tag, 0, strpos($tag, "+")); $query->where('tags', '=', "{$firstKey}"); $query->orWhere('tags', 'like', '%' . "{$firstKey}" . '%'); } else { $query->where('tags', '=', "{$tag}"); $query->orWhere('tags', 'like', '%' . "{$tag}" . '%'); } $showQuery = $query->orderBy('created_at', 'desc')->paginate(5); return View::make('/tag')->with('tags', $showQuery); }
/** * View a blog post. * * @param string $slug * @return View * @throws NotFoundHttpException */ public function getView($slug) { // Get this blog post data $post = Post::with('comments', 'author')->where('slug', $slug)->first(); // Check if the blog post exists if (is_null($post)) { // If we ended up in here, it means that a page or a blog post // don't exist. So, this means that it is time for 404 error page. return App::abort(404); } // Get this post comments $comments = $post->comments()->with('author')->orderBy('created_at', 'DESC')->get(); // Show the page return View::make('frontend/blog/view-post', compact('post', 'comments')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $query = Post::with('user'); $search = Input::get('search'); if ($search) { $query->where('title', 'like', "%{$search}%"); $query->orWhere('subtitle', 'like', "%{$search}%"); $query->orWhere('body', 'like', "%{$search}%"); $query->orWhereHas('user', function ($q) use($search) { $q->where('email', 'like', "%{$search}%"); }); } $posts = $query->orderBy('updated_at', 'desc')->paginate(4); return View::make('blog')->with('posts', $posts); }
public function modifView($post_id) { $post_id = strip_tags($post_id); $post_id = intval($post_id); $post_id = filter_var($post_id, FILTER_VALIDATE_INT); $post = Post::with('category', 'user')->where('post_id', '=', $post_id)->get(); $action = str_replace(':post_id', $post_id, $this->app->urlFor('post_modif')); $cancel = $this->app->urlFor('posts'); $categories = Category::orderBy('category')->get(); if (isset($_SESSION['vars'])) { unset($_SESSION['vars']); } $this->view = new PostModif($post, $action, $cancel, $categories); $this->view->display(); }
public function index() { $query = Post::with('user'); if (Input::has('search')) { $search = Input::get('search'); $query->where('title', 'like', "%{$search}%"); $query->orWhere('content', 'like', "%{$search}%"); // $query->whereHas('user', function($q){ // $q->where('email', 'like', '%codeup%'); // }); } $posts = $query->orderBy('created_at', 'desc')->paginate(4); $data = array('posts' => $posts); return View::make('posts.index')->with($data); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $query = Post::with('user'); if (Input::has('search')) { $query->where('title', 'like', '%' . Input::get('search') . '%'); $query->orWhere('description', 'like', '%' . Input::get('search') . '%'); } if (Request::wantsJson()) { $posts = $query->orderBy('created_at', 'desc')->get(); return Response::json($posts); } else { $posts = $query->orderBy('created_at', 'desc')->paginate(4); return View::make('posts.index', array('posts' => $posts)); } }
/** * Display a listing of the resource. * * @return Response */ public function index() { //----> possible chaining of queries with laravel // $query = Post::with('user'); //---> to check if there is a search (use Input::get and put that variable inside of the queries like title 1) //if (Input::has('search')) { // $query->where('title', 'like', '%title 1'); // $query->orWhere('body', 'like', '%body 1'); // whereHas takes in 2 parameters, 1 function name like user, 2 function q // $query->orWhereHas('user', function($q){ // $q->where('email','like', '%codeup%'); // }) //} // $posts = $query->paginate(4); $posts = Post::with('user')->paginate(5); return View::make('index')->with(['posts' => $posts]); }
/** * Display the specified resource. * * @param int $postIdOrTitle * @return Response */ public function show($postIdOrTitle) { if (is_numeric($postIdOrTitle)) { $post = Post::with('user', 'postType')->where('id', '=', $postIdOrTitle)->first(); if (!$post) { App::abort(404); return Redirect::action('PostsController@index'); } } else { $post = Post::with('postType')->where('slug_title', '=', $postIdOrTitle)->first(); if (!$post) { App::abort(404); return Redirect::action('PostsController@index'); } } return View::make('posts.show')->with('post', $post); }
/** * Display a listing of the resource. * * @return Response */ public function index() { // $posts = Post::with('user')->paginate(4); // return View::make('posts.index')->with('posts', $posts); if (Input::has('search')) { $search = Input::get('search'); $posts = Post::with('user')->where('title', 'LIKE', "%{$search}%")->orWhere('body', 'LIKE', "%{$search}%")->orderBy('title', 'asc')->paginate(5); if ($posts->count() == 0) { Session::flash('errorMessage', 'Search not found'); return Redirect::action('PostsController@index'); } return View::make('posts.index')->with('posts', $posts); } else { $posts = Post::with('user')->paginate(5); return View::make('posts.index')->with('posts', $posts); } }
/** * Display a listing of the resource. * * @return Response */ public function index() { $query = Post::with('user'); if (Input::has('search')) { $search = Input::get('search'); $query->where('title', 'like', "%{search}")->orWhere('content', 'like', "%{search}%"); } $query->orderBy('created_at', 'desc'); // gives us back a collection - eloquent collection // $posts = Post::all(); // gives us a a pagination collection: // $posts = Post::paginate(4); // gives us back a builder collection: $posts = Post::with('user')->orderBy('created_at', 'desc')->paginate(3); return View::make('posts.index')->with('posts', $posts); // ****add search box**** }