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

1 vote157 views2 answers
Wordpress programmatically logout
PHP
0 vote161 views1 answer
Function to fetch user details
PHP
0 vote176 views2 answers
Script inside php
PHP
0 vote135 views1 answer
Larvel check two password
PHP
0 vote151 views2 answers
How make custom menu in wordpress
PHP Wordpress
0 vote144 views2 answers
Warning: mysqli_fetch_all() expects parameter 1 to be mysqli_result, bool given in C:\newxammp\htdocs\learn\index.php on line 11
PHP
-1 vote131 views2 answers
Laravel model save get id
PHP
0 vote124 views1 answer
Twig\Error\SyntaxError: Unknown "file_uri" function. Did you mean "file_url"?
PHP
2 votes143 views6 answers
Composer create project laravel 7
PHP Laravel
0 vote140 views1 answer
Laravel check if api request
PHP