Hi
I am attempting to use innodb tables in mysql to handle some transactions my php/mysql system need to be reliable
How is it done with php and mysql ?
Supose i have these functions inside a class :
//----- begin transaction
function begin() {
mysql_query("BEGIN",$this->connect_id);
}
//----- commit transaction
function commit() {
mysql_query("COMMIT",$this->connect_id);
}
//----- rollback transaction
function rollback() {
mysql_query("ROLLBACK",$this->connect_id);
}
Do i need to set autocommit = 0 ? with php how can i do it?
mysql_query("set autocommit=0")?
How they are used to implement transactions on my system ?
Thank´s in advance