PDOStatement::fetchColumn

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

    PDOStatement::fetchColumn — Returns a single column from the next row of a result set

    Descrição

    publicPDOStatement::fetchColumn(int$column = 0): mixed

    Returns a single column from the next row of a result set or false if there are no more rows.

    Nota:

    PDOStatement::fetchColumn() should not be used to retrieve boolean columns, as it is impossible to distinguish a value of false from there being no more rows to retrieve. Use PDOStatement::fetch() instead.

    Parâmetros

    column

    0-indexed number of the column you wish to retrieve from the row. If no value is supplied, PDOStatement::fetchColumn() fetches the first column.

    Valor Retornado

    PDOStatement::fetchColumn() returns a single column from the next row of a result set or false if there are no more rows.

    Aviso

    There is no way to return another column from the same row if you use PDOStatement::fetchColumn() to retrieve data.

    Erros/Exceções

    Emite um erro de nível E_WARNING se o atributo PDO::ATTR_ERRMODE estiver definido como PDO::ERRMODE_WARNING.

    Lança uma exceção PDOException se o atributo PDO::ATTR_ERRMODE estiver definido como PDO::ERRMODE_EXCEPTION.

    Exemplos

    Exemplo #1 Return first column of the next row

    <?php
    $sth     = $dbh->prepare("SELECT name, colour FROM fruit");
    $sth->execute();

    print     "Fetch the first column from the first row in the result set:\n";
    $result = $sth->fetchColumn();
    print     "name = $result\n";

    print     "Fetch the second column from the second row in the result set:\n";
    $result = $sth->fetchColumn(1);
    print     "colour = $result\n";
    ?>

    O exemplo acima produzirá:

    Fetch the first column from the first row in the result set: name = lemon Fetch the second column from the second row in the result set: colour = red

    Veja Também

    To Top