文字

maxdb_query

maxdb::query

(PECL maxdb >= 1.0)

maxdb_query -- maxdb::queryPerforms a query on the database

说明

过程化风格

mixed maxdb_query ( resource $link , string $query [, int $resultmode ] )

面向对象风格

mixed maxdb::query ( string $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.

参见

  • maxdb_real_query() - Execute an SQL query
  • maxdb_multi_query() - Performs a query on the database
  • maxdb_free_result() - Frees the memory associated with a result
上一篇: 下一篇: