Unbuffered queries in MySQLi?
P粉769413355
P粉769413355 2023-10-24 14:58:46
0
2
593

Are MySQLi queries unbuffered? If not, is there a way to perform unbuffered queries, just like non-MySQLi mysql_unbuffered_query()?

P粉769413355
P粉769413355

reply all(2)
P粉216807924

MindStalker is right, but perhaps the easiest way is the one shown in the PHP manual
http: //php.net/manual/en/mysqlinfo.concepts.buffering.php

Passing the MYSQLI_USE_RESULT constant as the resultmode parameter, you can set mysqli_query to be used as mysql_unbuffered_query

query("SELECT Name FROM City", MYSQLI_USE_RESULT);

if ($uresult) {
   while ($row = $uresult->fetch_assoc()) {
       echo $row['Name'] . PHP_EOL;
   }
}
$uresult->close();
?>
P粉377412096

mysqli_real_query() back mysqli_use_result()

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template