$books = \App\Book::skip(0)->take(2)->get();
return $books;
});
// Skip the first two records and take the next 3 records
Route::get('book_skip_and_take_again', function () {
$books = \App\Book::skip(2)->take(3)->get();
return $books;
});
// Order the books in ascending order according to their title, `desc` is also an alternative
Route::get('book_orderBy', function () {
$books = \App\Book::orderBy('title', 'asc')->get();
return $books;
});
// Group the books by the price...e.g if 3 books have thesame price, it groups them together as one
Route::get('book_groupBy', function () {
$books = \App\Book::groupBy('price')->get();
return $books;
});
// Return all books that have pages_count less than 150
Route::get('book_having', function () {
$books = \App\Book::having('pages_count', '<', 150)->get();
return $books;
});
// Return all books including the ones that have been deleted
// Listen: this requires your migration already has $table->softDeletes();
// and your Model also uses the Eloquent SoftDeletes trait
Route::get('all_books_including_those_that_have_been_deleted', function () {
$books = \App\Book::withTrashed()->get();
return $books;
});
// Return only all the books that have been deleted
