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 vote217 views1 answer
Laravel model refresh
PHP
0 vote328 views3 answers
Count with left join in laravel
PHP Laravel
0 vote299 views2 answers
Wp revisions config
PHP Wordpress
3 votes295 views3 answers
Laravel sort by function'
PHP Laravel
1 vote273 views1 answer
Calling itself a static function in php
PHP
0 vote263 views1 answer
Laravel price database
PHP
0 vote273 views1 answer
Wordpress global variable not working
PHP
20 votes319 views6 answers
Object to array in php
PHP
1 vote272 views1 answer
Php get hdd serial number
PHP
3 votes307 views1 answer
Laravel carbon get year number
PHP Laravel