Zend Framework paginator与GROUP BY无法正常工作..？

Question

I have following code :

$select = new Select('tier');
$select->group('tierGroup');


$resultSetPrototype = new ResultSet();
$resultSetPrototype->setArrayObjectPrototype(new Tiers());

$paginatorAdapter = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype);
$paginator = new Paginator($paginatorAdapter);

It works perfectly fine if i remove the group by clause but with group by it counts all the rows of table and show more pages than data.

Any help will be appreciated.

Answer 1

There are multiple issues talking about this problem, it seems that the adapter can't figure the number of rows returned somehow. You should use setRowCount() methods in your controller.

paginatorAdapter = new DbSelect($select, $this->tableGateway->getAdapter(), $resultSetPrototype);
$paginatorAdapter->setRowCount((int)trim($select->getCount()));.
$paginator = new Paginator($paginatorAdapter);

Hope this little hack will work for you