Latest web development tutorials

PDOStatement :: setFetchMode

PHP PDO Reference Manual PHP PDO Reference Manual

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

PHP PDO Reference Manual PHP PDO Reference Manual