PHP PDOStatement:: setFetchMode Explanation

PDOStatement::setFetchMode

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

Description

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

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

colno

Column number.

classname

Class name.

ctorargs

Constructor argument.

object

Object.

Return value

Returns TRUE on success or FALSE on failure.

Instances

Set the acquisition mode

The following example demonstrates how to use PDOStatement:: setFetchMode () to change the default fetch mode for an 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 150
banana yellow 250
orange orange 300
kiwi brown 75
lemon yellow 25
pear green 150
watermelon pink 90

Summarize