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 vote312 views1 answer
Unique key value array php
PHP
0 vote412 views1 answer
Laravel count without pagination
PHP Laravel
1 vote423 views1 answer
Boot method laravel life cycle
PHP Laravel
0 vote310 views1 answer
How to get a list of registered route paths in Laravel?
PHP
0 vote309 views1 answer
Get slogan wp
PHP
0 vote340 views1 answer
Php get the two number of time second
PHP
-1 vote318 views1 answer
How to replace double quotes in a string in php
PHP
0 vote328 views1 answer
Laravel cmd add to column
PHP
8 votes353 views6 answers
Define table name in model laravel
PHP
1 vote353 views5 answers
Laravel eloquent batch insert
PHP Laravel