- [notice] child pid NNNN exit signal Bus error (10) in the apache log.
- ALTER USER myname IDENTIFIED BY mypassword
- ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
public function listAction()
{
$form = new My_Form_Search();
//figure out what page they want to be on with a default of 1
$page = (int)$this->_getParam('page', 1);
$recordsPerPage=15;
//set up our default search
$model = new Default_Model_Person();
$select = $model->select();
//capture the input params
if ($this->_request->getParam('search',0) || $this->_request->isPost()){
//if it is a post, populate the form and reset the page to 1
if ($this->_request->isPost()){
$form->populate($this->_request->getPost());
$page = 1;
}
else{ //'search' showed up via the GET param
$form->populate($this->_request->getParams());
}
//make sure the submitted data is valid and modify select statement
if ($form->valid()){
$search = $form->getValue('search');
$select->where('name like ?',$search.'%');
}
}
//set up the paginator with our select query
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbTableSelect($select));
$paginator->setCurrentPageNumber($page);
$paginator->setItemCountPerPage($recordsPerPage);
//set our view parameters. the third one (searchParams) is
// the key difference from a lot of the other examples out there
$this->view->paginator = $paginator;
$this->view->form = $form;
$this->view->searchParams = array('search'=>$form->getValue('search'));
}
<config>
<people_path>
<route>people/:page/:search</route>
<defaults>
<module>people</module>
<controller>index</controller>
<action>list</action>
<page>1</page>
<search/><!-- by default the search param is empty -->
</defaults>
<reqs>
<page>\d+</page>
</reqs>
</people_path>
</config>
<a href="<?php echo $this->url(array('page' => $this->previous, 'search'=> $this->search)); ?>">
<a href="<?php echo $this->url(array('page' => $page, 'search'=> $this->search)); ?>">
<a href="<?php echo $this->url(array('page' => $this->next, 'search'=> $this->search)); ?>">
echo $this->paginationControl($this->paginator,'Elastic','pagination_control.phtml',$this->searchParams);