PDOStatement::setFetchMode

(PHP 5 >= 5.1.0, PHP 7, PHP 8, PECL pdo >= 0.2.0)

PDOStatement::setFetchMode — Set the default fetch mode for this statement

Опис

public function PDOStatement::setFetchMode(int $mode): true

public function PDOStatement::setFetchMode(int $mode = PDO::FETCH_COLUMN, int $colno): true

public function PDOStatement::setFetchMode(int $mode = PDO::FETCH_CLASS, string $class, ?array $constructorArgs = null): true

public function PDOStatement::setFetchMode(int $mode = PDO::FETCH_INTO, object $object): true

Параметри

mode: The fetch mode must be one of the PDO::FETCH_* constants.
colno: Column number.
class: Class name.
constructorArgs: Constructor arguments.
object: Object.

Значення, що повертаються

Завжди повертає true.

Журнал змін

Версія	Опис
8.4.0	The return type is `true` now; previously, it was bool.

Приклади

Приклад #1 Setting the fetch mode

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

<?php
$stmt = $dbh->query('SELECT name, colour, calories FROM fruit');
$stmt->setFetchMode(PDO::FETCH_NUM);
foreach ($stmt as $row) {
    print $row[0] . "\t" . $row[1] . "\t" . $row[2] . "\n";
}

Поданий вище приклад виведе щось схоже на:

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

PHP is developed and maintained by a global community of contributors.

The PHP Foundation helps fund this work. If PHP is part of your business or projects, consider sponsoring the Foundation.

PHP

My PHP.net Downloads Contact

Learn

Documentation Get Involved

The PHP Foundation

About the Foundation Sponsor Contact

Legal

Privacy Policy