PHP : Function Reference : MaxDB PHP Extension : maxdb_field

Example 1208. 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 cno";


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


   /* Get field information for all columns */

   while ($finfo = $result->fetch_field()) {


       /* get fieldpointer offset */

       $currentfield = $result->current_field;


       printf("Column    %d:\n", $currentfield);

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

   }

   $result->close();

}

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

Example 1209. Procedural style

copy to clipboard

<?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 cno";


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


   /* Get field information for all fields */

   while ($finfo = maxdb_fetch_field($result)) {


       /* get fieldpointer offset */

       $currentfield = maxdb_field_tell($result);


       printf("Column    %d:\n", $currentfield);

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

   }

   maxdb_free_result($result);

}

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

maxdb_field_tell

Get current field offset of a result pointer (PECL maxdb:1.0-7.6.00.38)
int maxdb_field_tell ( resource result )

Example 1208. Object oriented style

Example 1209. Procedural style

Change Language

maxdb_field_tell

Get current field offset of a result pointer (PECL maxdb:1.0-7.6.00.38) int maxdb_field_tell ( resource result )

Example 1208. Object oriented style

Example 1209. Procedural style

Change Language

Get current field offset of a result pointer (PECL maxdb:1.0-7.6.00.38)
int maxdb_field_tell ( resource result )