maxdb_stmt_fetch

maxdb_stmt::fetch

(PECL maxdb >= 1.0)

maxdb_stmt_fetch -- maxdb_stmt::fetchFetch results from a prepared statement into the bound variables

说明

过程化风格

maxdb_stmt_fetch ( resource $stmt ) : bool

面向对象风格

maxdb_stmt::fetch ( void ) : bool

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().

返回值

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

范例

Example #1 面向对象风格

<?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();
?>

Example #2 过程化风格

<?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);
?>

以上例程的输出类似于:

12203 (Albany)
60601 (Chicago)
60615 (Chicago)
45211 (Cincinnati)
33575 (Clearwater)
75243 (Dallas)
32018 (Daytona Beach)
33441 (Deerfield Beach)
48226 (Detroit)
90029 (Hollywood)
92714 (Irvine)
90804 (Long Beach)
11788 (Long Island)
90018 (Los Angeles)
70112 (New Orleans)
10019 (New York)
10580 (New York)
92262 (Palm Springs)
97213 (Portland)
60018 (Rosemont)
95054 (Santa Clara)
20903 (Silver Spring)
20005 (Washington)
20019 (Washington)
20037 (Washington)

参见

相关文章
php cubrid 函数 bind variables to a prepared statement as parametersphp maxdb 函数 enable reads from masterphp maxdb 函数 check if there any more query results from a multi queryphp maxdb 函数 escapes special characters in a string for use in an sql statement taking into account the current charset of the connectionphp maxdb 函数 binds variables to a prepared statement as parametersphp maxdb 函数 binds variables to a prepared statement for result storagephp maxdb 函数 closes a prepared statementphp maxdb 函数 returns the error code for the most recent statement callphp maxdb 函数 fetch results from a prepared statement into the bound variablesphp maxdb 函数 resets a prepared statementphp maxdb 函数 returns result set metadata from a prepared statementphp maxdb 函数 returns sqlstate error from previous statement operationphp maxdb 函数 transfers a result set from a prepared statementphp msession 函数 set msession variables from an arrayphp mysql xdevapi 函数 bind prepared statement variables as parametersphp ncurses 函数 copies a region from a pad into the virtual screenphp odbc 函数 execute a prepared statementphp postgresql 函数 sends a request to create a prepared statement with the given parameters without waiting for completionphp mysqli stmt fetch results from a prepared statement into the bound variablesphp sdo das relational 函数 executes an sql query passed as a prepared statement with a list of values to substitute for placeholders and return the results as a normalised data graph
关注编程学问公众号