PHP mysqli: poll() function

mysqli_poll function / mysqli::poll

The mysqli_poll function / mysqli::poll — Poll connections


Object oriented style

public static int mysqli::poll ( array &$read , array &$error , array &$reject , int $sec [, int $usec ] )

Procedural style

int mysqli_poll ( array &$read , array &$error , array &$reject , int $sec [, int $usec ] )


Name Description
read List of connections to check for outstanding results that can be read.
error List of connections on which an error occured, for example, query failure or lost connection.
reject List of connections rejected because no asynchronous query has been run on for which the function could poll results.
sec Maximum number of seconds to wait, must be non-negative.
usec Maximum number of seconds to wait, must be non-negative.

Usage: Procedural style



Name Description Required/Optional
connection Specifies the MySQL connection to use Required

Return value:

Returns number of ready connections upon success, FALSE otherwise.

Version: PHP 5, PHP 7


$link1 = mysqli_connect();
$link1->query("SELECT 'test'", MYSQLI_ASYNC);
$all_links = array($link1);
$processed = 0;
do {
    $links = $errors = $reject = array();
    foreach ($all_links as $link) {
        $links[] = $errors[] = $reject[] = $link;
    if (!mysqli_poll($links, $errors, $reject, 1)) {
    foreach ($links as $link) {
        if ($result = $link->reap_async_query()) {
            if (is_object($result))
        } else die(sprintf("MySQLi Error: %s", mysqli_error($link)));
} while ($processed < count($all_links));

See also

PHP Function Reference

Previous: ping
Next: prepare

Follow us on Facebook and Twitter for latest update.