maxdb_fetch_fields

Returns an array of resources representing the fields in a result set (PECL maxdb:1.0-7.6.00.38)
mixed maxdb_fetch_fields ( resource result )

Example 1196. 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 */

   $finfo = $result->fetch_fields();


   foreach ($finfo as $val) {

       printf("Name:     %s\n", $val->name);

       printf("Table:    %s\n", $val->table);

       printf("max. Len: %d\n", $val->max_length);

       printf("Flags:    %d\n", $val->flags);

       printf("Type:     %d\n\n", $val->type);

   }

   $result->close();

}

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

Example 1197. 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 columns */

   $finfo = maxdb_fetch_fields($result);


   foreach ($finfo as $val) {

       printf("Name:     %s\n", $val->name);

       printf("Table:    %s\n", $val->table);

       printf("max. Len: %d\n", $val->max_length);

       printf("Flags:    %d\n", $val->flags);

       printf("Type:     %d\n\n", $val->type);

   }

   maxdb_free_result($result);

}

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

maxdb_fetch_fields

Returns an array of resources representing the fields in a result set (PECL maxdb:1.0-7.6.00.38) mixed maxdb_fetch_fields ( resource result )

Example 1196. Object oriented style

Example 1197. Procedural style

Change Language

Returns an array of resources representing the fields in a result set (PECL maxdb:1.0-7.6.00.38)
mixed maxdb_fetch_fields ( resource result )