这是我的
$art = Article::where('id',$article)->firstOrFail();
$products = $art->products;
我只想限制"产品"
$products = $art->products->offset($offset*$limit)->take($limit)->get();
请帮我一把！
谢谢!
这是我的
$art = Article::where('id',$article)->firstOrFail();
$products = $art->products;
我只想限制"产品"
$products = $art->products->offset($offset*$limit)->take($limit)->get();
请帮我一把！
谢谢!
skip = OFFSET
$products = $art->products->skip(0)->take(10)->get(); //get first 10 rows
$products = $art->products->skip(10)->take(10)->get(); //get next 10 rows
From laravel doc 5.2 https://laravel.com/docs/5.2/queries#ordering-grouping-limit-and-offset
skip / take
To limit the number of results returned from the query, or to skip a given number of results in the query (OFFSET), you may use the skip and take methods:
$users = DB::table('users')->skip(10)->take(5)->get();
在laravel 5.3中你可以写(https://laravel.com/docs/5.3/queries#ordering-grouping-limit-and-offset)
$products = $art->products->offset(0)->limit(10)->get();