phpormlaraveleloquent

Select the first 10 rows - Laravel Eloquent


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.


Solution

  • 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: