ALL OR NOTHING: (works i.e. with MS ACCESS - ODBC)
function prepare()
{ global $conn;
$result = odbc_prepare ( $conn, "CREATE TABLE XX(test int);CRATE TABLE
YY;");
if(odbc_execute($result)){echo "Everything is OK (but shouldn't!).";}
else{echo "Error in the statement. Table XX should NOT be ther
We use the Access-Engine via ODBC. And it sopports rollbacks. But, please,
how could I rollback, what I want to, when I use a p-connection.
For example:
Transaction 1 (UPDATE TAB1...);
Transaction 2 (UPDATE TAB2...);
Between Transaction1 and Transaction2 the Connection to the DB gets
interrupted
half way through which I'd imagine
could cause a problem.
<>< Ryan
-Original Message-
From: Peter Westergaard [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 3:14 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP Processing
I'm sorry, I feel dense coming to the list for
eems to do the
trick.
<>< Ryan
-Original Message-
From: Alan Langford [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 3:48 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP Processing
Do a search for "user stop" in the PHP manual, there you will fi
Do a search for "user stop" in the PHP manual, there you will find
"connection handling" and the ignore_user_abort function.
At 2004/01/05 17:14, Peter Westergaard wrote:
I'm sorry, I feel dense coming to the list for this, because I'm
SURE I've read about this in the PHP or Mysql docs, but I can
riginal Message-
From: Peter Westergaard [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 3:14 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP Processing
I'm sorry, I feel dense coming to the list for this, because I'm SURE
I've read about this in the PHP or Mysql docs,
I'm sorry, I feel dense coming to the list for this, because I'm
SURE I've read about this in the PHP or Mysql docs, but I can't seem
to locate where.
Let's say users submit a form which is processed by a PHP page which
performs a number of MySQL INSERT, UPDATE, and/or DELETE commands.
.
What
