©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_fetch_field -- maxdb_result::fetch_field — Returns the next field in the result set
过程化风格
$result
)面向对象风格
The maxdb_fetch_field() returns the definition of one column
of a result set as an resource. Call this function repeatedly to retrieve
information about all columns in the result set.
maxdb_fetch_field() returns FALSE
when no more fields
are left.
Returns an resource which contains field definition information or FALSE
if no field information
is available.
Property | Description |
---|---|
name | The name of the column |
max_length | The maximum width of the field for the result set. |
type | The data type used for this field |
decimals | The number of decimals used (for integer fields) |
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 )) {
while ( $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 )) {
while ( $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: 2Name: CNO Table: max. Len: 4 Flags: -1 Type: 0