PHP Tutorial - 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

Parameter	Is Required	Description
result	Required.	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 Name	Meaning
name	name of the column
orgname	original column name (if an alias is used)
table	name of table
orgtable	original table name (if an alias is used)
max_length	maximum width of field
length	width of field as specified in table definition
charsetnr	character set number for the field
flags	bit-flags for the field
type	data type used for the field
decimals	for 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//from w  w w. j a  va2s  .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);
?>