Re: Re: Limited db paging with datagrid
| From: | daniel at electroteque dot org | Date: | Wed, 05 Jan 2005 03:54:24 +0000 |
| Subject: | Re: Re: Limited db paging with datagrid | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16623@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');