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 vote168 views1 answer
Laravel recursive relationships
PHP Laravel
0 vote146 views1 answer
Php mysql foreach is bad pardics ?
PHP
7 votes170 views2 answers
Laravel how to check if there are record exists
PHP Laravel
0 vote150 views1 answer
How to wp create post type in wordpress
PHP Wordpress
-1 vote247 views2 answers
Restart php service windows
PHP
8 votes124 views1 answer
How to migrate single table in laravel
PHP
7 votes171 views3 answers
Parsefloat php
PHP
1 vote147 views1 answer
Get DAYS absent from working days from given date range
PHP
0 vote164 views1 answer
Builder Pattern Method Chaining 2
PHP
11 votes214 views5 answers
GroupBy Count
PHP