11111

maxdb_fetch_field_direct

Пред.

След.

maxdb_fetch_field_direct

(PECL)maxdb_fetch_field_direct

(no version information, might be only in CVS)result->fetch_field_direct -- Fetch meta-data for a single field

Description

Procedural style:mixed maxdb_fetch_field_direct (resource result, int fieldnr)

Object oriented style (method):class result {

mixed fetch_field_direct (int fieldnr)

}

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

Return values

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

Таблица 1. Object attributes
AttributeDescription
nameThe name of the column
max_lengthThe maximum width of the field for the result set.
typeThe data type used for this field
decimalsThe number of decimals used (for integer fields)

See also

- maxdb_num_fields() maxdb_fetch_field() maxdb_fetch_fields()

Example

Пример 1. Object oriented style

<?

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

?>

Пример 2. Procedural style

<?

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

?>

- The above examples would produce the following output: 
Name: CNO

Table:

max. Len: 4

Flags: -1

Type: 0

Пред.

Начало

След.

maxdb_fetch_assoc

Уровень выше

maxdb_fetch_field 22222

Free Web Hosting