問題描述
我注意到在 Laravel 中鏈接 skip() 時，您還必須使用 take() .我想跳過前 n 行但剩下的.take 方法只允許整數，我怎么能做到這一點而不訴諸一些技巧，例如為 take 指定一個大數字?
I've noticed that in Laravel when chaining a skip() you must also use take() as well. I want to skip the first n rows but take the rest. The take method only allows integers how can I do this without resorting to some hacky trick such as specifying a large number for take?
推薦答案
基本上，對于每個 OFFSET，必須為 mysql 提供一個 LIMIT 才能工作.因此，如果不指定限制，就無法做到這一點.我們需要一些 php mojo 才能在這里工作.
Basically, with every OFFSET, a LIMIT must be supplied for mysql to work. Therefore, there is no way to do this without sepcifying a limit. We need some php mojo to work here.
假設我們有一個名為 Attendance 的 Eloquent 類.以下是應該可行的:
Let's say we have an Eloquent Class named Attendance. Here's what should work:
//Getting count
$count = Attendance::count();
$skip = 5;
$limit = $count - $skip; // the limit
$collection = Attendance::skip($skip)->take($limit)->get();
這篇關于Laravel Eloquent 跳過 n，通吃?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！