DB_Pager thoughts
| From: | Tomas V.V.Cox | Date: | Sat, 17 Nov 2001 17:28:19 +0000 |
| Subject: | DB_Pager thoughts | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-2954@lists.php.net to get a copy of this message | ||
Now a question comes to my mind. As you probably know I have added the
native row limit support for Pear DB, more efficient than the system I
initially used using the fetchrow by number feature. So there is no need now
to use the pager methods for the limit stuff. Simply do:
$res = $db->limitQuery($sql, $from, $number_of_rows_you_want);
while($row = $res->fetchRow()) {
...
}
Perhaps what I should do is to cut off those methods and only leave the
calculations stuff and eventually implement some helpers methods for
building the HTML representation or adding other features like the Google
paging style, navigations by letters (for ex the initials of names)...
Tomas V.V.Cox