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 vote262 views1 answer
WithErrors laravel
PHP
4 votes293 views4 answers
Php artisan drop table
PHP
1 vote299 views3 answers
Download file php
PHP
2 votes289 views2 answers
Add two numbers in php
PHP
25 votes291 views3 answers
Php refresh
PHP
4 votes389 views2 answers
Php select option selected from database
PHP
0 vote358 views1 answer
How to store wp editor in wordpress
PHP Wordpress
1 vote337 views1 answer
How to add an custom error to validater error in laravel
PHP
0 vote367 views1 answer
Defining constant in config laravel
PHP Laravel
0 vote332 views1 answer
Foreach empty laravel
PHP Laravel