PDOStatement::setFetchMode

PDOStatement::setFetchMode — Set the default fetch mode for statements. (PHP 5 >= 5.1.0, PECL pdo >= 0.2.0)

illustrate

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

The mode acquisition mode must be one of the PDO::FETCH_* series of constants.

colno column number.

classname class name.

ctorargs constructor parameters.

object object.

return value

Returns TRUE on success, or FALSE on failure.

Example

Set acquisition mode

The following example demonstrates how to use PDOStatement::setFetchMode() to change the default fetch mode for a PDOStatement object.

 <?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();}?>

The output of the above example is:

 apple red 150banana yellow 250orange orange 300kiwi brown 75lemon yellow 25pear green 150watermelon pink 90