Re: Re: Limited db paging with datagrid

On Wed, 5 Jan 2005 12:47:54 +1100 (EST), daniel@electroteque.org <daniel@electroteque.org> wrote: > > > > > $result = $db->query("SELECT COUNT(*) AS count FROM users"); > > $record = $result->fetchRow(); > > > > $result = $db->query("SELECT * FROM users LIMIT 20"); > > $dg->bind($result); > > > > $dg->pager->_totalItems = $record['count']; > > > > > > And if you don't like any of these ideas, just create your own paging > > based on a count query. > > > > Hope this helps and let me know what your solution is > > > It also seems that DataGrid doesnt work with MDB ? using this > > $data = Structures_DataGrid_DataSource::create($result); > > Is there a way to get it to work with MDB , possibly via DataObject ? Does > ti really need to go into aDataObject though ? > DB_DataObject is for DB, not MDB. Ther could be an MDB version, but noone has had the time to work on it. In addition, a new PHP extension, PDO, is being worked on (for PHP5) which handles DB abstraction *natively* in PHP without having to have an abstraction class. DBDO, which will be a PHP extension version of DB_DataObject will use this....when it comes out. -- Justin Patrin