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()
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
mysqli_real_query() back mysqli_use_result()