How to bring only the latest records with Laravel 5.2

Question

Navigation

#1 by (4 votes)

2

I need to return the last 10 records for a view ..

return view('home.home', [
    'data' => $this->sale->get(), //aqui eu quero pegar os 10 últimos
    'nav' => 'dashboard'
]);

Is there any Eloquent method that does this?

laravel laravel-eloquent laravel-5

asked by anonymous 20.10.2016 / 15:59

1 answer

SELECT for date format dd / mm / yyyy hh: mm: ss Problems retrieving object from a json

score 4 · Accepted Answer

Has the method is take , but it's important that you do the sorting ( orderBy ), so you do not have surprises in the result.

$this->sale->orderBy('id','desc')->take(10)->get()

return view('home.home', [
    'data' => $this->sale->orderBy('id','desc')->take(10)->get(), 
    'nav' => 'dashboard'
]);