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

}