Edit Report a Bug

    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

    Description

    Procedural style

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

    Object oriented style

    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.

    Return Values

    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)

    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

    See Also

    add a note add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top