©
This document uses PHP Chinese website manual Release
(PHP 5)
mysqli::$info -- mysqli_info — Retrieves information about the most recently executed query
面向对象风格
过程化风格
$link
)The mysqli_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 preceding formats are not supported. In these situations, mysqli_info() will return an empty string.
link
仅以过程化样式:由 mysqli_connect() 或 mysqli_init() 返回的链接标识。
A character string representing additional information about the most recently executed query.
Example #1 $mysqli->info example
面向对象风格
<?php
$mysqli = new mysqli ( "localhost" , "my_user" , "my_password" , "world" );
if ( mysqli_connect_errno ()) {
printf ( "Connect failed: %s\n" , mysqli_connect_error ());
exit();
}
$mysqli -> query ( "CREATE TEMPORARY TABLE t1 LIKE City" );
$mysqli -> query ( "INSERT INTO t1 SELECT * FROM City ORDER BY ID LIMIT 150" );
printf ( "%s\n" , $mysqli -> info );
$mysqli -> close ();
?>
过程化风格
<?php
$link = mysqli_connect ( "localhost" , "my_user" , "my_password" , "world" );
if ( mysqli_connect_errno ()) {
printf ( "Connect failed: %s\n" , mysqli_connect_error ());
exit();
}
mysqli_query ( $link , "CREATE TEMPORARY TABLE t1 LIKE City" );
mysqli_query ( $link , "INSERT INTO t1 SELECT * FROM City ORDER BY ID LIMIT 150" );
printf ( "%s\n" , mysqli_info ( $link ));
mysqli_close ( $link );
?>
以上例程会输出:
Records: 150 Duplicates: 0 Warnings: 0
[#1] user at biglake dot com [2010-12-14 18:43:47]
Might save someone some time...
<?php
$prototype='Rows matched: 0 Changed: 1 Warnings: 2';
list($matched, $changed, $warnings) = sscanf($prototype, "Rows matched: %d Changed: %d Warnings: %d");
?>