©
本文檔使用 php中文網手册 發布
(PECL maxdb >= 1.0)
maxdb_query -- maxdb::query — Performs a query on the database
过程化风格
$link
, string $query
[, int $resultmode
] )面向对象风格
$query
)
The maxdb_query() function is used to simplify the
act of performing a query against the database represented by the
link
parameter.
成功时返回 TRUE
, 或者在失败时返回 FALSE
。 For SELECT, SHOW, DESCRIBE or
EXPLAIN maxdb_query() will return
a result resource.
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
if ( $maxdb -> query ( "CREATE TABLE temp.mycity LIKE hotel.city" ) === TRUE ) {
printf ( "Table mycity successfully created.\n" );
}
if ( $result = $maxdb -> query ( "SELECT name FROM hotel.city" )) {
printf ( "Select returned %d rows.\n" , $result -> num_rows );
$result -> close ();
}
if ( $result = $maxdb -> query ( "SELECT * FROM hotel.city" , MAXDB_USE_RESULT )) {
$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();
}
if ( maxdb_query ( $link , "CREATE TABLE temp.mycity LIKE hotel.city" ) === TRUE ) {
printf ( "Table mycity successfully created.\n" );
}
if ( $result = maxdb_query ( $link , "SELECT name FROM hotel.city" )) {
printf ( "Select returned %d rows.\n" , maxdb_num_rows ( $result ));
maxdb_free_result ( $result );
}
if ( $result = maxdb_query ( $link , "SELECT * FROM hotel.city" , MAXDB_USE_RESULT )) {
maxdb_free_result ( $result );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
Table mycity successfully created. Select returned 25 rows.