ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


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: 2022/06/25 11:20 by dregad