PDOStatement::fetch
(no version information, might be only in CVS)
PDOStatement::fetch -- Fetches the next row from a result setDescription
mixed PDOStatement::fetch ( [int fetch_style [, int cursor_orientation [, int cursor_offset]]] )| Warning |
|
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.
Parameters
- fetch_style
-
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
-
- cursor_orientation
-
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.
- offset
-
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.
Examples
|
Example 2. Fetching rows with a scrollable cursor
The above example will output:
|
See Also
| PDO::query() |
| PDOStatement::fetchAll() |
| PDOStatement::fetchColumn() |
| PDOStatement::prepare() |
| PDOStatement::setFetchMode() |
|
PHP Manual for PHP-Nuke brought to you by Chris Karakas |
