maxdb_info

maxdb::info

(PECL maxdb >= 1.0)

maxdb_info -- maxdb::info — Retrieves information about the most recently executed query

说明

过程化风格

maxdb_info ( resource $link ) : string

面向对象风格

string $maxdb->info;

The maxdb_info() function returns a string providing information about the last query executed. The nature of this string is provided below:

Possible maxdb_info return values
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");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

$maxdb->query("CREATE TABLE temp.t1 LIKE hotel.city");

/* INSERT INTO .. SELECT */
$maxdb->query("INSERT INTO temp.t1 SELECT * FROM hotel.city");
printf("%s\n", $maxdb->info);

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
if (maxdb_connect_errno()) {
   printf("Connect failed: %s\n", maxdb_connect_error());
   exit();
}

maxdb_query($link, "CREATE TABLE temp.t1 LIKE hotel.city");

/* INSERT INTO .. SELECT */
maxdb_query($link, "INSERT INTO temp.t1 SELECT * FROM hotel.city");
printf("%s\n", maxdb_info($link));

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于：

Records: 25 Duplicates: 0 Warnings: 0

参见

相关文章
php gnupg 函数 returns an array with information about all keys that matches the given patternphp firebird/interbase 函数 return information about a parameter in a prepared queryphp maxdb 函数 returns the number of columns for the most recent queryphp maxdb 函数 retrieves information about the most recently executed queryphp maxdb 函数 returns the auto generated id used in the last queryphp odbc 函数 retrieves information about data types supported by the data sourcephp pdf 函数 query detailed information about a loaded fontphp paradox 函数 return lots of information about a paradox filephp rrd 函数 gets information about underlying rrdtool libraryphp wincache 函数 retrieves information about files cached in the file cachephp wincache 函数 retrieves information about file cache memory usagephp wincache 函数 retrieves information about files cached in the opcode cachephp wincache 函数 retrieves information about opcode cache memory usagephp wincache 函数 retrieves information about resolve file path cachephp wincache 函数 retrieves information about memory usage by the resolve file path cachephp wincache 函数 retrieves information about files cached in the session cachephp wincache 函数 retrieves information about session cache memory usagephp wincache 函数 retrieves information about data stored in the user cachephp wincache 函数 retrieves information about user cache memory usagephp mysqlnduhconnection retrieves information about the most recently executed query
关注编程学问公众号