Submit a Pull Request Report a Bug

    PDOStatement::setFetchMode

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

    PDOStatement::setFetchMode — Définit le mode de récupération par défaut pour cette requête

    Description

    public PDOStatement::setFetchMode(int $mode): bool
    public PDOStatement::setFetchMode(int $mode = PDO::FETCH_COLUMN, int $colno): bool
    public PDOStatement::setFetchMode(int $mode = PDO::FETCH_CLASS, string $class, ?array $constructorArgs): bool
    public PDOStatement::setFetchMode(int $mode = PDO::FETCH_INTO, object $object): bool

    Liste de paramètres

    mode

    Le mode de récupération doit être une des constantes PDO::FETCH_*.

    colno

    Numéro de la colonne.

    class

    Nom de la classe.

    constructorArgs

    Arguments du constructeur.

    object

    Objet.

    Valeurs de retour

    Cette fonction retourne true en cas de succès ou false si une erreur survient.

    Exemples

    Exemple #1 Définition du mode de récupération

    L'exemple suivant montre comment PDOStatement::setFetchMode() modifie le mode de récupération par défaut pour un objet PDOStatement.

    <?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";
    }
    ?>

    Résultat de l'exemple ci-dessus est similaire à :

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

    add a note add a note

    User Contributed Notes 5 notes

    up
    33
    Dormilich at netscape dot net
    11 years ago
    if you want to fetch your result into a class (by using PDO::FETCH_CLASS) and want the constructor to be executed *before* PDO assings the object properties, you need to use the PDO::FETCH_PROPS_LATE constant:

    <?php
    $stmt     = $pdo->prepare("your query");

    $stmt->setFetchMode(PDO::FETCH_CLASS|PDO::FETCH_PROPS_LATE, "className", $constructorArguments);

    # pass parameters, if required by the query
    $stmt->execute($parameters);

    foreach (    $stmt as $row)
    {
            // do something with (each of) your object
    }
    ?>
    up
    6
    Kats
    4 years ago
    Something very helpful is knowing how to access namespaces from the function. It took me a minute (and Google) to figure out. The ::class property is going to be your best friend in this case.

    <?php
    $stmt    ->setFetchMode(PDO::FETCH_CLASS, Name\Space\Class::class);
    ?>
    up
    -3
    stein_AT_rhrk.uni-kl.de
    14 years ago
    Some note on PDO :: FETCH_CLASS | PDO :: FETCH_CLASSTYPE

    It took me some time, to realize, that you can not use this fetch-mode in $stm->setFetchMode(), when you want to retrieve objects from the database whereas the type is defined by the first column in the resultset.
    You have to define this mode directly in the $stm->fetch() method.

    To make it clearer:

    $stm = $pdo->query("SELECT * FROM `foo`);
    $stm->setFetchMode(FETCH_CLASS | PDO :: FETCH_CLASSTYPE);

    $object = $stm->fetch();

    Will not return the expected object, whereas

    $stm = $pdo->query("SELECT * FROM `foo`");

    $object = $stm->fetch(FETCH_CLASS | PDO :: FETCH_CLASSTYPE);

    will give you the object of the class, defined in the first column of `foo`.
    up
    -5
    matt at kynx dot org
    15 years ago
    To fetch the rows into an existing instance of a class, use PDO::FETCH_INTO and pass the object as the second parameter.

    The class _must_ have the column names declared as public members, or the script will die. But overloading with __set() and __get() lets it handle any column your query throws at it. 

    Set the fetch mode right after you call prepare(). It appears you _must_ use execute() - fetch() won't work. A small example, adapted from ext/pdo/tests/pdo_025.phpt:

    <?php
    class Test
    {
        protected     $cols;
       
        function     __set($name, $value) {
                $this->cols[$name] = $value;
        }
       
        function     __get($name) {
            return     $this->cols[$name];
        }
    }

    $obj = new Test();
    $db = PDOTest::factory();
    $stmt = $db->prepare("select * from test");
    $stmt->setFetchMode(PDO::FETCH_INTO, $obj);
    $stmt->execute();

    foreach (    $stmt as $a) {
            print_r($a);
    }

    print_r($obj); // contains the same values as the last iteration above
    ?>
    up
    -6
    Dariusz Kielar
    15 years ago
    PDO::FETCH_CLASS may be used only with this method and it takes up to three parameters then:
    - int mode
    - string className
    - array constructorArgs (optional)

    <?php
    $stmt     = $pdo -> query('your query');
    $stmt -> setFetchMode(PDO::FETCH_CLASS, 'yourClass', array(0 => false));

    while(    $row = $stmt -> fetch())
    {
           // $row is an object of "yourClass" class
    }
    $stmt -> closeCursor();
    ?>

    Note also that the constructor is called AFTER the data is set on the object.
    add a note add a note
    To Top