©
本文檔使用 php中文網手册 發布
(PECL maxdb >= 1.0)
maxdb_multi_query -- maxdb::multi_query — Performs a query on the database
过程化风格
$link
, string $query
)面向对象风格
$query
)The maxdb_multi_query() works like the function maxdb_query() . Multiple queries are not yet supported.
成功时返回 TRUE
, 或者在失败时返回 FALSE
。
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 * FROM dual" ;
if ( $maxdb -> multi_query ( $query )) {
do {
if ( $result = $maxdb -> store_result ()) {
while ( $row = $result -> fetch_row ()) {
printf ( "%s\n" , $row [ 0 ]);
}
$result -> close ();
}
if ( $maxdb -> more_results ()) {
printf ( "-----------------\n" );
}
} while ( $maxdb -> next_result ());
}
$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 * FROM dual" ;
if ( maxdb_multi_query ( $link , $query )) {
do {
if ( $result = maxdb_store_result ( $link )) {
while ( $row = maxdb_fetch_row ( $result )) {
printf ( "%s\n" , $row [ 0 ]);
}
maxdb_free_result ( $result );
}
if ( maxdb_more_results ( $link )) {
printf ( "-----------------\n" );
}
} while ( maxdb_next_result ( $link ));
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
a