/** * Generate the limit clause for a query based off * the properties of a Paginator page * * @access protected * @param Page $page * @return string */ protected function getLimitClause(Page $page) { $subquery = ""; $limit = $page->getPaginator()->getItemsPerPage(); $offset = $limit * ($page->getPageNumber() - 1); $subquery .= " LIMIT " . $limit . " OFFSET " . $offset; return $subquery; }