// establish a PDO connection $pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'myusername', 'mypassword'); // start a new transaction $pdo->beginTransaction(); // perform some database operations $pdo->query("INSERT INTO users (name, email, password) VALUES ('John Doe', 'john.doe@example.com', 'mypassword')"); $pdo->query("INSERT INTO orders (user_id, total) VALUES (1, 100.00)"); // commit the transaction $pdo->commit();
// establish a PDO connection $pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'myusername', 'mypassword'); // start a new transaction $pdo->beginTransaction(); try { // perform some database operations $pdo->query("INSERT INTO users (name, email, password) VALUES ('John Doe', 'john.doe@example.com', 'mypassword')"); $pdo->query("INSERT INTO orders (user_id, total) VALUES (1, 100.00)"); // intentionally trigger an error $pdo->query("INSERT INTO nonexistent_table (foo, bar) VALUES (1, 'hello')"); } catch (Exception $e) { // something went wrong, rollback the transaction $pdo->rollback(); } // no changes were saved to the databaseThis example demonstrates how to use PDO inTransaction to handle transaction failures. If an exception is thrown within the try block, the transaction is rolled back and no changes are saved to the database. Overall, PDO is a package library used for connecting to databases and performing operations using PHP. It provides a simple interface and supports a wide range of databases.