Select the first 10 rows - Laravel Eloquent

Question

So far I have the following model:

class Listing extends Eloquent {
     //Class Logic HERE
}

I want a basic function that retrieves the first 10 rows of my table "listings" and passes them on to the view (via a controller?).

I know this a very basic task but I can't find a simple guide that actually explains step-by-step how to display a basic set of results, whilst detailing what is required in the model, controller and view files.

score 155 · Accepted Answer · edited Apr 30 '19 at 15:17

155

First you can use a Paginator. This is as simple as:

$allUsers = User::paginate(15);

$someUsers = User::where('votes', '>', 100)->paginate(15);

The variables will contain an instance of Paginator class. all of your data will be stored under data key.

Or you can do something like:

Old versions Laravel.

Model::all()->take(10)->get();

Newer version Laravel.

Model::all()->take(10);

For more reading consider these links:

edited Apr 30 '19 at 15:17

Ruitjes

29
7

answered Jan 21 '14 at 10:41

Vit Kos

5,535
5
44
58

Thank you Vit, I was unaware Laravel had this feature and it's exactly what I am looking for. – Jonnerz Jan 21 '14 at 10:45
3

I think you'll find its: ->take(10)->get(); – Joeri Jul 14 '14 at 17:08
@Joeri sure that is, updated the answer to be precise, thank you. – Vit Kos Jul 23 '14 at 10:50
9

I think the `get();` argument has now gone on the newer versions laravel – Billy May 30 '15 at 13:53
2

I used `Model::take(10)->get()` without problems on 5.2 – james2doyle Sep 14 '16 at 18:33
2

`Model::take(10)->get();` is not working in laravel 5.4 – Adarsh Sojitra Jul 07 '17 at 08:28
Well, @AdarshSojitra, the documentation says it is still possible, checkout the Eloquent section of the docs http://joxi.ru/nAyoDzhYNM99mZ – Vit Kos Jul 07 '17 at 13:21
Another option is to get the underlying QB object and apply to it directly , – Vit Kos Jul 07 '17 at 13:22
Too few arguments to function Illuminate\Support\Collection::get(), 0 passed in C:\Users\saber\Documents\saberprojects\behplus\survey-service\database\factories\TaggableFactory.php on line 28 and at l east 1 expected – saber tabatabaee yazdi May 30 '21 at 14:31
Using all() is a wast of time and resources cause before load all the table and then get only the first 10 `Modell::take(10)->get()` is much faster – Stefano Martini Jan 05 '22 at 09:41
```fetching ::all() ``` already fetch and stored everything in collection then chunk it by take(10) which is inefficient – david valentino Feb 12 '22 at 11:10

Luca C. · Answer 2 · 2017-11-08T17:09:40.853

29

The simplest way in laravel 5 is:

$listings=Listing::take(10)->get();

return view('view.name',compact('listings'));

edited Nov 08 '17 at 17:09

answered May 11 '17 at 08:04

Luca C.

11,714
1
86
77

I will say, perfect answer. – Alauddin Ahmed Dec 17 '18 at 06:59

score 26 · Answer 3 · answered Feb 13 '18 at 18:21

26

Another way to do it is using a limit method:

Listing::limit(10)->get();

This can be useful if you're not trying to implement pagination, but for example, return 10 random rows from a table:

Listing::inRandomOrder()->limit(10)->get();

answered Feb 13 '18 at 18:21

Amade

3,665
2
26
54

saber tabatabaee yazdi · Answer 4 · 2023-05-18T17:08:48.373

7

this worked as well IN LARAVEL 8 and 9 and 10 and above

Model::query()->take(10)->get();

edited May 18 '23 at 17:08

answered May 30 '21 at 14:33

saber tabatabaee yazdi

4,404
3
42
58

score 0 · Answer 5 · answered Nov 07 '22 at 10:39

0

This also worked in Laravel 9

Model::query()->take(10)->get();

answered Nov 07 '22 at 10:39

Volker Trotte

17
3

Select the first 10 rows - Laravel Eloquent

5 Answers5

Linked