©
本文档使用
php.cn手册 发布
(PECL maxdb >= 1.0)
maxdb_stmt_fetch -- maxdb_stmt::fetch — Fetch results from a prepared statement into the bound variables
过程化风格
$stmt
)面向对象风格
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() .
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" );
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 )) {
$stmt -> execute ();
$stmt -> bind_result ( $name , $code );
while ( $stmt -> fetch ()) {
printf ( "%s (%s)\n" , $name , $code );
}
$stmt -> close ();
}
$maxdb -> close ();
?>
Example #2 过程化风格
<?php
$link = maxdb_connect ( "localhost" , "MONA" , "RED" , "DEMODB" );
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 )) {
maxdb_stmt_execute ( $stmt );
maxdb_stmt_bind_result ( $stmt , $name , $code );
while ( maxdb_stmt_fetch ( $stmt )) {
printf ( "%s (%s)\n" , $name , $code );
}
maxdb_stmt_close ( $stmt );
}
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)