Zend Framework2 - DB事务处理

 

$this->adapter->getDriver()->getConnection()->beginTransaction();   //Start Transaction

 

try

{

  //SET QUERY EXECUTE

  //...

  $this->adapter->getDriver()->getConnection()->commit();   //COMMIT QUERY TO DATABASE

}

catch(Exception $e)

{

  $this->adapter->getDriver()->getConnection()->rollback();  //Auto ROLLBACK IF TRANSACTION FAILS

 

  $message = $e->getMessage();

  $code = $e->getCode(); 

  //GET ERROR INFORMATION IF SQL FAILS

}