category | Zend |
---|---|
package | Zend_Paginator |
copyright | Copyright (c) 2005-2015 Zend Technologies USA Inc. (http://www.zend.com) |
license | New BSD License |
__construct(\Zend_Db_Select $select)
\Zend_Db_Select
The select query
count() : integer
integer
getCacheIdentifier() : string
string
getCountSelect() : \Zend_Db_Select
TODO: Have a look at queries that have both GROUP BY and DISTINCT specified. In that use-case I'm expecting problems when either GROUP BY or DISTINCT has one column.
\Zend_Db_Select
getItems(integer $offset, integer $itemCountPerPage) : array
inherited_from | \Zend_Paginator_Adapter_Interface::getItems() |
---|
integer
Page offset
integer
Number of items per page
array
setRowCount($rowCount) : \Zend_Paginator_Adapter_DbSelect
.. FROM (SELECT ...)). While this yields an accurate count even with queries containing clauses like LIMIT, it can be slow in some circumstances. For example, in MySQL, subqueries are generally slow when using the InnoDB storage engine. Users are therefore encouraged to profile their queries to find the solution that best meets their needs.
\Zend_Paginator_Exception |
---|
\Zend_Paginator_Adapter_DbSelect
$this$_cacheIdentifier : string
null
$_countSelect : \Zend_Db_Select
null
$_rowCount : integer
null
$_select : \Zend_Db_Select
null
ROW_COUNT_COLUMN = 'zend_paginator_row_count' : string