11111

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 22222

Free Web Hosting