|
|
maxdb_sqlstate (PECL) maxdb_sqlstate (no version information, might be only in CVS) maxdb->sqlstate -- Returns the SQLSTATE error from previous MaxDB operation DescriptionProcedural style: string maxdb_sqlstate ( resource link ) Object oriented style (property): class maxdb { string sqlstate }
Returns a string containing the SQLSTATE error code for the last error.
The error code consists of five characters. '00000' means no error.
The values are specified by ANSI SQL and ODBC.
注:
Note that not all MaxDB errors are yet mapped to SQLSTATE's.
The value HY000 (general error) is used for unmapped errors.
Return values
Returns a string containing the SQLSTATE error code for the last error.
The error code consists of five characters. '00000' means no error.
Example例子 1. Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
if (maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}
if (!$maxdb->query("CREATE TABLE hotel.city (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.\n", $maxdb->sqlstate);
}
$maxdb->close();
?>
|
|
例子 2. Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
if (maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}
if (!maxdb_query($link, "CREATE TABLE hotel.city (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.\n", maxdb_sqlstate($link));
}
maxdb_close($link);
?>
|
|
The above examples would produce the following output:
Warning: maxdb_query(): -6000 POS(20) Duplicate table name:CITY [I6000] <...>
Error - SQLSTATE I6000. |
| |