php db transaction

아~ 얼른 적용해야겠다.

트랜잭션 코드 적용하고 예외처리하고 로그도 쌓고

안정화모드에 들어가야 한다.

아래는 db transaction 샘플이다.

try {
    // First of all, let's begin a transaction
    $db->beginTransaction();

    // A set of queries; if one fails, an exception should be thrown
    $db->query('first query');
    $db->query('second query');
    $db->query('third query');

    // If we arrive here, it means that no exception was thrown
    // i.e. no query has failed, and we can commit the transaction
    $db->commit();
} catch (Exception $e) {
    // An exception has been thrown
    // We must rollback the transaction
    $db->rollback(); 

}