/** * 构造函数 * * 如果 $source 参数是一个 TableDataGateway 对象，则 FLEA_Helper_Pager 会调用 * 该 TDG 对象的 findCount() 和 findAll() 来确定记录总数并返回记录集。 * * 如果 $source 参数是一个字符串，则假定为 SQL 语句。这时，FLEA_Helper_Pager * 不会自动调用计算各项分页参数。必须通过 setCount() 方法来设置作为分页计算 * 基础的记录总数。 * * 同时，如果 $source 参数为一个字符串，则不需要 $conditions 和 $sortby 参数。 * 而且可以通过 setDBO() 方法设置要使用的数据库访问对象。否则 FLEA_Helper_Pager * 将尝试获取一个默认的数据库访问对象。 * * @param TableDataGateway|string $source * @param int $currentPage * @param int $pageSize * @param mixed $conditions * @param string $sortby * @param int $basePageIndex * * @return FLEA_Helper_Pager */ function FLEA_Helper_Pager(& $source, $currentPage, $pageSize = 20, $conditions = null, $sortby = null, $basePageIndex = 0) { $this->_basePageIndex = $basePageIndex; $this->_currentPage = $this->currentPage = $currentPage; $this->pageSize = $pageSize; if (is_object($source)) { $this->source =& $source; $this->_conditions = $conditions; $this->_sortby = $sortby; $this->totalCount = $this->count = (int)$this->source->findCount($conditions); $this->computingPage(); } elseif (!empty($source)) { $this->source = $source; $sql = "SELECT COUNT(*) FROM ( $source ) as _count_table"; $this->dbo =& FLEA::getDBO(); $this->totalCount = $this->count = (int)$this->dbo->getOne($sql); $this->computingPage(); } }

$dirname = dirname(__FILE__); define('APP_DIR', $dirname . '/APP'); define('NO_LEGACY_FLEAPHP', true); require($dirname.'/FleaPHP/FLEA/FLEA.php'); //设置缓存目录 FLEA::setAppInf('internalCacheDir',$dirname.'/_Cache'); //链接数据库 $dsn = array( 'driver' => 'mysql', 'host' => 'localhost', 'login' => 'root', 'password' => '', 'database' => 'wordpress' ); FLEA::setAppInf('dbDSN',$dsn); //读取wp_posts的内容 FLEA::loadClass('FLEA_Db_TableDataGateway'); FLEA::loadClass('FLEA_Helper_Pager'); //FLEA::loadHelper('pager'); class Teble_Class extends FLEA_Db_TableDataGateway { var $tableName = 'wp_posts'; var $primaryKey = 'ID'; } $tableposts =& new Teble_Class(); $pager =& new FLEA_Helper_Pager($tableposts,2,5); $page = $pager->getPagerData(); print_r($page);

$data = array( 'pageSize' => $this->pageSize, 'totalCount' => $this->totalCount, 'count' => $this->count, 'pageCount' => $this->pageCount, 'firstPage' => $this->firstPage, 'firstPageNumber' => $this->firstPageNumber, 'lastPage' => $this->lastPage, 'lastPageNumber' => $this->lastPageNumber, 'prevPage' => $this->prevPage, 'prevPageNumber' => $this->prevPageNumber, 'nextPage' => $this->nextPage, 'nextPageNumber' => $this->nextPageNumber, 'currentPage' => $this->currentPage, 'currentPageNumber' => $this->currentPageNumber, );