©
本文檔使用 php中文網手册 發布
(PECL maxdb >= 1.0)
maxdb_field_seek -- maxdb_result::field_seek — Set result pointer to a specified field offset
过程化风格
$result
, int $fieldnr
)面向对象风格
$fieldnr
)Sets the field cursor to the given offset. The next call to maxdb_fetch_field() will retrieve the field definition of the column associated with that offset.
Note:
To seek to the beginning of a row, pass an offset value of zero.
maxdb_field_seek() returns previuos value of field cursor.
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$query = "SELECT name, cno from hotel.customer ORDER BY cno" ;
if ( $result = $maxdb -> query ( $query )) {
$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 ();
}
$maxdb -> close ();
?>
Example #2 过程化风格
<?php
$link = maxdb_connect ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$query = "SELECT name, cno from hotel.customer ORDER BY cno" ;
if ( $result = maxdb_query ( $link , $query )) {
maxdb_field_seek ( $result , 1 );
$finfo = maxdb_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 );
maxdb_free_result ( $result );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
Name: NAME Table: max. Len: 10 Flags: -1 Type: 2