Re: Re: Limited db paging with datagrid

From: Date: Wed, 05 Jan 2005 03:51:50 +0000
Subject: Re: Re: Limited db paging with datagrid
References: 1  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-16622@lists.php.net to get a copy of this message
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 have also looked at the smarty renderer, and there is no example.tpl ? How easy would it be toconvert to Flexy ? I am looking at customising the renderer and placing in my custom class path so its calledHTMLTableCustom or Flexy if I can work out how to create a renderer for Flexy, it seemed to loadfine like this $dg =& new Structures_DataGrid(15,$_GET['page'],'HTMLTableCustom');

« previous php.pear.general (#16622) next »