PHP mysqli_fetch_field_direct() Function

In this chapter you will learn:

Definition for PHP mysqli_fetch_field_direct() Function
Syntax for PHP mysqli_fetch_field_direct() Function
Parameter for PHP mysqli_fetch_field_direct() Function
Return for PHP mysqli_fetch_field_direct() Function
Example - returns meta-data for a single column in the result set

Definition

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

Syntax

mysqli_fetch_field_direct(result,fieldIndex);

Parameter

Parameter	Is Required	Description
result	Required.	Result set returned by mysqli_query(), mysqli_store_result() or mysqli_use_result()
fieldIndex	Required.	Field index. Must be an integer between 0 and number_of_column - 1

Return

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

The returning object has 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)
def	default value for this field
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 returns meta-data for a single column in the result set, then print the field's name, table, and max length.


<?php//  j a va2  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 Lastname FROM Persons";

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

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

  mysqli_free_result($result);
}

mysqli_close($con);
?>