DataGrid: problems with paging
| From: | Mark Steudel | Date: | Fri, 18 Nov 2005 23:15:40 +0000 |
| Subject: | DataGrid: problems with paging | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-21998@lists.php.net to get a copy of this message | ||
I have 25 records in the tblMenu table, and I set it to show 5 records per
page. When I get the paging, I only get 1 | 2 >>
require('Structures/DataGrid.php');
$dg =& new Structures_DataGrid(5);
// fetch menu data from db
$res =& $db->query( "SELECT * FROM tblMenu" );
mysqlErrorCheck($res);
$dg->bind($res);
// assign content to template
$tpl->assign('content', $dg->renderer->toHTML($dg));
$tpl->assign('pagination', $dg->renderer->getPaging())
I also tried it this way, but I get "Undefined class name
'structures_datagrid_datasource'"
require('Structures/DataGrid.php');
$dg =& new Structures_DataGrid(5);
// fetch user data from db
$res =& $db->query( "SELECT * FROM tblMenu" );
mysqlErrorCheck($res);
$data = Structures_DataGrid_DataSource::create($res);
$dg->bindDataSource($data);
$dg->renderer->setTableHeaderAttributes(array('bgcolor' => '#4A497B'));
$dg->renderer->setTableOddRowAttributes(array('bgcolor' => '#CCCCCC'));
$dg->renderer->setTableEvenRowAttributes(array('bgcolor' =>
'#EEEEEE'));
$dg->renderer->sortIconASC = "⇑";
$dg->renderer->sortIconDESC = "⇓";
$dg->addColumn(new Structures_DataGrid_Column('Name', 'name',
'name'));
$dg->addColumn(new Structures_DataGrid_Column('URL', 'url',
'url'));
$dg->addColumn(new Structures_DataGrid_Column('Date', 'date',
'date'));
// assign content to template
$tpl->assign('content', $dg->renderer->toHTML($dg));
$tpl->assign('pagination', $dg->renderer->getPaging());
TIA, mark