Incorrect, MySQLs MyISAM engine is non transactional, the InnoDB engine /
BDB egines both support transactions
Bastien
From: Koen Wagemans <koen.wagemans@xxxxxxxxx>
To: Bastien Koert <bastien_k@xxxxxxxxxxx>
CC: martin.lutsch@xxxxxxxxxxxxxxxxxxxxxxxx, php-db@xxxxxxxxxxxxx
Subject: Re: transactions
Date: Tue, 8 Nov 2005 10:37:15 +0100
Hello
MySQL isn't a transactional DB it doesn't know rollback and commit.
You can solve the problem probably by locking the tables (LOCK / UNLOCK)
Regards
Koen
On 07/11/05, Bastien Koert <bastien_k@xxxxxxxxxxx> wrote:
> I don't think you can. Once the script finishes the connections are
closed
> and the transactions completed. What are you trying to do where you need
to
> have the transaction across multiple pages? Perhaps, if you are
gathering
> the data across the pages, you could use a session to store the data
until
> you have all the elements, then start the transaction, so your inserts
and
> commit...
>
> Bastien
>
>
> >From: martin lutsch <martin.lutsch@xxxxxxxxxxxxxxxxxxxxxxxx>
> >To: php-db@xxxxxxxxxxxxx
> >Subject: transactions
> >Date: Mon, 07 Nov 2005 11:18:53 +0100
> >
> >hi,
> >
> >i have a problem with mysql transactions and php:
> >i want to do a transaction through more than one php scripts. i think,
> >if one script ends and links to another, the database connection ends
> >and the transaction rolles back. how can i continue one transaction
> >through more than one script?
> >any ideas? please help,
> >
> >cheers, martin
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
