v5:reference:connection:pageexecute
pageExecute
Syntax
obj pageExecute(
string $sql
int $rowsPerPage
int $pageNumber
optional mixed $bindVars=false
)
See Also
Description
The method pageExecute() will select the supplied $pageNumber from a recordset, given that it is paginated in pages of $rowsPerPage rows. It also saves two boolean values indicating whether 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->pageExecute($SQL,15,2); print_r($result->getAll());
Author
The original author of this method was Iván Oliva .
v5/reference/connection/pageexecute.txt · Last modified: by dregad