Answered by : tame-turtle-p4unaxg086pr

$products = $art->products->skip(10)->take(10)->get(); //get next 10 rows

Source : https://stackoverflow.com/questions/35643192/laravel-eloquent-limit-and-offset | Last Update : Thu, 27 Aug 20

Answered by : defeated-dingo-a27k2v1erg72

$users = DB::table('users')->skip(10)->take(5)->get();

Source : https://laravel.com/docs/9.x/queries#limit-and-offset | Last Update : Wed, 13 Apr 22

Answered by : defeated-dingo-a27k2v1erg72

$users = DB::table('users') ->offset(10) ->limit(5) ->get();

Source : https://laravel.com/docs/9.x/queries#limit-and-offset | Last Update : Wed, 13 Apr 22

Answered by : defeated-dingo-a27k2v1erg72

$report = DB::table('orders') ->selectRaw('count(id) as number_of_orders, customer_id') ->groupBy('customer_id') ->havingBetween('number_of_orders', [5, 15]) ->get();

Source : https://laravel.com/docs/9.x/queries#limit-and-offset | Last Update : Wed, 13 Apr 22

Answered by : defeated-dingo-a27k2v1erg72

$role = $request->input('role');
 
$users = DB::table('users') ->when($role, function ($query, $role) { $query->where('role_id', $role); }) ->get();

Source : https://laravel.com/docs/9.x/queries#limit-and-offset | Last Update : Wed, 13 Apr 22