PHP. Руководство по PHP. 2005

mysqli_field_tell

Пред.

След.

mysqli_field_tell

(PHP 5)mysqli_field_tell

(no version information, might be only in CVS)result->current_field --

Get current field offset of a result pointer

Description

Procedural style:int mysqli_field_tell (mysqli_result result)

Object oriented style (property):class mysqli_result {

int current_field

}

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().

Возвращаемые значения

Returns current offset of field cursor.

Смотрите также

mysqli_fetch_field() и
mysqli_field_seek().

Примеры

Пример 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 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(); ?>

Пример 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 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); ?>

Результат выполнения данного примера:
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

Пред.
Начало
След.
mysqli_field_seek
Уровень выше
mysqli_free_result

Отвечу на любые вопросы. С уважением, Дмитрий Владимирович.

Ваше письмо	×