PHP Pagination::DB Examples

Example #1

File: Pagination.php Project: rev087/kennel

 function __construct($criteria, $items_per_page = 10)
 {
     self::$DB = new MySQL();
     $this->criteria = $criteria;
     $this->items_per_page = $items_per_page;
     $sql = ORM::getSelectString($criteria);
     $rs = self::$DB->query($sql);
     $this->count = self::$DB->num_rows($rs);
     $this->pages = ceil($this->count / $this->items_per_page);
 }