PHP Classes

File: src/Chronicle/Pagination.php

Recommend this page to a friend!
  Classes of Scott Arciszewski   Chronicle   src/Chronicle/Pagination.php   Download  
File: src/Chronicle/Pagination.php
Role: Class source
Content type: text/plain
Description: Class source
Class: Chronicle
Append arbitrary data to a storage container
Author: By
Last change:
Date: 1 year ago
Size: 954 bytes
 

Contents

Class file image Download
<?php
declare(strict_types=1);
namespace ParagonIE\Chronicle;

/**
 * Trait Pagination
 * @package ParagonIE\Chronicle
 */
trait Pagination
{
    /**
     * @param string $page
     * @return int
     */
    protected function getOffset(string $page = ''): int
    {
        $p = (int) $page;
        if ($p < 1) {
            $p = 1;
        }

        $pageSize = Chronicle::getPageSize();
        return (int) (($p - 1) * $pageSize);
    }

    /**
     * @param int $offset
     * @param int $limit
     * @return string
     */
    protected function formatOffsetSuffix(int $offset, int $limit): string
    {
        switch (Chronicle::getDatabase()->getDriver()) {
            case 'mysql':
                return ' LIMIT ' . $offset . ', ' . $limit;
            case 'sqlite':
                return ' LIMIT ' . $limit . ' OFFSET ' . $offset;
            default:
                return ' OFFSET ' . $offset . ' LIMIT ' . $limit;
        }
    }
}