mysqli::reap_async_query

    mysqli_reap_async_query

    (PHP 5 >= 5.3.0, PHP 7, PHP 8)

    mysqli::reap_async_query -- mysqli_reap_async_query — Get result from async query

    Descrizione

    Stile orientato agli oggetti

    public mysqli::reap_async_query(): mysqli_result|bool

    Stile procedurale

    mysqli_reap_async_query(mysqli $mysql): mysqli_result|bool

    Get result from async query.

    Nota:

    Disponibile solo con mysqlnd.

    Elenco dei parametri

    link

    Solo nello stile procedurale: un identificatore restituito da mysqli_connect() o mysqli_init()

    Valori restituiti

    Returns false on failure. For successful queries which produce a result set, such as SELECT, SHOW, DESCRIBE or EXPLAIN, mysqli_reap_async_query() will return a mysqli_result object. For other successful queries, mysqli_reap_async_query() will return true.

    Errori/Eccezioni

    If mysqli error reporting is enabled (MYSQLI_REPORT_ERROR) and the requested operation fails, a warning is generated. If, in addition, the mode is set to MYSQLI_REPORT_STRICT, a mysqli_sql_exception is thrown instead.

    Vedere anche:

    Improve This Page

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

    User Contributed Notes 1 note

    up
    5
    eric dot caron at gmail dot com
    14 years ago
    Keep in mind that mysqli::reap_async_query only returns mysqli_result on queries like SELECT. For queries where you may be interested in things like affected_rows or insert_id, you can't work off of the result of mysqli::reap_async_query as the example in mysqli::poll leads you to believe. For INSERT/UPDATE/DELETE queries, the data corresponding to the query can be accessed through the associated key to the first array in the mysqli::poll function.

    So instead of
    <?php
    foreach ($links as $link) {
    if (    $result = $link->reap_async_query()) {
    print_r($result->fetch_row());
    mysqli_free_result($result);
    $processed++;
    }
    }
    ?>

    The data is accessible via:
    <?php
    foreach ($links as $link) {
    if (    $result = $link->reap_async_query()) {
    //This works for SELECT
    if(is_object($result)){
    print_r($result->fetch_row());
    mysqli_free_result($result);
    }
    //This works for INSERT/UPDATE/DELETE
    else {
    print_r($link);
    }
    $processed++;
    }
    }
    ?>
    ＋add a note
    To Top