PHP 中的 mysqli field seek函数

mysqli field seek - 语法

mysqli_field_seek(result,fieldNumber);

此函数将列光标设置为给定的列偏移量。

mysqli field seek - 返回值

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

mysqli field seek - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","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)){
      mysqli_field_seek($result,0);
      $fieldinfo=mysqli_fetch_field($result);
      
      print $fieldinfo->name;
      print $fieldinfo->table;
      print $fieldinfo->max_length;
      
      mysqli_free_result($result);
   }
   mysqli_close($connection_mysql);
?>