Re: Re: Limited db paging with datagrid

Andrew Nagy wrote:

daniel@electroteque.org wrote:

Here is the code $dg =& new Structures_DataGrid(15,$_GET['page']); $pagerOptions = array(

            'mode'     => 'Sliding',
            'delta'    => 2,
            'perPage'  => 15,

             );

$paged_data = Pager_Wrapper::getData('MDB',$db, "select * from users", $pagerOptions);$dg->renderer->setTableHeaderAttributes(array('bgcolor' => 'CCCCCC','class'=>'header'));$dg->renderer->setTableEvenRowAttributes(array('bgcolor' => '#FFFFFF')); $dg->renderer->setTableOddRowAttributes(array('bgcolor' => '#EEEEEE')); $dg->renderer->setTableAttribute('cellspacing', '0'); $dg->renderer->setTableAttribute('cellpadding', '0'); $dg->bind($paged_data['data']); $dg->pager->_totalItems = $paged_data['totalItems']; $dg->render(); echo $dg->renderer->getPaging(); I am only seeming to get 15 and not a page 2 as there is 22 rows. There seems to be the pagingfunctions on the html renderer and smarty renderer ?

I just tried my pager hack with a project I am working on and was successful. Make sure that you set the _totalItems equal to your total number of items, which in your case is 22.

Oops, I spoke too soon. This will not work. Back to the drawing board. Andrew