maxdb_stmt_fetch

(PECL maxdb >= 1.0)

Fetch results from a prepared statement into the bound variables

bool maxdb_stmt_fetch ( resource $stmt )

Procedural style

Object oriented style

bool maxdb_stmt::fetch ( void )

maxdb_stmt_fetch() returns row data using the variables bound by maxdb_stmt_bind_result().

Note:

Note that all columns must be bound by the application before calling maxdb_stmt_fetch().

Returns:

**Return values**
Value	Description
`TRUE`	Success. Data has been fetched
`FALSE`	Error occurred
`NULL`	No more rows/data exists

Examples:

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 zip, name FROM hotel.city ORDER by name";
 
if ($stmt = $maxdb->prepare($query)) {
 
   /* execute statement */
   $stmt->execute();
 
   /* bind result variables */
   $stmt->bind_result($name, $code);
 
   /* fetch values */
   while ($stmt->fetch()) {
       printf ("%s (%s)\n", $name, $code);
   }
 
   /* close statement */
   $stmt->close();
}
 
/* close connection */
$maxdb->close();
?>

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 zip, name FROM hotel.city ORDER by name";
 
if ($stmt = maxdb_prepare($link, $query)) {
 
   /* execute statement */
   maxdb_stmt_execute($stmt);
 
   /* bind result variables */
   maxdb_stmt_bind_result($stmt, $name, $code);
 
   /* fetch values */
   while (maxdb_stmt_fetch($stmt)) {
       printf ("%s (%s)\n", $name, $code);
   }
 
   /* close statement */
   maxdb_stmt_close($stmt);
}
 
/* close connection */
maxdb_close($link);
?>