Laravel Enloquent skip n，take all？ [英] Laravel Eloquent skip n, take all?

问题描述

我注意到，在链接 skip（）的Laravel中，您还必须使用 take（）作为好。我想跳过第n行，但要休息。 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，必须提供一个LIMIT才能使mysql工作。因此，没有办法做到这一点没有限制。我们需要一些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 的雄辩类。这是应该工作的：

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 Enloquent skip n，take all？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！