|
 |
maxdb_stmt_errno (PECL) maxdb_stmt_errno (no version information, might be only in CVS) maxdb_stmt->errno -- Returns the error code for the most recent statement call DescriptionProcedural style : int maxdb_stmt_errno ( resource stmt ) Object oriented style (property): class stmt { int errno }
For the statement specified by stmt, maxdb_stmt_errno()
returns the error code for the most recently invoked statement function that can succeed or fail.
Return values
An error code value. Zero means no error occurred.
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();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
$maxdb->query("INSERT INTO temp.mycity SELECT * FROM hotel.city");
$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
if ($stmt = $maxdb->prepare($query)) {
$maxdb->query("DROP TABLE temp.mycity");
$stmt->execute();
printf("Error: %d.\n", $stmt->errno);
$stmt->close();
}
$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();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
maxdb_query($link, "INSERT INTO temp.mycity SELECT * FROM hotel.city");
$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
if ($stmt = maxdb_prepare($link, $query)) {
maxdb_query($link, "DROP TABLE temp.mycity");
maxdb_stmt_execute($stmt);
printf("Error: %d.\n", maxdb_stmt_errno($stmt));
maxdb_stmt_close($stmt);
}
maxdb_close($link);
?>
|
|
The above examples would produce the following output:
Warning: maxdb_stmt_execute(): -4004 POS(23) Unknown table name:MYCITY [42000] <...>
Error: -4004. |
maxdb_stmt_errno
There are no user contributed notes for this page.
| |