Interview question

How do you handle transactions in PDO? PDO में transactions कैसे handle करें?

Answer

Transactions ensure a group of database operations either all succeed or all fail together, maintaining data consistency.

try {
    $pdo->beginTransaction();
    $pdo->prepare('UPDATE accounts SET balance = balance - ? WHERE id = ?')
        ->execute([100, $fromId]);
    $pdo->prepare('UPDATE accounts SET balance = balance + ? WHERE id = ?')
        ->execute([100, $toId]);
    $pdo->commit();
} catch (Exception $e) {
    $pdo->rollBack();
    throw $e;
}

Method	Purpose
beginTransaction()	Starts a transaction
commit()	Saves all changes permanently
rollBack()	Undoes all changes since begin

Transactions यह सुनिश्चित करते हैं कि database operations का समूह या तो सब सफल हों या सब fail हों।

try {
    $pdo->beginTransaction();
    $pdo->prepare('UPDATE accounts SET balance = balance - ? WHERE id = ?')
        ->execute([100, $fromId]);
    $pdo->prepare('UPDATE accounts SET balance = balance + ? WHERE id = ?')
        ->execute([100, $toId]);
    $pdo->commit();
} catch (Exception $e) {
    $pdo->rollBack();
    throw $e;
}

Method	उद्देश्य
beginTransaction()	Transaction शुरू करता है
commit()	Changes permanently save करता है
rollBack()	Changes undo करता है

Was this answer clear?

Subjects

Related questions