cvs: phpdoc /en/reference/pdo reference.xml /en/reference/pdo/functions PDO-rollBack.xml

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>