Search Results

1. www.php.net › manual › enPHP: PDO::beginTransaction - Manual

   www.php.net › manual › en

   Calling PDO::rollBack () will roll back all changes to the database and return the connection to autocommit mode. Some databases, including MySQL, automatically issue an implicit COMMIT when a database definition language (DDL) statement such as DROP TABLE or CREATE TABLE is issued within a transaction.

   • Query

     PDO::query () prepares and executes an SQL statement in a...

   • PDOException

     Here is something interesting regarding a PDOException and...

   • Construct

     Creates a PDO instance representing a connection to a...

   • getAttribute

     This function returns the value of a database connection...

   • Transactions and Auto-Commit

     Transactions and auto-commit ¶ Now that you're connected via...

2. zetcode.com › php-pdo › begintransaction-methodPHP PDO::beginTransaction Method: Starting Transactions - ZetCode

   zetcode.com › php-pdo › begintransaction-method

   Apr 19, 2025 · Learn how to use the PHP PDO::beginTransaction method to start SQL transactions for reliable data processing.

3. www.phptutorial.net › php-pdo › php-pdo-transactionHow to Perform a Database Transaction from PHP using PDO

   www.phptutorial.net › php-pdo › php-pdo-transaction

   • Introduction to Php PDO Transaction
   • PDO Transaction Example
   • Summary

   To start a transaction in PDO, you use the PDO::beginTransaction()method: The beginTransaction() method turns off the autocommit mode. It means that the changes made to the database via the PDO object won’t take effect until you call the PDO::commit()method. To commit a transaction, you call the PDO::commit()method: If you want to roll back the tra...

   See full list on phptutorial.net

   Suppose that you need to insert data into three tables: books, authors, and book_authors. To do that, you need to: 1. Get the author id if the author exists; otherwise, insert the author into the authorstable. 2. Insert the book into the bookstable. 3. Insert the link between book and author into the book_authorstable. To organize the code, we’ll p...

   See full list on phptutorial.net

   Use the PDO::beginTransaction()method to start a new transaction.

   Use the PDO::commit() method to commit a transaction and PDO::rollback()to roll back a transaction.

   See full list on phptutorial.net

4. learn.microsoft.com › en-us › sqlPDO::beginTransaction - PHP drivers for SQL Server

   learn.microsoft.com › en-us › sql

   Jun 25, 2024 · API reference for the PDO::beginTransaction function in the Microsoft PDO_SQLSRV Driver for PHP for SQL Server.

5. www.basicexamples.com › php › pdo-begintransactionBasic example of PHP function PDO::beginTransaction ()

   www.basicexamples.com › php › pdo-begintransaction

   Simple usage example of `PDO::beginTransaction ()`. PDO::beginTransaction is a PHP function used to initiate a transaction in a PDO (PHP Data Objects) database connection. Transactions are used to group multiple database operations into a single atomic unit, meaning they either all succeed or all fail. This function allows you to start a transaction and perform multiple related database ...

6. neon.com › postgresql › postgresql-phpPostgreSQL PHP: Transaction - neon.com

   neon.com › postgresql › postgresql-php

   Summary Use the beginTransaction () method of the PDO object to start a transaction. Use the commit() method to apply the changes to the database and rollback() method to undo the changes.

7. People also ask

   How do I start a transaction in PDO?

   • To start a transaction in PDO, you use the PDO::beginTransaction() method: The beginTransaction() method turns off the autocommit mode. It means that the changes made to the database via the PDO object won’t take effect until you call the PDO::commit() method. To commit a transaction, you call the PDO::commit() method:

   How to Perform a Database Transaction from PHP using PDO

   www.phptutorial.net/php-pdo/php-pdo-transaction/

   See all results for this question

   How to use a transaction in PHP PDO?

   • The typical usage of the transaction in PHP PDO is as follows: We’ll create the following tables for the demonstration: plans: stores the plan information for the account such as silver, gold, and platinum. account_plans : stores the plan for each account with the effective date.

   PostgreSQL PHP: Transaction - neon.com

   neon.com/postgresql/postgresql-php/transaction

   See all results for this question

   How to roll back a transaction using PDO?

   • $pdo->rollBack(); // show the error message die($e->getMessage()); Use the PDO::beginTransaction() method to start a new transaction. Use the PDO::commit() method to commit a transaction and PDO::rollback() to roll back a transaction.

   How to Perform a Database Transaction from PHP using PDO

   www.phptutorial.net/php-pdo/php-pdo-transaction/

   See all results for this question

   Why do I need a transaction in PDO?

   • In other words, transactions can make your scripts faster and potentially more robust (you still need to use them correctly to reap that benefit). Unfortunately, not every database supports transactions, so PDO needs to run in what is known as "auto-commit" mode when you first open the connection.

   PHP: Transactions and auto-commit - Manual

   www.php.net/manual/en/pdo.transactions.php

   See all results for this question

8. www.php.net › manual › enPHP: Transactions and auto-commit - Manual

   www.php.net › manual › en

   Transactions and auto-commit ¶ Now that you're connected via PDO, you must understand how PDO manages transactions before you start issuing queries. If you've never encountered transactions before, they offer 4 major features: Atomicity, Consistency, Isolation and Durability (ACID). In layman's terms, any work carried out in a transaction, even if it is carried out in stages, is guaranteed to ...