v5:reference:connection:cachepageexecute
This is an old revision of the document!
cachePageExecute
Syntax
obj cachePageExecute( int $secs2cache, string $sql int $rowsPerPage int $pageNumber optional mixed $bindVars=false )
Description
The method cachePageExecute()
will select the supplied $pageNumber from a a possibl cached recordset, given that it is paginated in pages of $rowsPerPage rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset.
Usage
$SQL = "SELECT * FROM Orders"; /* * Gets the second page of records, based on 15 records per page */ $result = $db->cachePageExecute(3600,$SQL,15,2); print_r($result->getAll());
v5/reference/connection/cachepageexecute.1452648629.txt.gz · Last modified: 2017/04/21 11:36 (external edit)