mysqli_poll
X

mysqli_poll

Funkcija mysqli_poll se uporablja za anketiranje povezav.

mysqli_poll
mysqli_poll
PRIMER
<?php
$streznik = "localhost";
$uporabniskoIme = "root";
$geslo = "";
$baza_podatkov = "mysqli_baza_podatkov";

$povezava = mysqli_connect($streznik, $uporabniskoIme, $geslo, $baza_podatkov);

if (mysqli_connect_errno()) {
    echo mysqli_connect_errno();
    exit();
}

$tabela = "SELECT * FROM mysqli_tabela";

$vse_povezave = array();
for ($i = 0; $i < 10; $i++) {
    $pov = mysqli_connect("localhost", "root", "", "mysqli_baza_podatkov");
    $pov -> query($tabela, MYSQLI_ASYNC);
    $vse_povezave[] = $pov;
}

$proces = 0;
do {
    $povezave = $errors = $reject = array();
    foreach ($vse_povezave as $pov) {
        $povezave[] = $errors[] = $reject[] = $pov;
    }
    if (!mysqli_poll($povezave, $errors, $reject, 1)) {
        continue;
    }
    foreach ($povezave as $pov) {
        if ($rezultat = $pov -> reap_async_query()) {
            print_r($rezultat -> fetch_row());
            if (is_object($rezultat))
                mysqli_free_result($rezultat);
        }   else die(mysqli_error($povezava));
        $proces++;
    }
}   while ($proces < count($vse_povezave));

mysqli_close($povezava);
            
REZULTAT
Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 ) Array ( [0] => 1 [1] => Jabolka [2] => Radič [3] => 2024-07-14 09:24:05 )