11111

maxdb_info

Пред.

След.

maxdb_info

(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 typeExample 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

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

?>

- The above examples would produce the following output:

Records: 25 Duplicates: 0 Warnings: 0

Пред.

Начало

След.

maxdb_get_server_version

Уровень выше

maxdb_init 22222

Free Web Hosting