Thread: Problem Zend_Paginator (dynamic select in the query)

this my action , my problem when i click in link pages of paginator (for exemple 2 or 3), i have a problem with $value because my $value is posted the first time in search form from another page. (my select must be dynamic)

if any one find solutions, thanks

function xxxAction {

$value = this->_request->getPost('param');

$selection="SELECT *
FROM table
WHERE field1=$value";

$db=Zend_Db_Table::getDefaultAdapter();

$your_db_results = $db->fetchAll($selection);


$paginator = Zend_Paginator::factory($your_db_results);
$paginator->setItemCountPerPage($pageNumber);
$paginator->getItemsByPage($itemNumber);
$paginator->setCurrentPageNumber($this->_getParam('page'));
Zend_Paginator::setDefaultScrollingStyle('Sliding' );


//this are your results from db
$this->view->your_db_results = $paginator;

//this is paginator
$this->view->paginator = $paginator;

}

You could probably store the $value in a cookie or session on the first request and use that value on subsequent requests.

$value = this->_request->getPost('param');

// Start a session
$session = new Zend_Session_Namespace('value');

// If $value is set then you are on the first page and so you store $value to
// the session
if ($value) {
$session->value = $value;
}

// put $session->value into your query
$selection="SELECT *
FROM table
WHERE field1= " . $session->value;

$db=Zend_Db_Table::getDefaultAdapter();


// You don't need all your results at once but only the results for the current
// page, so instead of getting all of them just get let the paginator get you
// the ones you need

// Delete following line
//$your_db_results = $db->fetchAll($selection);

// and instead put your query into the paginator
$paginator = Zend_Paginator::factory($selection);
$paginator->setItemCountPerPage($pageNumber);
$paginator->getItemsByPage($itemNumber);
$paginator->setCurrentPageNumber($this->_getParam('page'));
Zend_Paginator::setDefaultScrollingStyle('Sliding' );
------------------

Putting the session into the query should work but I'm not sure about using the paginator on the select query like that as I've never built my queries like that. I would use the db factory instead, so it would look like that:

$value = this->_request->getPost('param');

// Start a session
$session = new Zend$value = this->_request->getPost('param');

// Save this into your registry in the bootstrap and then you can fetch it
// again later, much easier
$db = Zend_Db::factory('Pdo_Mysql', array(
'host' => '127.0.0.1',
'username' => 'webuser',
'password' => 'xxxxxxxx',
'dbname' => 'test'
));

$select = $db->select();
$select->from('table name', '*');
$select->where('field 1 = ?', $session->value);

$paginator = Zend_Paginator::factory($select);
$paginator->setItemCountPerPage($pageNumber);
$paginator->getItemsByPage($itemNumber);
$paginator->setCurrentPageNumber($this->_getParam('page'));
Zend_Paginator::setDefaultScrollingStyle('Sliding' );



Hope this helps...

double post

thank you Untitled No. 4 .


I test it with session, nd it works, but relating to performance i dont know...
in java we have the term scope for the servlet request, session.... i dont know in PHP if we have this possibility with controller til define it.

and why arnt you passing that param over get?

to pass it in get, i need to post it every time, well i can do that
but the problem to add with url in pagination.html (the footer) i cant call for myvalue for exemple ($this->myvalue) , this is not the same view.

pagination.html this is not my view , this an code that handle the paginator like

helper.


I dont know i you understand me ?

hi all i'm new in using the zend_paginator and i wanted to make a selection from more than one table in same pagination so i made an array containing the result from first and second selection which contains different fields so i added a key for each and passed it to the factory of zend_paginator but the pagination didn't work so please can any one help in my problem thx