Transaction management in PHP - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start a transaction in PHP PDO.

PHP

<?php
$pdo->[1]();
?>

Drag options to blanks, or click blank then click option'

Acommit

BbeginTransaction

Crollback

Dexecute

Attempts:

3 left

💡 Hint

Common Mistakes

Using commit() instead of beginTransaction() to start a transaction.

Using rollback() to start a transaction.

The beginTransaction() method starts a new transaction.

2fill in blank

medium

Complete the code to commit a transaction in PHP PDO.

PHP

<?php
$pdo->[1]();
?>

Drag options to blanks, or click blank then click option'

Acommit

BbeginTransaction

Crollback

Dprepare

Attempts:

3 left

💡 Hint

Common Mistakes

Using rollback() instead of commit() to save changes.

Using beginTransaction() instead of commit() here.

The commit() method saves all changes made during the transaction.

3fill in blank

hard

Fix the error in the code to rollback a transaction in PHP PDO.

PHP

<?php
$pdo->[1]();
?>

Drag options to blanks, or click blank then click option'

Arollback

Bcommit

CbeginTransaction

Dexecute

Attempts:

3 left

💡 Hint

Common Mistakes

Using commit() instead of rollback() to cancel changes.

Using beginTransaction() instead of rollback() here.

The rollback() method cancels all changes made during the transaction.

4fill in blank

hard

Fill both blanks to correctly handle a transaction with error catching.

PHP

<?php
try {
    $pdo->[1]();
    // some database operations
    $pdo->[2]();
} catch (Exception $e) {
    $pdo->rollback();
}
?>

Drag options to blanks, or click blank then click option'

AbeginTransaction

Bcommit

Crollback

Dprepare

Attempts:

3 left

💡 Hint

Common Mistakes

Using rollback() to save changes.

Not starting the transaction before committing.

Start the transaction with beginTransaction() and save changes with commit(). If an error occurs, rollback cancels changes.

5fill in blank

hard

Fill all three blanks to handle a transaction with error catching and rollback.

PHP

<?php
try {
    $pdo->[1]();
    $stmt = $pdo->[2]("INSERT INTO users (name) VALUES ('John')");
    $stmt->execute();
    $pdo->[3]();
} catch (Exception $e) {
    $pdo->rollback();
}
?>

Drag options to blanks, or click blank then click option'

AbeginTransaction

Bprepare

Ccommit

Dexecute

Attempts:

3 left

💡 Hint

Common Mistakes

Using execute() instead of prepare() for the statement.

Committing before executing the statement.

Not starting the transaction before preparing.

Start the transaction with beginTransaction(), prepare the SQL statement with prepare(), and commit changes with commit(). If an error occurs, rollback cancels changes.