xref: /PHP-5.5/ext/pdo/README (revision 3b857ea9)
1$Id$
2
3PHP Data Objects
4================
5
6Concept: Data Access Abstraction
7
8Goals:
9
101/  Be light-weight
112/  Provide common API for common database operations
123/  Be performant
134/  Keep majority of PHP specific stuff in the PDO core (such as persistent
14    resource management); drivers should only have to worry about getting the
15    data and not about PHP internals.
16
17
18Transactions and autocommit
19===========================
20
21When you create a database handle, you *should* specify the autocommit
22behaviour that you require.  PDO will default to autocommit on.
23
24$dbh = new PDO("...", $user, $pass, array(PDO_ATTR_AUTOCOMMIT => true));
25
26When auto-commit is on, the driver will implicitly commit each query as it is
27executed.  This works fine for most simple tasks but can be significantly
28slower when you are making a large number of udpates.
29
30$dbh = new PDO("...", $user, $pass, array(PDO_ATTR_AUTOCOMMIT => false));
31
32When auto-commit is off, you must then use $dbh->beginTransaction() to
33initiate a transaction.  When your work is done, you then call $dbh->commit()
34or $dbh->rollBack() to persist or abort your changes respectively.  Not all
35databases support transactions.
36
37You can change the auto-commit mode at run-time:
38
39$dbh->setAttribute(PDO_ATTR_AUTOCOMMIT, false);
40
41Regardless of the error handling mode set on the database handle, if the
42autocommit mode cannot be changed, an exception will be thrown.
43
44Some drivers will allow you to temporarily disable autocommit if you call
45$dbh->beginTransaction().  When you commit() or rollBack() such a transaction,
46the handle will switch back to autocommit mode again.  If the mode could not
47be changed, an exception will be raised, as noted above.
48
49When the database handle is closed or destroyed (or at request end for
50persistent handles), the driver will implicitly rollBack().  It is your
51responsibility to call commit() when you are done making changes and
52autocommit is turned off.
53
54vim:tw=78:et
55
56
57