Thread: Transactions <-> Connections and Userrights
hi over there, how am i able to let a transaction exist among several connections, or is just one possible ? cause my phpskript cuts connection from db bevor reloading itself ofcourse :-) -how can i get information about the group which a user belongs to and its rights ? Thanx a lot Ravi
Not sure on the user groups question, but you can't hold a transaction over multiple PHP sessions in any standard way. People think that persistent connections will do this, but they don't. The two solutions to this are to store all the SQL commands in an array and then run them within a transaction on the last page, or to write some sort of "servlet" (either in JAVA or a C/C++ daemon) that stays open for the full run of the scripts, and issues all the DB commands itself. The first one is a LOT simpler to code, but if you've got SELECTs that require data changed from previous writes (INSERTs, UPDATEs, DELETEs) you are out of luck.
At 05:19 AM 9/11/01, Ravi Ahluwalia wrote:
At 05:19 AM 9/11/01, Ravi Ahluwalia wrote:
hi over there,
how am i able to let a transaction exist among several connections, or
is just one possible ? cause my phpskript cuts connection from db
bevor reloading itself ofcourse :-)
-how can i get information about the group which a user belongs to and
its rights ?
Thanx a lot
Ravi
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster