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

mysqli fetch array - 语法

mysqli_fetch_array(result,resulttype);

它用于将输出行提取为关联数组

mysqli fetch array - 返回值

它返回与提取的行相对应的字符串数组。

mysqli fetch array - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","username","password","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,age FROM emp"</span><span class="pun">;</span><span class="pln">$result=mysqli_query($connection_mysql</span><span class="pun">,</span><span class="pln">$sql);
$row</span><span class="pun">=</span><span class="pln">mysqli_fetch_array</span><span class="pun">(</span><span class="pln">$result,MYSQLI_NUM);
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="kwd">print</span><span class="pln">$row[1];
$row</span><span class="pun">=</span><span class="pln">mysqli_fetch_array</span><span class="pun">(</span><span class="pln">$result,MYSQLI_ASSOC);
print $row</span><span class="pun">[</span><span class="str">"name"</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="kwd">print</span><span class="pln">$row["age"];
mysqli_free_result($result</span><span class="pun">);</span><span class="pln">
   mysqli_close</span><span class="pun">(</span><span class="pln">$connection_mysql);
?>

参考链接

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