Subject Re: [firebird-php] Rollback of set of updates
Author Lester Caine
masotti wrote:
> Try to explain better:
> masotti ha scritto:
>> Lester Caine ha scritto:
>>> But how do people handle holding a transaction open -
>>> CAN we in PHP?
>> AFAIK no. Transaction are closed (committed or rollback) at the end of
>> the script. Docs are clear about that.
>> Workaround are:
>> 1) Temporary tables (connection persistence)
>> 2) $_SESSION superglobal
>> Don't know other methods.
> In the sense yhat you (as I actually do) must retain all data in php
> structures (or not transactional data), and commit all in a single phase
> at the end,only when thibgs are all prepared and user clicks "CONFIRM".
> If the user chosses an other path, data are erased (partially or
> globally), and restarts from a well known point.

That is where I thought we were at ;)
But perhaps it is something that we could look at if we are to improve
the driver.
Persistent transactions to go with persistent connections.

Lester Caine - G8HFL
Contact -
L.S.Caine Electronic Services -
EnquirySolve -
Model Engineers Digital Workshop -
Firebird -