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 vote337 views1 answer
How to get create table query preview in phpmyadmin
PHP
0 vote435 views1 answer
Warning: sprintf(): Too few arguments in /opt/lampp/htdocs/wordpress/wp-admin/includes/class-bulk-upgrader-skin.php on line 152
PHP Wordpress
2 votes301 views1 answer
Call to undefined function database seeders factory() laravel 8
PHP
2 votes364 views5 answers
Ubuntu install php
PHP
4 votes347 views2 answers
Datetime blade laravel
PHP Laravel
1 vote329 views2 answers
Php start session if not started
PHP
0 vote430 views1 answer
Laravel valet refresh env
PHP Laravel
0 vote334 views1 answer
Laravel model relationships with two columns match
PHP
0 vote405 views1 answer
Jwt auth laravel auth without password field
PHP Laravel
0 vote370 views1 answer
Import local js file laravel
PHP Laravel