[PHP-DOC] cvs: phpdoc /en/reference/pdo reference.xml /en/reference/pdo/functions PDO-rollBack.xml

[Dan Scott]

dbs             Fri Nov 19 10:55:49 2004 EDT

  Modified files:              
    /phpdoc/en/reference/pdo    reference.xml 
    /phpdoc/en/reference/pdo/functions  PDO-rollBack.xml 
  Log:
  Correct Windows DLL names, add rollBack stub
  
http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/reference.xml?r1=1.8&r2=1.9&ty=u
Index: phpdoc/en/reference/pdo/reference.xml
diff -u phpdoc/en/reference/pdo/reference.xml:1.8 
phpdoc/en/reference/pdo/reference.xml:1.9
--- phpdoc/en/reference/pdo/reference.xml:1.8   Tue Nov 16 15:12:45 2004
+++ phpdoc/en/reference/pdo/reference.xml       Fri Nov 19 10:55:48 2004
@@ -1,5 +1,5 @@
 <?xml version='1.0' encoding='iso-8859-1'?>
-<!-- $Revision: 1.8 $ -->
+<!-- $Revision: 1.9 $ -->
 <!-- Generated by xml_proto.php v2.1. Found in /scripts directory of phpdoc. 
-->
  <reference id="ref.pdo">
   <title>PDO Functions</title>
@@ -38,13 +38,14 @@
      </screen>
     </para>
     <para>
-     Windows users can download the extension DLL <filename>pdo.dll</filename>
-     from <ulink url='&url.pecl.get.win;'>&url.pecl.get.win;</ulink>
+     Windows users can download the extension DLL 
<filename>php_pdo.dll</filename>
+     as part of the PECL collection binaries from
+     <ulink url='&url.php.downloads;'>&url.php.downloads;</ulink>.
     </para>
     <para>
      The <command>pear</command> command automatically installs the
      PDO module into your PHP extensions directory. To enable the
-     PDO extension on UNIX or Linux operating systems, you must add
+     PDO extension on Linux or UNIX operating systems, you must add
      the following line to &php.ini;:
      <screen>
 <![CDATA[
@@ -55,7 +56,7 @@
      add the following line to &php.ini;:
      <screen>
 <![CDATA[
-extension=pdo.dll
+extension=php_pdo.dll
 ]]>
      </screen>
     </para>
http://cvs.php.net/diff.php/phpdoc/en/reference/pdo/functions/PDO-rollBack.xml?r1=1.1&r2=1.2&ty=u
Index: phpdoc/en/reference/pdo/functions/PDO-rollBack.xml
diff -u phpdoc/en/reference/pdo/functions/PDO-rollBack.xml:1.1 
phpdoc/en/reference/pdo/functions/PDO-rollBack.xml:1.2
--- phpdoc/en/reference/pdo/functions/PDO-rollBack.xml:1.1      Wed Nov 10 
17:21:22 2004
+++ phpdoc/en/reference/pdo/functions/PDO-rollBack.xml  Fri Nov 19 10:55:49 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.PDO-rollBack">
    <refnamediv>
@@ -17,8 +17,35 @@
 
     &warn.experimental.func;
     <para>
-     Rolls back a transaction, returning the connection state to autocommit 
mode.
+     When issued against databases that support transactions,
+     <function>PDO::rollBack</function> rolls back any work in progress and
+     and returns the connection state to autocommit mode.
     </para>
+    <para>
+     You must issue <function>PDO::beginTransaction</function> to set the
+     connection state to manual commit mode before issuing
+     <function>PDO::rollBack</function> has any effect.
+    </para>
+    <example><title>Roll back a transaction</title>
+     <programlisting role='php'>
+<![CDATA[
+<?php
+/* Begin a transaction, turning off autocommit */
+$dbh->beginTransaction();
+
+/* Change the database schema and data */
+$sth = $dbh->exec("DROP TABLE fruit");
+$sth = $dbh->exec("UPDATE dessert
+    SET name = 'hamburger'");
+
+/* Recognize mistake and roll back changes */
+$sth->rollBack();
+
+/* Database connection is now back in autocommit mode */
+?>
+]]>
+     </programlisting>
+    </example>
 
    </refsect1>
   </refentry>