How to set limit and offset in Laravel Eloquent.

Limit and offset in Laravel is used to paginate records or get the number of records from the table from an offset. In this example, you will see how to use/ set the limit and offset in Laravel Framework.

Note: This example work on Laravel 5.3 or above

$condition=[];
$offset=0 // start row index.
$limit=100 // no of records to fetch/ get .

Model::where(['zone_id'=>1])->offset($offset)->limit($limit)->get();

Above example returns you first 100 rows/ records from Model ( in your case name of Modal) and returns you an array of objects from the model.