PDOStatement::fetchSingle
(no version information, might be only in CVS)
PDOStatement::fetchSingle --
Returns the first column in the next row of a result set
Description
string
PDOStatement::fetchSingle ( void )
| 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. |
Return Values
PDOStatement::fetchSingle() returns the first column
in the next row of a result set as a string value.
| Warning |
There is no way to return the second or subsequent columns from a row
if you use this method to retrieve data.
|
Examples
Example 1. Return first column of the next row
<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();
/* Fetch the first column from the next row in the result set */
print("Fetch the first column from the next row in the result set:\n");
$result = $sth->fetchSingle();
print("$result\n");
$result = $sth->fetchSingle();
print("$result\n");
?>
|
The above example will output: Fetch the first column from the next row in the result set:
lemon
orange |
|
See Also
| PDO::query() |
| PDOStatement::fetch() |
| PDOStatement::fetchAll() |
| PDOStatement::prepare() |
| PDOStatement::setFetchMode() |