OhPage

OhPage is a simple cheat, really it's because I'm tired of figuring out the skip / limit for paginating result sets., _(*1)

, _(*2)

Using Composer

To use OhPage with Composer, add the dependency (and version constraint) to your require block inside your composer.json file., _(*3)

{
    "require": {
        "rogerthomas84/ohpage": "1.0.*"
    }
}

Quick Start

<?php
$db = new \MongoClient('mongodb://my.database.host:27017'); // Set up your database connection
$collection = $db->selectCollection('mydb', 'mycollection');

$perPage = 10; // How many results per page?
$currentPage = 1; // The current page
$totalResults = $collection->count(); // Get the total from the DB

$instance = new PaginateHelper($perPage, $currentPage, $totalResults);

$results = $collection->find()->sort(
    array('createdDate' => -1)
)->skip(
    $instance->getQueryOffset()
)->limit(
    $instance->getQueryLimit()
);