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 vote272 views1 answer
Fibers - PHP 8.1
PHP
0 vote280 views1 answer
Wp query meta in array
PHP
1 vote284 views2 answers
Laravel ckeditor
PHP
15 votes301 views2 answers
Error: Cannot find module 'webpack/lib/rules/DescriptionDataMatcherRulePlugin
PHP
0 vote374 views1 answer
Connect another database in wordpress
PHP Wordpress
0 vote280 views3 answers
Slick slider and ACF Pro in WordPress
PHP
0 vote377 views1 answer
Set owner symfony
PHP Symfony
0 vote274 views1 answer
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
PHP
8 votes298 views6 answers
Laravel command not found
PHP Laravel
0 vote316 views1 answer
Insert chevron on form select field on caldera
PHP