note 125257 added to pdo.intransaction

From: Date: Mon, 10 Aug 2020 07:27:57 +0000
Subject: note 125257 added to pdo.intransaction
Groups: php.notes 
Request: Send a blank email to php-notes+get-214942@lists.php.net to get a copy of this message
In addition to what jlh says, even with SQLite3 which automatically starts transaction, inTransaction() only works after beginTransaction(). <?php try{ $pdo = new PDO('sqlite:test.sql3', null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); var_dump($pdo->inTransaction());echo "<br>"; // bool(false) : before beginTransaction() $pdo->beginTransaction(); var_dump($pdo->inTransaction());echo "<br>"; // bool(true) : after beginTransaction() $pdo->rollBack(); var_dump($pdo->inTransaction());echo "<br>"; // bool(false) : after commit() or rollBack() }catch (PDOException $e){ echo 'PDOException: ' . $e->getMessage(); }catch (Exception | ErrorException $e){ var_dump($e); } ---- Server IP: 45.112.84.4 Probable Submitter: 103.51.166.36 (proxied: 180.18.157.203) ---- Manual Page -- http://php.net/manual/en/pdo.intransaction.php Edit -- https://master.php.net/note/edit/125257 Del: integrated -- https://master.php.net/note/delete/125257/integrated Del: useless -- https://master.php.net/note/delete/125257/useless Del: bad code -- https://master.php.net/note/delete/125257/bad+code Del: spam -- https://master.php.net/note/delete/125257/spam Del: non-english -- https://master.php.net/note/delete/125257/non-english Del: in docs -- https://master.php.net/note/delete/125257/in+docs Del: other reasons-- https://master.php.net/note/delete/125257 Reject -- https://master.php.net/note/reject/125257 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#214942) next »