PHP Tutorial - PHP mysqli_field_tell() Function

Definition

The mysqli_field_tell() function returns the position of the field cursor.

Syntax

PHP mysqli_field_tell() Function has the following syntax.

mysqli_field_tell(result);

Parameter

Parameter	Is Required	Description
result	Required.	Result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result()

Return

Returns current offset of field cursor.

Example

The follwing code gets field info for all fields, then get the current field with mysqli_field_tell() and print each column's name, table, and max length.


<?php//from  www  . j  a va 2s.c om
$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 info for all fields
  while ($fieldinfo=mysqli_fetch_field($result)){
    // Get field cursor position
    $currentfield=mysqli_field_tell($result);
    
    printf("Column %d:\n", $currentfield);
    printf("Name: %s\n", $fieldinfo->name);
    printf("Table: %s\n", $fieldinfo->table);
  }

  // Free result set
  mysqli_free_result($result);
}

mysqli_close($con);
?>

Example 2


<?php// w w  w .  j  a va2s . c  o m
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query = "SELECT name, salary from emp";

if ($result = $mysqli->query($query)) {
    // Get field information for all columns
    while ($finfo = $result->fetch_field()) {
        // get fieldpointer offset
        $currentfield = $result->current_field;

        printf("Column %d:\n", $currentfield);
        printf("Name:     %s\n", $finfo->name);
        printf("Table:    %s\n", $finfo->table);
        printf("max. Len: %d\n", $finfo->max_length);
        printf("Flags:    %d\n", $finfo->flags);
        printf("Type:     %d\n\n", $finfo->type);
    }
    $result->close();
}
$mysqli->close();
?>