ActiveRecord and Zend_Paginator_Adapter_Interface

 
<?php
class My_Paginator implements Zend_Paginator_Adapter_Interface {
	public function __construct($table,$conditions = array())
	{
		if(!is_array($conditions))
 
			$conditions = array( $conditions );
 
		$this->conditions = $conditions;
 
		$this->table	  = new $table;
 
	}
 
	public function getItems($offset, $itemCountPerPage)
	{
			return $this->table->find('all', array('limit' => $itemCountPerPage, 'offset' => $offset, 'conditions' => $this->conditions));
	}
 
	public function count()
	{
		return $this->table->count(array('conditions' => $this->conditions));
	}
}
?>
 

 
$paginator = new Zend_Paginator(new My_Paginator('User',' active = "Y" '));
 

 
    public function pageUserAction()
    {
 		$paginator = new Zend_Paginator(new My_Paginator('User',' active = "Y" '));
		$paginator->setCurrentPageNumber($this->_getParam('page', 1));
		$paginator->setItemCountPerPage('25');
		$this->view->paginator = $paginator;
    }
 

 
<div id="userlist">
<?php if (count($this->paginator)){
	foreach ($this->paginator as $user){
		echo $user->username."<br>";
	}
}
?>
</div>
 
<?= $this->paginationControl($this->paginator, 'Elastic', '/common/paginator.phtml'); ?>
 

4 Responses to “ActiveRecord and Zend_Paginator_Adapter_Interface”

1. Clay vanSchalkwijk says:

   November 20, 2009 at 2:31 pm

   This approach might not work for you without the ability to count independent of your query.

   getItems() should only return a subset since it is the slice that is displayed, therefore you can’t mix count() which should represent the total number of records matching your query with the subset, it will always be wrong since the affected rows will always be your subset (the number or results per page($itemCountPerPage).

   Unless you can create an independent counting function that can return the total number of rows you might be out of luck. I’m not sure how big your data set is, but querying everything just to get a count might not be feasible.

   Reply
   • Andrew says:

     November 21, 2009 at 7:33 pm

     my getitems is returning only a subset and my count represents total number of rows that match the query, i.e., ” count 789 rows — now displaying 50 – 70″
     The most efficient way is to issue these 2 queries in succession:

     // get a subset:
     SELECT SQL_CALC_FOUND_ROWS *
     FROM table
     WHERE somecondtion
     LIMIT 49, 20

     // count of all records that would match query
     SELECT FOUND_ROWS()
   • Clay vanSchalkwijk says:

     November 21, 2009 at 7:58 pm

     You could work around it and just pass in the page and count per page into the construct and query for it up-front.

     public function __construct(page,itemperpage,conditions){
     // get a subset:
     SELECT SQL_CALC_FOUND_ROWS *
     FROM table
     WHERE somecondtion
     LIMIT offset, itemperpage

     // count of all records that would match query
     SELECT FOUND_ROWS()

     this->result = result;
     this->count = count;
     }

     public function getItems()
     {
     return $this->result;
     }

     public function count()
     {
     return $this->count;
     }

     Not the most elegant solution, but it would work.
2. andrew warner says:

   November 19, 2009 at 7:43 pm

   >>The two methods the Zend_Paginator_Adapter_Interface expects are count() and getItems()

   It appears that count() is called first, which is a problem for me because I set the count value in getItems() , so when count() is called, there’s no count yet.
   I’m trying to adapt this for use outside the Zend Framework.

   [code]

   public function getItems($offset, $itemCountPerPage)
   {
   /* modify sql; stick the SQL_CALC_FOUND_ROWS in there: */
   $sql_modified = substr_replace($this->sql, ' SQL_CALC_FOUND_ROWS ', 6, 0) . " LIMIT $offset, $itemCountPerPage";
   $stmt = $this->pdo->prepare($sql_modified);
   $stmt->execute($params);

   /* set count property: */
   $this->count = $this->pdo->query('SELECT FOUND_ROWS()')->fetchColumn(0);

   /* return data: */
   return $stmt->fetchAll(PDO::FETCH_OBJ);
   }

   public function count()
   {
   return $this->count;
   }

   [/code]

   Reply