|
(no version information, might be only in CVS)
PDOStatement::fetch -- Fetches the next row from a result setWarning |
This function is EXPERIMENTAL. The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk. |
Fetches a row from a result set associated with a PDOStatement object.
Controls how the next row will be returned to the caller. This value must be one of the PDO_FETCH_* constants, defaulting to PDO_FETCH_BOTH.
PDO_FETCH_ASSOC: returns an array indexed by column name as returned in your result set
PDO_FETCH_BOTH (default): returns an array indexed by both column name and column number as returned in your result set
PDO_FETCH_BOUND: returns TRUE and assigns the values of the columns in your result set to the PHP variables to which they were bound with the PDOStatement::bindParam() method
PDO_FETCH_LAZY: combines PDO_FETCH_BOTH and PDO_FETCH_OBJ, creating the object variable names as they are accessed
PDO_FETCH_OBJ: returns an anonymous object with property names that correspond to the column names returned in your result set
PDO_FETCH_NUM: returns an array indexed by column number as returned in your result set, starting at column 0
For a PDOStatement object representing a scrollable cursor, this value determines which row will be returned to the caller. This value must be one of the PDO_FETCH_ORI_* constants, defaulting to PDO_FETCH_ORI_NEXT.
For a PDOStatement object representing a scrollable cursor for which the cursor_orientation parameter is set to PDO_FETCH_ORI_ABS, this value specifies the absolute number of the row in the result set that shall be fetched.
For a PDOStatement object representing a scrollable cursor for which the cursor_orientation parameter is set to PDO_FETCH_ORI_REL, this value specifies the row to fetch relative to the cursor position before PDOStatement::fetch() was called.
Example 2. Fetching rows with a scrollable cursor
The above example will output:
|
PDO::query() |
PDOStatement::fetchAll() |
PDOStatement::fetchColumn() |
PDOStatement::prepare() |
PDOStatement::setFetchMode() |
Hosting by: Hurra Communications Ltd.
Generated: 2007-01-26 18:00:10