ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:selectlimit

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
reference:selectlimit [2015/07/21 19:19] – [$rowsToReturn] mnewnhamv5:reference:connection:selectlimit [2023/07/25 12:55] (current) – [$rowsToReturn] typo dregad
Line 9: Line 9:
          string $sql,          string $sql,
          optional int $rowsToReturn=-1,          optional int $rowsToReturn=-1,
-         optional int $startOffset=1,+         optional int $startOffset=-1,
          optional string[] $bindvars=false          optional string[] $bindvars=false
          }          }
Line 17: Line 17:
 The function executes a statement, and returns a handle to a recordset or false if the statement execution fails. The function executes a statement, and returns a handle to a recordset or false if the statement execution fails.
  
-The presentation of the returned data can be modified by the variables [[reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]  and [[reference:adodb_assoc_case|$ADODB_ASSOC_CASE]] and the function [[reference:setfetchmode|setFetchMode()]].+The presentation of the returned data can be modified by:   
 +  * [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] variable, 
 +  [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant, 
 +  * [[v5:reference:connection:setfetchmode|setFetchMode()]] function.
  
-For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[reference:execute|execute()]].+For a detailed description of the ''$sql'' and ''$bindvars'' parameters passed, see [[v5:reference:connection:execute|execute()]].
  
 ===== $rowsToReturn ===== ===== $rowsToReturn =====
-''$rowsToReturn'' indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned my be less. If the value is -1, then all rows starting at the requested offset. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[reference:execute|execute()]].+''$rowsToReturn'' indicates the maximum number of rows for the request to return. If End-Of-File is reached, the number returned may be less. If the value is -1, then all rows starting at the requested offset are returned. ''selectLimit()'' executed with -1 rows and -1 offset is the same as [[v5:reference:connection:execute|execute()]]
 + 
 +===== $startOffset ===== 
 +''$startOffset'' indicates the n<sup>th</sup> row at which to start the request. Row numbers start at 0.  If the row number is beyond End-Of-File then an empty recordset will be returned.
  
  
Line 31: Line 37:
  * DB2 Connection assumed  * DB2 Connection assumed
 */ */
-$ar $db->getAll("SELECT * FROM ACT");+$SQL = "SELECT * FROM act"
 +$result = $db->selectLimit($SQL,2,3); 
 +while ($r = $result->fetchRow()) 
 +    print_r($r);
  
 /* /*
- $ar returns:+ Returns 2 rows starting at offset 3 (4th record starting at 0) 
 +  
 Array Array
 ( (
-    [0] => Array +    [0] => 40 
-        ( +    [1] => LEADPR 
-            [0] => 10 +    [2] => LEAD PROGRAM/DESIGN 
-            [1] => MANAGE +
-            [2] => MANAGE/ADVISE +Array 
-        +
- +    [0] => 50 
-    [1] => Array +    [1] => SPECS 
-        +    [2] => WRITE SPECS 
-            [0] => 20 +)
-            [1] => ECOST +
-            [2] => ESTIMATE COST +
-        ) +
- +
-    [2] => Array +
-        ( +
-            [0] => 30 +
-            [1] => DEFINE +
-            [2] => DEFINE SPECS+
  
-....... 
 */ */
                          
 </code> </code>
                    
v5/reference/connection/selectlimit.1437499161.txt.gz · Last modified: 2017/04/21 11:33 (external edit)