PHP Tutorial - PHP mysqli_fetch_fields() Function


The mysqli_fetch_fields() function returns an array of objects that represent the columns in a result set.




ParameterIs RequiredDescription
resultRequired.Resultset returned by mysqli_query(), mysqli_store_result() or mysqli_use_result()


It returns an array of objects containing column definition information or FALSE if no info is available.

The returning objects have 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)
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 return an array of objects that represent the columns in a result set, then print each field's name, table, and max length.

<?php//from w  w w. j a  va2s  .co  m

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

$sql="SELECT name FROM emp";

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

  foreach ($fieldinfo as $val){
      printf("Name: %s\n",$val->name);
      printf("Table: %s\n",$val->table);
      printf("max. Len: %d\n",$val->max_length);