Transaction trong PHP

[hocnv]

Chao tat ca cac ban!

Ban nao co doan code bieu dien y tuong transaction trong PHP cho minh voi.

Minh muon lam nhu sau :

Khi minh ket noi database de thuc hien 2 thao tac tren database, nhung neu mot trong 2 thao tac nay bi loi thi minh muon huy bo ca 2 thao tac. Va chi thuc hien neu ca 2 thao tac deu thanh cong.

Hien minh rat can no.

Cam on cac ban nhieu!!!

[MatrixWD]

Chao tat ca cac ban!

Ban nao co doan code bieu dien y tuong transaction trong PHP cho minh voi.

Minh muon lam nhu sau :

Khi minh ket noi database de thuc hien 2 thao tac tren database, nhung neu mot trong 2 thao tac nay bi loi thi minh muon huy bo ca 2 thao tac. Va chi thuc hien neu ca 2 thao tac deu thanh cong.

Hien minh rat can no.

Cam on cac ban nhieu!!!

Day la doan code duoc dung cho PostgreSQL, minh khong biet no co the chay tot voi MySQL hay khong?
Trong ham nay tham so $dbconn la doi tuong connection, $strSql la mot mang chua cac cau lenh sql.

Function fTableInsert($dbconn, $strSql)
{
// Transaction of Start
if(pg_exec($dbconn,"BEGIN") == false)
return false;

for ($i=0;$i<count($strSql);$i++)
{
if (pg_exec($dbconn,$strSql[$i])==false)
{
// Write-in failure
pg_exec($dbconn,"ROLLBACK");
return false;
}
}

// Write-in completion
pg_exec($dbconn,"COMMIT");
return true;
}