PDOStatement::setFetchMode

PHP PDO Reference Manual

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

Description

Syntax

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 )

Parameters

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

colno
The column number.

classname
The class name.

ctorargs
Constructor arguments.

object
The object.

Return Values

Returns TRUE on success or FALSE on failure.

Examples

Set Fetch 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 above example outputs:

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

PHP PDO Reference Manual