ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pageExecute ======
~~NOTOC~~
<WRAP right box>
== Syntax ==
  obj pageExecute(
       string $sql
       int $rowsPerPage
       int $pageNumber
       optional mixed $bindVars=false
     )
     
== See Also ==
  * [[v5:reference:connection:cachepageexecute|cachePageExecute()]]
  * [[v5:reference:recordset:atfirstpage|atFirstPage()]]
  * [[v5:reference:recordset:atlastpage|atLastPage()]]

</WRAP>

===== 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 =====
<code php>
$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());

</code>


===== Author =====
The original author of this method was Iván Oliva .