©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_fetch_object -- maxdb_result::fetch_object — Returns the current row of a result set as an object
过程化风格
$result
)面向对象风格
The maxdb_fetch_object() will return the current row result set
as an object where the attributes of the object represent the names of the fields found
within the result set. If no more rows exist in the current result set, NULL
is returned.
Returns an object that corresponds to the fetched row or NULL
if there are no more rows in resultset.
Note: 此函数返回的字段名大小写敏感。
Note: 此函数将 NULL 字段设置为 PHP
NULL
值。
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 name, state FROM hotel.city ORDER by zip" ;
if ( $result = $maxdb -> query ( $query )) {
while ( $obj = $result -> fetch_object ()) {
printf ( "%s (%s)\n" , $obj -> NAME , $obj -> STATE );
}
$result -> 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 name, state FROM hotel.city ORDER by zip" ;
if ( $result = maxdb_query ( $link , $query )) {
while ( $obj = maxdb_fetch_object ( $result )) {
printf ( "%s (%s)\n" , $obj -> NAME , $obj -> STATE );
}
maxdb_free_result ( $result );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
New York (NY) New York (NY) Long Island (NY) Albany (NY) Washington (DC) Washington (DC) Washington (DC) Silver Spring (MD) Daytona Beach (FL) Deerfield Beach (FL) Clearwater (FL) Cincinnati (OH) Detroit (MI) Rosemont (IL) Chicago (IL) Chicago (IL) New Orleans (LA) Dallas (TX) Los Angeles (CA) Hollywood (CA) Long Beach (CA) Palm Springs (CA) Irvine (CA) Santa Clara (CA) Portland (OR)