PHP mysqli_fetch_fields() Function

Definition

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

Syntax

mysqli_fetch_fields(result);

Parameter

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

Return

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

Example

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//w w  w.j  a  v  a2s  . co 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
  $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($con);
?>




















Home »
  PHP Tutorial »
    Function reference »




PHP Array Functions
PHP Calendar Functions
PHP Class Functions
PHP Data Type Functions
PHP Date Functions
PHP File Functions
PHP Image Functions
PHP Math Functions
PHP MySQLi Functions
PHP SimpleXML Functions
PHP String Functions
PHP XML Functions
PHP Zip Functions