4 More Discussions You Might Find Interesting
1. What is on Your Mind?
A Tribute to India
For our Indian members, please let us know in the poll what city you live (or work)?
Mumbai (Bombay)
Delhi
Kolkata (Calcutta)
Chennai (Madras)
Bangalore
Hyderabad
Pune
Ahmedabad
Kanpur
Surat
Other (Please Tell Us in Post and Write in Poll, Thanks!)
Don't Live in... (32 Replies)
Discussion started by: Neo
32 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have a file abc.dat. It contains the fileds of empid, empname, empcity. each city contains 10 records. i want to create the city file and pass the same city records into the file. I don't know the city names.
In unix using awk command how can we do?
abc.dat:
1 john delhi
2... (2 Replies)
Discussion started by: raghukreddy.ab
2 Replies
3. What is on Your Mind?
hi guys: i am live in Changsha China , i am study here . which city do you live? (1 Reply)
Discussion started by: kingdream
1 Replies
4. Solaris
Hi everyone,
I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies
LEARN ABOUT PHP
maxdb_info
MAXDB_INFO(3) 1 MAXDB_INFO(3)
maxdb_info - Retrieves information about the most recently executed query
Procedural style
SYNOPSIS
string maxdb_info (resource $link)
DESCRIPTION
Object oriented style
string$maxdb->info ()
The maxdb_info(3) 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(3) will return an empty
string.
RETURN VALUES
A character string representing additional information about the most recently executed query.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", 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
", $maxdb->info);
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", 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
", maxdb_info($link));
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
Records: 25 Duplicates: 0 Warnings: 0
SEE ALSO
maxdb_affected_rows(3), maxdb_warning_count(3), maxdb_num_rows(3).
PHP Documentation Group MAXDB_INFO(3)