maxdb_fetch_assoc

Fetch a result row as an associative array (PECL maxdb:1.0-7.6.00.38)
array maxdb_fetch_assoc ( resource result )

Example 1190. 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, state FROM hotel.city ORDER by zip";


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


   /* fetch associative array */

   while ($row = $result->fetch_assoc()) {

       printf ("%s (%s)\n", $row["NAME"], $row["STATE"]);

   }


   /* free result set */

   $result->close();

}

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

Example 1191. 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, state FROM hotel.city ORDER by zip";


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


   /* fetch associative array */

   while ($row = maxdb_fetch_assoc($result)) {

       printf ("%s (%s)\n", $row["NAME"], $row["STATE"]);

   }


   /* free result set */

   maxdb_free_result($result);

}

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

maxdb_fetch_assoc

Fetch a result row as an associative array (PECL maxdb:1.0-7.6.00.38) array maxdb_fetch_assoc ( resource result )

Example 1190. Object oriented style

Example 1191. Procedural style

Change Language

Fetch a result row as an associative array (PECL maxdb:1.0-7.6.00.38)
array maxdb_fetch_assoc ( resource result )