RE: [PHP-DB] Innodb and transactions.
| From: | Steve Bradwell | Date: | Fri, 21 Jun 2002 12:55:27 +0000 |
| Subject: | RE: [PHP-DB] Innodb and transactions. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19947@lists.php.net to get a copy of this message | ||
So should I be using Innodb tables or BDB tables?
Thanks,
Steve.
-----Original Message-----
From: Michael Bretterklieber [mailto:mbretter@jawa.at]
Sent: Friday, June 21, 2002 2:49 AM
To: Php-Db (E-mail)
Subject: Re: [PHP-DB] Innodb and transactions.
Hi,
you have to do something like this:
mysql_query('SET AUTOCOMMIT=0');
....
mysql_query('COMMIT'); or mysql_query('ROLLBACK');
mysql_query('SET AUTOCOMMIT=1');
bye,
Steve Bradwell schrieb:
> Hi all,
>
> I have just figured out and set up my Innodb on my mysql server so I can
use
> transactions Begin, commit, rollback. I'm now looking for examples on how
to
> do this with php. I hit the php site and the best I could find was
> fbsql_commit etc... is this what I'm looking for? There's no documentation
> yet. I'm using php4 with mysql 3.23.49-max, and my tables are Innodb.
>
> I appologize if my lingo is somewhat confusing or just wrong but I'm
pretty
> new to this stuff.
>
> Any input or examples would be greatly appreciated.
>
> Thanks,
> Steve.
>
>
--
--------------------------------------
Michael Bretterklieber
LCP
JAWA Management Software GmbH
Liebenauer Hauptstr. 200
A-8041 GRAZ
Tel: ++43-(0)316-403274-12
Fax: ++43-(0)316-403274-10
GSM: ++43-(0)676-93 96 698
Michael.Bretterklieber@jawa.at
homepage: http://www.jawa.at
--------- privat -----------
E-mail: mbretter@inode.at
homepage: http://www.inode.at/mbretter
--------------------------------------
"...the number of UNIX installations has grown to 10, with more expected..."
- Dennis Ritchie and Ken Thompson, June 1972
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php