php man page for mysqli_field_tell

Query: mysqli_field_tell

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

MYSQLI_FIELD_TELL(3)							 1						      MYSQLI_FIELD_TELL(3)

mysqli_result::$current_field - Get current field offset of a result pointer

       Object oriented style

SYNOPSIS
int$mysqli_result->current_field ()
DESCRIPTION
Procedural style int mysqli_field_tell (mysqli_result $result) Returns the position of the field cursor used for the last mysqli_fetch_field(3) call. This value can be used as an argument to mysqli_field_seek(3).
PARAMETERS
o $ result -Procedural style only: A result set identifier returned by mysqli_query(3), mysqli_store_result(3) or mysqli_use_result(3).
RETURN VALUES
Returns current offset of field cursor.
EXAMPLES
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 ", 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()) { /* get fieldpointer offset */ $currentfield = $result->current_field; printf("Column %d: ", $currentfield); printf("Name: %s ", $finfo->name); printf("Table: %s ", $finfo->table); printf("max. Len: %d ", $finfo->max_length); printf("Flags: %d ", $finfo->flags); printf("Type: %d ", $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 ", 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)) { /* get fieldpointer offset */ $currentfield = mysqli_field_tell($result); printf("Column %d: ", $currentfield); printf("Name: %s ", $finfo->name); printf("Table: %s ", $finfo->table); printf("max. Len: %d ", $finfo->max_length); printf("Flags: %d ", $finfo->flags); printf("Type: %d ", $finfo->type); } mysqli_free_result($result); } /* close connection */ mysqli_close($link); ?> The above examples will output: Column 1: Name: Name Table: Country max. Len: 11 Flags: 1 Type: 254 Column 2: Name: SurfaceArea Table: Country max. Len: 10 Flags: 32769 Type: 4
SEE ALSO
mysqli_fetch_field(3), mysqli_field_seek(3). PHP Documentation Group MYSQLI_FIELD_TELL(3)
Related Man Pages
maxdb_fetch_fields(3) - php
maxdb_field_seek(3) - php
mysqli_data_seek(3) - php
mysqli_fetch_lengths(3) - php
mysqli_field_seek(3) - php
Similar Topics in the Unix Linux Community
AwK printf question
printf Hexadecimal output
awk printf format in columns
Sum Of Column Based On Column Condition
Add Column base on other Column Data