2009/7/19 MEM <tal...@gmail.com>:
>> I would say your pagination logic belongs in myPDO.class.php. Where I
>> have this functionality it's as simple as two arguments to the method
>> that gets data, $page and $perpage. Setting both to false would
>> retrieve all rows.
> Interesting but, still no clue, on this side, about how to accomplish that. 
> I'm still a newbie.
> Can you throw some key words so that I can google them and look for a way to 
> implement that?

I don't know much about PDO, but in raw MySQL SQL you'd have something
similar to this...

function Select($table, $where, $page = false, $perpage = 20)
  $sql = 'select * from '.$table.' where '.$where;
  if ($page !== false)
    $sql .= ' limit '.(($page-1)*$perpage).', '.$perpage;
  // now run the query and return the results

Obviously this is highly simplified but should give you the general
idea. If you still don't get it I suggest you find something open
source that does pagination (any blogging system should work as an
example) and look at the source code.



PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to