PHP Tutorial - PHP mysqli_fetch_field() Function






Definition

The mysqli_fetch_field() function returns the next column in the result set as an object.

Syntax

PHP mysqli_fetch_field() Function has the following syntax.

mysqli_fetch_field(result);

Parameter

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

Return

It returns an object containing column definition or FALSE for failure. 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)
defreserved for default values
dbdatabase
catalogcatalog name, always "def"
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




Example

The following code returns the next column in the result set, then print each field's name, table, and max length.


<?php/* w w w  .jav  a2 s.  c  o m*/
$con=mysqli_connect("localhost","my_user","my_password","my_db");

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
  while ($fieldinfo=mysqli_fetch_field($result)){
     print $fieldinfo->name;
     print $fieldinfo->table;
     print $fieldinfo->max_length;
  }
  mysqli_free_result($result);
}

mysqli_close($con);
?>