:30 AM
Subject:[PHP-DB] Transactions with PDO_INFORMIX
Sent by:Neomi TR
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
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 encounte
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], [email protected]
Subject: Re: [PHP-DB] transactions
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 exec
then start the transaction, so your inserts and
> commit...
>
> Bastien
>
>
> >From: martin lutsch <[EMAIL PROTECTED]>
> >To: [email protected]
> >Subject: [PHP-DB] transactions
> >Date: Mon, 07 Nov 2005 11:18:53 +0100
> >
> >hi,
> >
>
data until
you have all the elements, then start the transaction, so your inserts and
commit...
Bastien
From: martin lutsch <[EMAIL PROTECTED]>
To: [email protected]
Subject: [PHP-DB] transactions
Date: Mon, 07 Nov 2005 11:18:53 +0100
hi,
i have a problem with mysql transactions
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
> {
> commit();
> echo "your insertions were successful";
> }else{
> echo mysql_errno($link)." :
> ".mysql_error($link)."\n";
> rollback();
> exit;
> }
>
> Graham
>
>
> > -Original Message-
> > From: Stuart
echo mysql_errno($link)." : ".mysql_error($link)."\n";
rollback();
exit;
}
Graham
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 16 October 2004 13:53
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Transactions - working bu
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 ,
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). Usin
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 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 quer
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 wouldn'
How did you know I was using INNOdb tables ? :)
So here is one question, that I can't seem to find a
good answer on.
So the first table, where the first insert must go
looks like this:
[MainTable]
+--+--++
| Record_ID (auto inc int) | Member ID| ...|
+
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 br
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 pe
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,
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 s
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
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 s
The likest solution for you problem seems to be session. Start a
session on the first page. On the next page validate every
variable and if all went ok, bind it to the current session.
Don't forget to make a page counter so no one can jump easily
from page one to four. After your last form action
Hi all.
I need to make a transaction over several pages and commit it after
validating the last one.
I am using linux+apache+php4 module+Informix.
Thanks.
Marko.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMA
23 matches
Mail list logo
