Pdo transaction

<?php
/* Begin a transaction, turning off autocommit */
$dbh->beginTransaction();

try	{
	/* Change the database schema and data */
    $sth = $dbh->exec("DROP TABLE fruit");
    $sth = $dbh->exec("UPDATE dessert
        SET name = 'hamburger'");
}
catch(Exception $e){
  /* Recognize mistake and roll back changes */
  $dbh->rollBack();
}
/* Commit changes */
$dbh->commit();

Similar codes

0 vote197 views1 answer
Nuxt auth login with laravel passport
PHP
0 vote202 views10 answers
Laravel relations find
PHP
0 vote184 views1 answer
Mysqli fetch row assoc
PHP
1 vote197 views1 answer
Convert any phone number in us number format php
PHP
0 vote280 views1 answer
Doctrine getrepository findby
PHP
1 vote184 views3 answers
Php convert special characters to unicode
PHP
0 vote195 views1 answer
Laravel use variable inside callback function
PHP
0 vote179 views1 answer
Array of dates laravel
PHP
0 vote200 views2 answers
Create file in laravel
PHP
0 vote193 views1 answer
Woocommerce add button to product list
PHP