note 125257 added to pdo.intransaction
| From: | Anonymous@php.net | 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