maxdb_fetch_field_direct

result->fetch_field_direct

(No version information available, 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):

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.

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)

Examples

Example #1 Object oriented style


<?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 Procedural style


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

?>

The above example will output something similar to:

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

maxdb_fetch_field_direct

result->fetch_field_direct

Description

Return Values

Examples

See Also