Re: DataGrid: problems with paging

On 11/19/05, Justin Patrin <papercrane@gmail.com> wrote: > On 11/19/05, Mark Steudel <mark@netriver.net> wrote: > > Not sure what happened but this morning I came in and it worked ... > > > > Sorry to be dense what does PK stand for? > > Primark Key. I tend to mis-type that... Primary Key > > > > > Thanks, Mark > > > > >-----Original Message----- > > >From: Justin Patrin [mailto:papercrane@gmail.com] > > >Sent: Friday, November 18, 2005 9:37 PM > > >To: Mark Steudel > > >Cc: pear-general@lists.php.net > > >Subject: Re: [PEAR] 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 > > > > > > > -- > > PEAR General Mailing List (http://pear.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > Justin Patrin > -- Justin Patrin