ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:cachepageexecute

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.txt · Last modified: 2016/01/17 03:39 by mnewnham