PHP 8.4.1 Released!

    PDOStatement::nextRowset

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

    PDOStatement::nextRowset — Advances to the next rowset in a multi-rowset statement handle

    Descrizione

    public PDOStatement::nextRowset(): bool

    Some database servers support stored procedures that return more than one rowset (also known as a result set). PDOStatement::nextRowset() enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a different set of columns from the preceding rowset.

    Elenco dei parametri

    Questa funzione non contiene parametri.

    Valori restituiti

    Restituisce true in caso di successo, false in caso di fallimento.

    Esempi

    Example #1 Fetching multiple rowsets returned from a stored procedure

    The following example shows how to call a stored procedure, MULTIPLE_ROWSETS, which returns three rowsets. We use a do-while loop to call the PDOStatement::nextRowset() method until it returns false and terminates the loop when no more rowsets are available.

    <?php
    $sql     = 'CALL multiple_rowsets()';
    $stmt = $conn->query($sql);
    $i = 1;
    do {
    $rowset = $stmt->fetchAll(PDO::FETCH_NUM);
    if (    $rowset) {
    printResultSet($rowset, $i);
    }
    $i++;
    } while (    $stmt->nextRowset());

    function     printResultSet(&$rowset, $i) {
    print     "Result set $i:\n";
    foreach (    $rowset as $row) {
    foreach (    $row as $col) {
    print     $col . "\t";
    }
    print     "\n";
    }
    print     "\n";
    }
    ?>

    Il precedente esempio visualizzerà:

    Result set 1:
apple    red
banana   yellow

Result set 2:
orange   orange    150
banana   yellow    175

Result set 3:
lime     green
apple    red
banana   yellow

    Vedere anche:

    Improve This Page

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 2 notes

    up
    2
    guilleamathews at gmail dot com
    13 years ago
    PDO::nextRowset() does not appear to be currently supported by the Firebird PDO driver. Unfortunate.
    up
    -2
    et dot coder at gmail dot com
    10 years ago
    on MSSQL and 'dsn' => 'dblib:...',:
    If you know how many count rowset then don't use contruction of do..while.

    <?php
    do {
    $pdoStatement->fetchAll(\PDO::FETCH_ASSOC);
    } while (
    $pdoStatement->nextRowset()
    );
    ?>
    When I get large fetchAll(over 30) for second nextRowset. I get error - Segmentation fault.

    Uses step-by-step insted do..while is fix for this bug:
    <?php
    $pdoStatement    ->fetchAll(\PDO::FETCH_ASSOC);
    $pdoStatement->nextRowset();
    $pdoStatement->fetchAll(\PDO::FETCH_ASSOC);
    ?>
    ＋add a note
    To Top