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

4 votes145 views1 answer
Laravel relation of relation
PHP
2 votes141 views1 answer
Phpmyadmin first login
PHP
1 vote162 views2 answers
Page expire in laravel
PHP
0 vote161 views1 answer
If post checked category wordpress
PHP Wordpress
5 votes125 views1 answer
Redirect wordpress
PHP
0 vote115 views1 answer
Unable to open file error in php
PHP
0 vote134 views1 answer
Alternatively, you may set the environment variables ONIG_CFLAGS and ONIG_LIBS to avoid the need to call pkg-config.
PHP
3 votes154 views2 answers
Laravel tinker update password
PHP Laravel
0 vote183 views2 answers
Wordpress truncate text
PHP
0 vote128 views2 answers
Adminlte in laravel 8
PHP