thinking out loud

raycauchi

can an INNODB transaction span scripts?

if you, say, open a connection to MySQL, begin a transaction, do some stuff, then ?> end of script, without having committed the transaction, and with AUTOCOMMIT = 0, can you then process this first script in a second script, and at the end commit the transaction? or maybe at the end of a third or fourth script?

Or is this where an Object stored in a session is more relevant???

Will PHP atill autoclose a connection to MySQL when within a transaction?

trooper

Good question there .... i'd also like to know the answer to this

cgraz

It closes the connection automatically at the end of the script's execution unless closed earlier.

http://www.php.net/manual/en/function.mysql-connect.php

Cgraz

trooper

So in that case would it be able to be done using pconnect?

ahundiak

Nope on the pconnect question. Pconnect will keep alive the connection but there is no gaurentee that the next script will get the same connection.

trooper

So the moral of the story is

Always ensure that your transactions are complete before going onto a new page