Illuminate\Database\Query\Builder::simplePaginate PHP Method

simplePaginate() public method

This is more efficient on larger data-sets, etc.
public simplePaginate ( integer $perPage = 15, array $columns = ['*'], string $pageName = 'page', integer | null $page = null ) : Illuminate\Contracts\Pagination\Paginator
$perPage integer
$columns array
$pageName string
$page integer | null
return Illuminate\Contracts\Pagination\Paginator
    public function simplePaginate($perPage = 15, $columns = ['*'], $pageName = 'page', $page = null)
    {
        $page = $page ?: Paginator::resolveCurrentPage($pageName);
        $this->skip(($page - 1) * $perPage)->take($perPage + 1);
        return new Paginator($this->get($columns), $perPage, $page, ['path' => Paginator::resolveCurrentPath(), 'pageName' => $pageName]);
    }

Usage Example

 /**
  * Get a paginator only supporting simple next and previous links.
  *
  * This is more efficient on larger data-sets, etc.
  *
  * @param int   $perPage count of list
  * @param array $columns get columns
  * @return \Illuminate\Contracts\Pagination\LengthAwarePaginator
  */
 public function simplePaginate($perPage, array $columns = ['*'])
 {
     if ($this->dynamic === false) {
         $this->query->simplePaginate($perPage, $columns);
     }
     if ($this->proxy === true) {
         $this->query = $this->getProxyManager()->get($this->query);
     }
     return $this->query->simplePaginate($perPage, $columns);
 }
All Usage Examples Of Illuminate\Database\Query\Builder::simplePaginate