©
本文檔使用 php中文網手册 發布
(PECL maxdb >= 1.0)
maxdb_info -- maxdb::info — Retrieves information about the most recently executed query
过程化风格
$link
)面向对象风格
The maxdb_info() function returns a string providing information about the last query executed. The nature of this string is provided below:
Query type | Example result string |
---|---|
INSERT INTO...SELECT... | Records: 100 Duplicates: 0 Warnings: 0 |
INSERT INTO...VALUES (...),(...),(...) | Records: 3 Duplicates: 0 Warnings: 0 |
LOAD DATA INFILE ... | Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 |
ALTER TABLE ... | Records: 3 Duplicates: 0 Warnings: 0 |
UPDATE ... | Rows matched: 40 Changed: 40 Warnings: 0 |
Note:
Queries which do not fall into one of the above formats are not supported. In these situations, maxdb_info() will return an empty string.
A character string representing additional information about the most recently executed query.
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$maxdb -> query ( "CREATE TABLE temp.t1 LIKE hotel.city" );
$maxdb -> query ( "INSERT INTO temp.t1 SELECT * FROM hotel.city" );
printf ( "%s\n" , $maxdb -> info );
$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();
}
maxdb_query ( $link , "CREATE TABLE temp.t1 LIKE hotel.city" );
maxdb_query ( $link , "INSERT INTO temp.t1 SELECT * FROM hotel.city" );
printf ( "%s\n" , maxdb_info ( $link ));
maxdb_close ( $link );
?>
以上例程的输出类似于:
Records: 25 Duplicates: 0 Warnings: 0