IT. Expert System.

PHP

Fetch meta-data for a single field


maxdb_fetch_field_direct

maxdb_result::fetch_field_direct

(PECL maxdb >= 1.0)

maxdb_fetch_field_direct -- maxdb_result::fetch_field_directFetch meta-data for a single field

Description

Procedural style

mixed maxdb_fetch_field_direct ( resource $result , int $fieldnr )

Object oriented style

mixed maxdb_result::fetch_field_direct ( int $fieldnr )

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

   
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



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 573 / 158670801. Delta: 0.02744 с