PHP Transaction problem?

mshen

Java and Coldfusion have statement to do transaction,that mean they can control the "commit" and "rollback" the SQL actions.

Do you think PHP also has the same functions?

Thanks.

martinacevedo

have you got a mysql database as back end?

the last release from mysql support transaction, but not the olders.
You must to make innodb tables (not isam)..

You should to read mysql manual and which version you have

bye

martinacevedo

you can also use locking individual talbes, with the clausule LOCK TABLE (see mysql manual);

bye

mshen

I want to know the PHP syntax.many database have transaction feature.also many lauguage support it like java and coldfusion.

Thanks

martinacevedo

you are looking for a framework, i think. php has functions to maniulate database, but not in abstract mode like recorsets in asp, in a common api.

you should to search a framework for database, writed lower level like c extensions or higger level in php.
Pear has many frameworks, in php, included database, you can find on

http://pear.php.net/package-info.php?pacid=46

bye