无涯教程-PHP - mysqli next result函数

mysqli next result - 语法

bool mysqli_next_result ( mysqli $link );

它从mysqli_multi_query()准备下一个输出集。

mysqli next result - 返回值

成功时返回TRUE，失败时返回FALSE。

mysqli next result - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","db");
if (mysqli_connect_errno($connection_mysql</span><span class="pun">)){</span><span class="pln">
      echo </span><span class="str">"Failed to connect to MySQL: "</span><span class="pln"> </span><span class="pun">.</span><span class="pln"> mysqli_connect_error</span><span class="pun">();</span><span class="pln">
   </span><span class="pun">}</span><span class="pln">$sql="SELECT name FROM emp;SELECT Country FROM emp";
if (mysqli_multi_query($connection_mysql</span><span class="pun">,</span><span class="pln">$sql)){
do{
if ($result</span><span class="pun">=</span><span class="pln">mysqli_store_result</span><span class="pun">(</span><span class="pln">$connection_mysql)){
while ($row</span><span class="pun">=</span><span class="pln">mysqli_fetch_row</span><span class="pun">(</span><span class="pln">$result)){
print row</span><span class="pun">[</span><span class="lit">0</span><span class="pun">];</span><span class="pln">
               </span><span class="kwd">print</span><span class="pln"> </span><span class="str">"\n"</span><span class="pun">;</span><span class="pln">
            </span><span class="pun">}</span><span class="pln">
         </span><span class="pun">}</span><span class="pln">
      </span><span class="pun">}</span><span class="kwd">while</span><span class="pln"> </span><span class="pun">(</span><span class="pln">mysqli_next_result</span><span class="pun">(</span><span class="pln">connection_mysql));
}
mysqli_close($connection_mysql);
?>

参考链接

www.learnfk.com/php/php-mys…