PHP Tutorial - PHP mysqli_fetch_field_direct() Function


The mysqli_fetch_field_direct() function returns meta-data for a single column in the result set as an object.




ParameterIs RequiredDescription
resultRequired.Result set returned by mysqli_query(), mysqli_store_result() or mysqli_use_result()
fieldIndexRequired.Field index. Must be an integer between 0 and number_of_column - 1


It returns an object containing field definition information or FALSE if fails.

The returning object has the following properties.

Property NameMeaning
namename of the column
orgnameoriginal column name (if an alias is used)
tablename of table
orgtableoriginal table name (if an alias is used)
defdefault value for this field
max_lengthmaximum width of field
lengthwidth of field as specified in table definition
charsetnrcharacter set number for the field
flagsbit-flags for the field
typedata type used for the field
decimalsfor integer fields; the number of decimals used


The following code returns meta-data for a single column in the result set, then print the field's name, table, and max length.

<?php/* www.  j  ava 2 s .  c  o  m*/

if (mysqli_connect_errno($con)){
  echo "Failed to connect to MySQL: " . mysqli_connect_error();

$sql="SELECT Lastname FROM Persons";

if ($result=mysqli_query($con,$sql)){
  // Get field information for "Age"

  print $fieldinfo->name;
  print $fieldinfo->table;
  print $fieldinfo->max_length;