|
Hi!
Has anyone managed to use transactions with MySQL and Php?
The server I'm currently on does have problems with database connections from time to time. (It has happened that new players have signed up, but not received any activation e-mail because the database connection was lost in between actions).
I've tried to use SET AUTOCOMMIT=0 and then use BEGIN, END and COMMIT statements.
If I put an "exit;" (in the php code) and halts it before the COMMIT, all changes should be rolled-back right? It seems like it doesn't.
Or is the mysqli class a better alternative?
__________________
Please login or register to view this content. Registration is FREE - Create your own city
|
