无涯教程-PHP - mysqli fetch all函数 mysqli fetch all - 语法 mysqli_

mysqli fetch all - 语法

mysqli_fetch_all(result,resulttype);

它用于提取所有输出行，并将输出集作为关联数组返回

Sr.No	参数 & Description
1	result 它指定输出集标识符
2	resulttype 它指定应该生成的数组类型

Sr.No

参数 & Description

result

它指定输出集标识符

resulttype

它指定应该生成的数组类型

mysqli fetch all - 返回值

它返回一个包含输出行的关联数组。

mysqli fetch all - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","pass","db");
if (mysqli_connect_errno($connection_mysql)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
 $sql</span><span class="pun">=</span><span class="str">"SELECT name FROM emp"</span><span class="pun">;</span><span class="pln">$ result=mysqli_query( $connection_mysql</span><span class="pun">,</span><span class="pln">$ sql);
mysqli_fetch_all( $result</span><span class="pun">,</span><span class="pln">MYSQLI_ASSOC</span><span class="pun">);</span><span class="pln"> mysqli_free_result</span><span class="pun">(</span><span class="pln">$ result);
mysqli_close($connection_mysql);
?>

无涯教程-PHP - mysqli fetch all函数

mysqli fetch all - 语法

mysqli fetch all - 返回值

mysqli fetch all - 示例

参考链接