: 01/14/2014 10:30 AM
Subject:[PHP-DB] Transactions with PDO_INFORMIX
Sent by:Neomi TR ne...@post.isoc.org.il
Hi,
I use the PDO functions PDO::beginTransaction, PDO::commit and
PDO::rollBack to
begin, commit and rollback transactions.
I also check that we are in active
Hi,
I use the PDO functions PDO::beginTransaction, PDO::commit and
PDO::rollBack to
begin, commit and rollback transactions.
I also check that we are in active or no active transaction with
'PDO::inTransaction'.
System info:
PHP 5.3.28
INFORMIX 11.70
PDO_INFORMIX-1.3.0
Lately we have
and
commit...
Bastien
From: martin lutsch [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] transactions
Date: Mon, 07 Nov 2005 11:18:53 +0100
hi,
i have a problem with mysql transactions and php:
i want to do a transaction through more than one php scripts. i think,
if one
On Tuesday 08 November 2005 09:37, Koen Wagemans wrote:
MySQL isn't a transactional DB it doesn't know rollback and commit.
MySQL does support transactions so long as you use a reasonably recent version
and InnoDB tables.
However as Bastien suggested a transaction can't persist beyond the
Incorrect, MySQLs MyISAM engine is non transactional, the InnoDB engine /
BDB egines both support transactions
Bastien
From: Koen Wagemans [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject: Re: [PHP-DB] transactions
Date: Tue, 8 Nov
hi,
i have a problem with mysql transactions and php:
i want to do a transaction through more than one php scripts. i think,
if one script ends and links to another, the database connection ends
and the transaction rolles back. how can i continue one transaction
through more than one script?
any
until
you have all the elements, then start the transaction, so your inserts and
commit...
Bastien
From: martin lutsch [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] transactions
Date: Mon, 07 Nov 2005 11:18:53 +0100
hi,
i have a problem with mysql transactions and php:
i want
My statements are all working but I'm not sure if
things are set up correctly. I say this because at
one point the first $query failed, yet the rest of
inserts wre committed. Now I believe I need to set
autocommit to 0 , yet the query failed due to a syntax
error. Hence 0 records effected
El Sáb 16 Oct 2004 09:52, Stuart Felenstein escribió:
My statements are all working but I'm not sure if
things are set up correctly. I say this because at
one point the first $query failed, yet the rest of
inserts wre committed. Now I believe I need to set
autocommit to 0 , yet the query
I think you are adding a conditonal /validaton
statement as the constraint ? More then x characters
will generate an error.
My understaning is an error in mysql transaction will
rollback should rollback the entire set of
transactions.
error handling for each statement- values will be
coming from
El Sáb 16 Oct 2004 11:36, Stuart Felenstein escribió:
I think you are adding a conditonal /validaton
statement as the constraint ? More then x characters
will generate an error.
I was tryiong to generate a validation that would fail with certain inserts
(or modification of a register). Using
See Interspersed:
--- Martín Marqués [EMAIL PROTECTED] wrote:
I was tryiong to generate a validation that would
fail with certain inserts
(or modification of a register). Using more then 25
characters in the second
field would yield the same result.
Got that and yes, for my pages , they
: Stuart Felenstein
[mailto:[EMAIL PROTECTED]
Sent: 16 October 2004 13:53
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Transactions - working but
unsure about steps
My statements are all working but I'm not sure if
things are set up correctly. I say this because
at
one point the first
At 12:52 +0900 9/1/02, Jean-Christian Imbeault wrote:
Paul Dubois wrote:
I am worried that if I use persistent connections it might be
possible for more than one PHP script to be inside the same
transaction at the same time.
Not at the *same* time, because although a persistent connect
Paul Dubois wrote:
Does the script go from start to finish even though the connection to
the browser has been severed. I.e. The script will run complete even
if there is output to the browser as the script is running?
Not necessarily. It won't base its actions on what the browser
I'm a little confused/worried about database transactions, persistent
connections and PHP.
I am worried that if I use persistent connections it might be possible
for more than one PHP script to be inside the same transaction at the
same time.
For example:
1- page1.php is a script that opens
At 17:46 +0900 8/31/02, Jean-Christian Imbeault wrote:
I'm a little confused/worried about database transactions,
persistent connections and PHP.
I am worried that if I use persistent connections it might be
possible for more than one PHP script to be inside the same
transaction at the same
Paul Dubois wrote:
I am worried that if I use persistent connections it might be possible
for more than one PHP script to be inside the same transaction at the
same time.
Not at the *same* time, because although a persistent connect might be
used by more than one script, this will
Hello, "Marko Perich"!
You wrote:
I need to make a transaction over several pages and
commit it after
validating the last one.
Insert line on the first page, update on next, mark as
commited on the last. Each hour drop uncommited lines. You
may also provide current time of transaction
19 matches
Mail list logo