PHP Code
Public function init () {
$where = ";//Condition
$page = $_get[' page ']? Intval ($_get[' page '): ' 1 ';
$infos = $this->listinfo ($where, ", $page, 10);//Query Data
$pages = $this->pages;
include $this->admin_tpl (' capture ');//load Background template
}
/**
* Querying multiple data and paging class
* @param $where
* @param $order
* @param $page
* @param $pagesize
* @return Unknown_type
*/
Final Public Function listinfo ($where = ", $order =", $page = 1, $pagesize = ten, $key = ", $setpages = 5, $urlrule = ', $array = Array (), $data = ' * ') {
$where = To_sqls ($where);
$this->number = $this->db->count ($where);
$page = max (Intval ($page), 1);
$offset = $pagesize * ($page-1);
$this->pages = pages ($this->number, $page, $pagesize, $urlrule, $array, $setpages);
$array = Array ();
if ($this->number > 0) {
return $this->db->select ($where, $data, "$offset, $pagesize", $order, "', $key);
} else {
return Array ();
}
}
HTML code
<?php {$pages}?>
Phpcms Background Paging