ZF2 Mysql rollback commit function

Question

I was wondering if there is a function such as mysql rollback commit available in Zend Framework 2?

I need to insert multiply rows in the same tabel coming from one form submit.

Nick

The answer was also posted here -> http://stackoverflow.com/questions/14228003/zend-2-db-transactions/14259278#14259278 — Diemuzi, Feb 07 '13 at 22:11

score 2 · Answer 1 · answered Feb 07 '13 at 15:52

In ZF2, the beginTransaction(), commit() and rollback() methods are in the ConnectionInterface.

As far as I can see, you probably have to write code something like this:

$dbAdapter->getDriver()->getConnection()->beginTransaction();
. . . 
$dbAdapter->getDriver()->getConnection()->commit();

score 0 · Answer 2 · answered Aug 11 '13 at 10:00

0

This cannot be used to update two tables in the same transaction.

answered Aug 11 '13 at 10:00

Nisal Gunawardana

2 Answers2