# fetch-field

mysqli_result::fetch_field

mysqli_fetch_field

Returns the next field in the result set

# 

ENTITY

ENTITY

<div data-wrapper="1" role="mysqli_result">

public

</div>

<div data-wrapper="1" role="mysqli_result">

object

</div>

<div data-wrapper="1" role="mysqli_result">

false

</div>

<div data-wrapper="1" role="mysqli_result">

mysqli_result::fetch_field

</div>

ENTITY

object

false

mysqli_fetch_field

mysqli_result

result

Returns the definition of one column of a result set as an object. Call this function repeatedly to retrieve information about all columns in the result set.

# 

ENTITY

# 

ENTITY

Returns an object which contains field definition information or ENTITY if no field information is available.

# 

ENTITY

<div class="example">

<div class="title">

ENTITY

</div>

```
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

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

$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";

if ($result = $mysqli->query($query)) {

    /* Get field information for all columns */
    while ($finfo = $result->fetch_field()) {

        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();
}

/* close connection */
$mysqli->close();
?>

   
```

</div>

<div class="example">

<div class="title">

ENTITY

</div>

```
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

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

$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";

if ($result = mysqli_query($link, $query)) {

    /* Get field information for all fields */
    while ($finfo = mysqli_fetch_field($result)) {

        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);
    }
    mysqli_free_result($result);
}

/* close connection */
mysqli_close($link);
?>

   
```

ENTITY

    Name:     Name
    Table:    Country
    max. Len: 11
    Flags:    1
    Type:     254

    Name:     SurfaceArea
    Table:    Country
    max. Len: 10
    Flags:    32769
    Type:     4


       

</div>

# 

ENTITY

`mysqli_num_fields`, `mysqli_fetch_field_direct`, `mysqli_fetch_fields`, `mysqli_field_seek`