public function indexAction() { /*--search---*/ $search = trim($this->_getParam('search')); $where = "config_id<>'-2147483648'"; $this->view->linkArray = array(); $this->view->search = ""; if ($search != "") { $where = "config_name like '%{$search}%'"; $this->view->search = $search; } $this->view->page_size = $page_size = Zend_Registry::get('page_size'); $page = $this->_getParam('page', 1); $model = new Security_Model_SysConfig(); $table = $model->getMapper()->getDbTable(); $select = $table->select()->setIntegrityCheck(false)->from('sys_config')->order('config_id ASC')->where($where); $sql = $select->__toString(); $paginator = Base_Paginator::factory($select); // echo '<pre>'; print_r($paginator); $paginator->setItemCountPerPage($page_size); $paginator->setCurrentPageNumber($page); $this->view->totalItems = $paginator->getTotalItemCount(); $this->view->paginator = $paginator; }