Are MySQLi queries unbuffered? If not, is there a way to perform unbuffered queries, just like non-MySQLi mysql_unbuffered_query()?
mysql_unbuffered_query()
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(); ?>
mysqli_real_query() back mysqli_use_result()
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
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(); ?>mysqli_real_query() back mysqli_use_result()