CMS AP-Fusion - движок для вашего сайта

mysqli_field_seek

(PHP 5)

mysqli_field_seek

(no version information, might be only in CVS)

result->field_seek -- Set result pointer to a specified field offset

Description

Процедурный стиль:

int mysqli_field_seek ( mysqli_result result, int fieldnr )

Объектно-ориентированный стиль (method):

class mysqli_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.

Замечание: To seek to the beginning of a row, pass an offset value of zero.

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

mysqli_field_seek() returns previuos value of field cursor.

Примеры

Пример 1. Объектно-ориентированный стиль


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


?>

Пример 2. Процедурный стиль


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


?>

Результат выполнения данного примера:

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

Все функции PHP:

mysqli_field_seek

Description

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

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

Примеры