gzencode php demo,maxdb_info - PHP 5 中文文档

(PECL)

maxdb_info

(no version information, might be only in CVS)

maxdb->info–Retrieves information about the most recently executed query

Description

Procedural style:

string maxdb_info

( resource link )

Object oriented style (property)

class maxdb

{

string info

}

The maxdb_info()

function returns a string providing

information about the last query executed. The nature of this string is

provided below:

表格 1. 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

注:

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.

参见

maxdb_affected_rows()

,

maxdb_warning_count()

,

maxdb_num_rows()

Example

例子 1. Object oriented style

<?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();?>

例子 2. Procedural style

The above examples would produce the following output:

Records: 25 Duplicates: 0 Warnings: 0