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 vote437 views1 answer
Update php version in laravel
PHP Laravel
0 vote411 views2 answers
Codeigniter 4 delete redirect with data
PHP CodeIgniter
18 votes331 views2 answers
Json stringify php decode
PHP
5 votes361 views2 answers
Laravel 5 use env variable in blade
PHP Laravel
13 votes331 views3 answers
Laravel password encryption
PHP
0 vote430 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
0 vote345 views1 answer
Cara looping abjad with array
PHP
1 vote362 views1 answer
Hex to dec php
PHP
5 votes392 views4 answers
Update column type laravel migration
PHP
10 votes367 views2 answers
Create folder php
PHP