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

24 votes142 views4 answers
Clear cache command in laravel controller
PHP
0 vote68 views1 answer
Php header accept post request from same domain
PHP
0 vote167 views1 answer
Laravel app running in console
PHP Laravel
11 votes104 views1 answer
Php mysql datetime
PHP
12 votes147 views2 answers
Phpmyadmin add foreign key
PHP
0 vote155 views1 answer
Laravel nova field required
PHP Laravel
3 votes197 views2 answers
How to truncate the given string to the specified length in blade.php
PHP
0 vote85 views1 answer
SSL PHP CURL
PHP
0 vote166 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter
48 votes88 views3 answers
Php cli display errors
PHP