How to use nested DB transactions (MySQL 5+, PostgreSQL)

Comparing #6 with #7

Revision #7 was created by Boaz Boaz on Oct 21, 2015, 10:14:42 AM.

probable typo - fixed

Content

Original source code and idea are from: [PHP, PDO & Nested Transactions](http://www.kennynet.co.uk/2008/12/02/php-pdo-nested-transactions/). Tested with: MySQL 5.1.30 + Yii 1.1.8. Problem: Say there is service layer in an application, and one service may use others. Now each service deals will complex business logic will needs to wrap that into transactions.

If there are services A and B here's how it might happen:

```php
class ServiceA {
[...]