package Default
inherited_from \Zend\Paginator\Adapter\DbSelect

 Methods

Constructs instance.

__construct(\Zend\Db\TableGateway\TableGateway $tableGateway, null|\Zend\Db\Sql\Where|\Closure|string|array $where = null, null|string|array $order = null, null|string|array $group = null, null|\Zend\Db\Sql\Having|\Closure|string|array $having = null
inherited_from \Zend\Paginator\Adapter\DbSelect::__construct()

Parameters

$tableGateway

\Zend\Db\TableGateway\TableGateway

$where

null\Zend\Db\Sql\Where\Closurestringarray

$order

nullstringarray

$group

nullstringarray

$having

null\Zend\Db\Sql\Having\Closurestringarray

Constructor.

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

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() : integer
Inherited

Returns

integer

Returns an array of items for a page.

getItems(integer $offset, integer $itemCountPerPage) : array
Inherited
inherited_from \Zend\Paginator\Adapter\AdapterInterface::getItems()

Parameters

$offset

integer

Page offset

$itemCountPerPage

integer

Number of items per page

Returns

array

Returns select query for count

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

Returns

\Zend\Db\Sql\Select

 Properties

 

Database count query

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

Default

 

$resultSetPrototype

$resultSetPrototype : \Zend\Db\ResultSet\ResultSet

Default

 

Total item count

$rowCount : integer

Default

 

Database query

$select : \Zend\Db\Sql\Select

Default

 

$sql

$sql : \Zend\Db\Sql\Sql

Default

 Constants

 

ROW_COUNT_COLUMN_NAME

ROW_COUNT_COLUMN_NAME = 'C'