| Dan Scott 2004-11-26, 4:01 am |
| dbs Thu Nov 25 22:15:40 2004 EDT
Modified files:
/phpdoc/en/reference/pdo/functions PDOStatement-errorCode.xml
Log:
Add an example.
http://cvs.php.net/diff.php/phpdoc/...1.1&r2=1.2&ty=u
Index: phpdoc/en/reference/pdo/functions/PDOStatement-errorCode.xml
diff -u phpdoc/en/reference/pdo/functions/PDOStatement-errorCode.xml:1.1 phpdoc/en/reference/pdo/functions/PDOStatement-errorCode.xml:1.2
--- phpdoc/en/reference/pdo/functions/PDOStatement-errorCode.xml:1.1 Wed Nov 10 17:21:23 2004
+++ phpdoc/en/reference/pdo/functions/PDOStatement-errorCode.xml Thu Nov 25 22:15:40 2004
@@ -1,5 +1,5 @@
<?xml version='1.0' encoding='iso-8859-1'?>
-<!-- $Revision: 1.1 $ -->
+<!-- $Revision: 1.2 $ -->
<!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. -->
<refentry id="function.PDOStatement-errorCode">
<refnamediv>
@@ -14,9 +14,64 @@
<type>int</type><methodname>PDOStatement::errorCode</methodname>
<void/>
</methodsynopsis>
+ &warn.experimental.func;
- &warn.undocumented.func;
+ <para>
+ Returns an integer value that maps to the error categories defined
+ in the PDO constants.
+ </para>
+ <example><title>Determining which category of error occurred</title>
+ <programlisting role="php">
+<![CDATA[
+<?php
+/* Provoke an error -- the BONES table does not exist */
+$err = $dbh->prepare('SELECT skull FROM bones');
+$err->execute();
+echo "\nPDOStatement::errorCode(): ";
+switch ($err->errorCode()) {
+ case PDO_ERR_NONE:
+ echo "No error!\n";
+ break;
+ case PDO_ERR_CANT_MAP:
+ echo "Error: Unable to map data types between database and PHP.\n";
+ break;
+ case PDO_ERR_SYNTAX:
+ echo "Error: incorrect syntax\n";
+ break;
+ case PDO_ERR_CONSTRAINT:
+ echo "Error: The request would violate a constraint.\n";
+ break;
+ case PDO_ERR_NOT_FOUND:
+ echo "Error: The object could not be found.\n";
+ break;
+ case PDO_ERR_ALREADY_EXISTS:
+ echo "Error: The object already exists.\n";
+ break;
+ case PDO_ERR_NOT_IMPLEMENTED:
+ echo "Error: The requested function is not implemented.\n";
+ break;
+ case PDO_ERR_MISMATCH:
+ echo "Error: mismatch\n";
+ break;
+ case PDO_ERR_TRUNCATED:
+ echo "Error: The value was truncated because the input value was longer
+ than the maximum column length.\n";
+ break;
+ case PDO_ERR_DISCONNECTED:
+ echo "Error: The connection to the requested database has been closed.\n";
+ break;
+}
+?>
+]]>
+ </programlisting>
+ </example>
+ &example.outputs;
+ <screen>
+<![CDATA[
+PDOStatement::errorCode(): Error: The object could not be found.
+]]>
+ </screen>
</refsect1>
</refentry>
|