Harry Fuecks have written an excellent article about Performing Transactions with Oracle and PHP. The article cover many topics from the need for transactions, ACID Transactions, Oracle Transactions with PHP, and Transaction Isolation and Connections.
Transactions allow you to make changes to your database reliably and consistently and are critical if your application has to manage many-to-many relationships or execute multiple queries as a batch.
This “Oracle+PHP Cookbook” HowTo explains the need for transactions and examines how to use Oracle’s transaction services through PHP’s OCI extension, highlighting some of the potential “gotchas” along the way.
If you didn’t already, by reading this article you should now understand the need for transactions, allowing you to make changes to the database reliably and consistently. You should also understand how to execute transactions via PHP’s OCI extension—bearing in mind potential issues with its default autocommit behavior—as well as how execute queries in separate transaction contexts.
