Laravel 4.1: Eloquent Offset & Limit

Question

How to limit returned data from Eloquent? I tried with this:

$data = Product::all()->take(4)->skip(3);

And it return the error message: Call to undefined method Illuminate\Database\Eloquent\Collection::skip()

It seems like eloquent don't support skip()? So, how can I offset & limit the data from eloquent?

Thank you.

Answer 1

You may try this (get 4 items from offset 3/4th):

Product::take(4)->offset(3)->get();

Or this (get 5 items from 3rd row):

Product::take(5)->skip(2)->get();