PHP Reference

Description

Procedural style:

int mysqli_field_seek ( object result, int fieldnr)

Object oriented style (method):

class result {

int field_seek ( int fieldnr)

}

Sets the field cursor to the given offset. The next call to mysqli_fetch_field() will retrieve the field definition of the column associated with that offset.

Note: To seek to the beginning of a row, pass an offset value of zero.

Example

Example 1. Object oriented style


<?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 2nd column */

    $result->field_seek(1);

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

?>

Example 2. Procedural style


<?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 2nd column */

    mysqli_field_seek($result, 1);

    $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);

?>

The above examples would produce the following output:

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

mysqli_field_seek

Description

Return values

See also

Example