I found one item in the PHP Classes Repository that may be of use.
Unfortunately, the comments are in Spanish, so it's up to you to figure out the
code.
http://promoxy.mirrors.phpclasses.org/browse.html/file/3077.html
Edward Dudlik Becoming Digital www.becomingdigital.com
----- Original Message ----- From: "Jonas Geiregat" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 17 June, 2003 13:44 Subject: transactions with php
I'm trying to implement transaction (mysql) in my php code. Could anyone tell me if this is a good way of using them. I make an array with all the query's I loop through them. like this mysql_query($qarray[$i])or die($flag = false);. After the loop I do if($flag) commit; else rollback; Is this a good way of implementing them ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
This is a much better implementation then my previous one
I loop trough a array with query's.
in the loop I do:
if(!mysql_query($array[$i])) {
$flag = false;
break;
}after the loop I do
if($flag)
mysql_query("commit");
else
mysql_query("rollback");This should work haven't tested it yet. If anyone got better idea's Post them Regards Jonas Geiregat
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
