PHP 中的 mysqli fetch fields函数

mysqli fetch fields - 语法

mysqli_fetch_fields(result);

它用于返回对象数组。

mysqli fetch fields - 返回值

它返回一个对象数组，其中包含输出集中的列，如果失败，则返回FALSE

mysqli fetch fields - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","passwprd","db");
   
   if (mysqli_connect_errno($connection_mysql)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
   
   $sql="SELECT name FROM emp";
   
   if ($result=mysqli_query($connection_mysql,$sql)){
      $fieldinfo=mysqli_fetch_fields($result);
      
      foreach ($fieldinfo as $val){
         printf("Name: %s\n",$val->name);
         printf("Table: %s\n",$val->table);
         printf("max. Len: %d\n",$val->max_length);
      }
		
      mysqli_free_result($result);
   }
   mysqli_close($connection_mysql);
?>