Re: DataGrid: problems with paging

On 11/18/05, Mark Steudel <mark@netriver.net> wrote: > 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); > Perhaps try a numRows() on your res to make sure it returns 25. Also, make sure your PK is set up correctly. > $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 = "&uArr;"; > $dg->renderer->sortIconDESC = "&dArr;"; > > $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 > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Justin Patrin