用PHP MySQL进行分页的详细说明(二)
<?php
function getDataLink() {
if ($this->numItems) {
global $db;
$PageID = $this->CurrentPageID;
$from = ($PageID - 1) * $this->PageSize;
$count = $this->PageSize;
$link = $db->limitQuery($this->sql, $from, $count); //使用Pear DB::limitQuery方法保证数据库兼容性
return $link;
} else {
return false;
}
}
/***
*
* 以二维数组的格式返回结果集
*
***/
function getPageData() {
if ($this->numItems) {
if ($res = $this->getDataLink()) {
if ($res->numRows()) {
while ($row = $res->fetchRow()) {
$result[] = $row;
}
} else {
$result = array();
}
return $result;
} else {
return false;
}
} else {
return false;
}
}本文地址:http://www.phprm.com/code/dbe1328fb31be0b3f4dd600f912b36a1.html
转载随意,但请附上文章地址:-)