©
本文檔使用 php中文網手册 發布
(PECL maxdb >= 1.0)
maxdb_fetch_fields -- maxdb_result::fetch_fields — Returns an array of resources representing the fields in a result set
过程化风格
$result
)面向对象风格
This function serves an identical purpose to the maxdb_fetch_field() function with the single difference that, instead of returning one resource at a time for each field, the columns are returned as an array of resources.
Returns an array of resources 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 )) {
$finfo = $result -> fetch_fields ();
foreach ( $finfo as $val ) {
printf ( "Name: %s\n" , $val -> name );
printf ( "Table: %s\n" , $val -> table );
printf ( "max. Len: %d\n" , $val -> max_length );
printf ( "Flags: %d\n" , $val -> flags );
printf ( "Type: %d\n\n" , $val -> 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 )) {
$finfo = maxdb_fetch_fields ( $result );
foreach ( $finfo as $val ) {
printf ( "Name: %s\n" , $val -> name );
printf ( "Table: %s\n" , $val -> table );
printf ( "max. Len: %d\n" , $val -> max_length );
printf ( "Flags: %d\n" , $val -> flags );
printf ( "Type: %d\n\n" , $val -> 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