Zend Framework » \Zend\Paginator\Adapter\DbSelect

Methods

Constructor.

__construct(\Zend\Db\Sql\Select $select, \Zend\Db\Adapter\Adapter | \Zend\Db\Sql\Sql $adapterOrSqlObject, \Zend\Db\ResultSet\ResultSetInterface $resultSetPrototype, \Zend\Db\Sql\Select $countSelect)

Parameters

$select

\Zend\Db\Sql\Select

The select query

$adapterOrSqlObject

\Zend\Db\Adapter\Adapter\Zend\Db\Sql\Sql

DB adapter or Sql object

$resultSetPrototype

null\Zend\Db\ResultSet\ResultSetInterface

$countSelect

null\Zend\Db\Sql\Select

Exceptions

`\Zend\Paginator\Adapter\Exception\InvalidArgumentException`

Returns the total number of rows in the result set.

count() : int

Returns

int

Returns an array of items for a page.

getItems(int $offset, int $itemCountPerPage) : array

Parameters

$offset

int

Page offset

$itemCountPerPage

int

Number of items per page

Returns

array

Returns select query for count

getSelectCount() : \Zend\Db\Sql\Select

Returns

\Zend\Db\Sql\Select

Properties

Database count query

$countSelect : \Zend\Db\Sql\Select | null

$resultSetPrototype

$resultSetPrototype : \Zend\Db\ResultSet\ResultSet

Total item count

$rowCount : int

Database query

$select : \Zend\Db\Sql\Select

$sql

$sql : \Zend\Db\Sql\Sql

Constants

ROW_COUNT_COLUMN_NAME

ROW_COUNT_COLUMN_NAME