/** * @return \Illuminate\View\View */ public function getList() { $currentUser = \Auth::user(); $userBooks = $currentUser->books; $freeBooks = Book::whereNull('user_id')->paginate(10); return view('books', ['userBooks' => $userBooks, 'freeBooks' => $freeBooks]); }
$results = \App\Book::whereBetween('pages_count', [170, 200])->get(); return $results; }); // Return all results that have title that exist in this array Route::get('book_get_whereIn', function () { $results = \App\Book::whereIn('title', ['My Third Book!', 'My Second Book!'])->get(); return $results; }); // Fetching all records with the where clause in conjunction with a column Name a.k.a magic Where Route::get('book_get_whereColumnName', function () { $results = \App\Book::whereTitle('My Fourth Book!')->get(); return $results; }); // Return all books that dont exist. .ie books that have the title column as NULL Route::get('book_get_whereNull', function () { $results = \App\Book::whereNull('title')->get(); return $results; }); /** * AGGREGATES */ // Get the number of books in the database Route::get('book_get_books_count', function () { $booksCount = \App\Book::count(); return $booksCount; }); // Get the number of books that have page count greater than 140 Route::get('book_get_bookPages_count', function () { $booksCount = \App\Book::where('pages_count', '>', 140)->count(); return $booksCount; });