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="SELECT name,age FROM emp";
   $result=mysqli_query($connection_mysql,$sql);
   $row=mysqli_fetch_array($result,MYSQLI_NUM);
   
   print $row[0];
   print "\n";
   print $row[1];
   
   $row=mysqli_fetch_array($result,MYSQLI_ASSOC);
   print $row["name"];
   print "\n";
   print $row["age"];
   
   mysqli_free_result($result);
   mysqli_close($connection_mysql);
?>