PDOStatement :: setFetchMode
PDOStatement :: setFetchMode - set the default acquisition mode for the statement. (PHP 5> = 5.1.0, PECL pdo> = 0.2.0)
Explanation
grammar
bool PDOStatement::setFetchMode ( int $mode )
bool PDOStatement::setFetchMode ( int $PDO::FETCH_COLUMN , int $colno )
bool PDOStatement::setFetchMode ( int $PDO::FETCH_CLASS , string $classname , array $ctorargs )
bool PDOStatement::setFetchMode ( int $PDO::FETCH_INTO , object $object )
parameter
mode
Acquisition mode must be PDO :: FETCH_ * constants in a series.
colno
Column number.
classname
Class name.
ctorargs
Constructor parameters.
object
Object.
return value
Successful return TRUE, or on failure returns FALSE.
Examples
Setting acquisition mode
The following example demonstrates how PDOStatement :: setFetchMode () to change the default to a PDOStatement object acquisition mode.
<?php $sql = 'SELECT name, colour, calories FROM fruit'; try { $stmt = $dbh->query($sql); $result = $stmt->setFetchMode(PDO::FETCH_NUM); while ($row = $stmt->fetch()) { print $row[0] . "\t" . $row[1] . "\t" . $row[2] . "\n"; } } catch (PDOException $e) { print $e->getMessage(); } ?>
Output of the above example:
apple red 150 banana yellow 250 orange orange 300 kiwi brown 75 lemon yellow 25 pear green 150 watermelon pink 90