mysqli_result::$current_field, mysqli_field_tell

• mysqli_result::$current_field

  mysqli_field_tell

  Get current field offset of a result pointer

Description

Object oriented styleint mysqli_result->current_field ;

Procedural styleint mysqli_field_tell(mysqli_result result);

Returns the position of the field cursor used for the last mysqli_fetch_field call. This value can be used as an argument to mysqli_field_seek.

Parameters

result

Procedural style only: A result set identifier returned by mysqli_query, mysqli_store_result or mysqli_use_result.

Return Values

Returns current offset of field cursor.

Examples

Example 20.175. 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 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();
}
/* close connection */
$mysqli->close();
?>

Example 20.176. 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 all fields */
 while ($finfo = mysqli_fetch_field($result)) {
 /* get fieldpointer offset */
 $currentfield = mysqli_field_tell($result);
 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);
 }
 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

mysqli_field_seek

Retornar