maxdb_fetch_field_direct

maxdb_result::fetch_field_direct

(PECL maxdb >= 1.0)

maxdb_fetch_field_direct -- maxdb_result::fetch_field_direct — Fetch meta-data for a single field

说明

过程化风格

maxdb_fetch_field_direct ( resource $result , int $fieldnr ) : mixed

面向对象风格

maxdb_result::fetch_field_direct ( int $fieldnr ) : mixed

maxdb_fetch_field_direct() returns an resource which contains field definition information from specified resultset. The value of fieldnr must be in the range from 0 to number of fields - 1.

返回值

Returns an resource which contains field definition information or FALSE if no field information for specified fieldnr is available.

Object attributes
Attribute 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");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT name, cno from hotel.customer ORDER BY name";

if ($result = $maxdb->query($query)) {

   /* Get field information for column 'SurfaceArea' */
   $finfo = $result->fetch_field_direct(1);

   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", $finfo->type);

   $result->close();
}

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$query = "SELECT name, cno from hotel.customer ORDER BY name";

if ($result = maxdb_query($link, $query)) {

   /* Get field information for column 'cno' */
   $finfo = maxdb_fetch_field_direct($result, 1);

   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", $finfo->type);

   maxdb_free_result($result);
}

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于：

Name:     CNO
Table:
max. Len: 4
Flags:    -1
Type:     0

参见

相关文章
php dba 函数 fetch data specified by keyphp maxdb 函数 别名 maxdb stmt close long dataphp maxdb 函数 fetch a result row as an associative a numeric array or bothphp maxdb 函数 fetch a result row as an associative arrayphp maxdb 函数 fetch meta data for a single fieldphp maxdb 函数 returns the next field in the result setphp maxdb 函数 别名 maxdb stmt fetchphp maxdb 函数 set result pointer to a specified field offsetphp maxdb 函数 get current field offset of a result pointerphp maxdb 函数 别名 maxdb stmt send long dataphp maxdb 函数 ends a sequence of maxdb stmt send long dataphp maxdb 函数 fetch results from a prepared statement into the bound variablesphp maxdb 函数 send data in blocksphp rrd 函数 fetch the data for graph as arrayphp 网络 函数 别名 stream get meta dataphp sqlite 函数 别名 sqlite fetch singlephp sqlsrv 函数 gets field data from the currently selected rowphp ssh2 函数 fetch an extended data streamphp mnogosearch 函数 fetch a result fieldphp mysqli result fetch meta data for a single field
关注编程学问公众号