thinkphp Multi-Table transaction detailed _php tutorial

As shown below:
Copy CodeThe code is as follows:
function Makeacquire ($nUsers, $nAwards)
{
//Update database
$tranDb = new Model ();
$tranDb->starttrans ();
for ($i = 0; $i < sizeof ($nUsers); $i + +)
{
//Update table Acquire
$flagAc = $tranDb->table (' Acquire ')->add ($acquire);
//Update table users
$where = Array (' u_id ' = = $nUsers [$i] [' u_id ']);
$flagU = $tranDb->table (' Users ')->where ($where)->setinc (' U_man_count ', 1);
//Update table Award
$where = Array (' a_id ' = = $nAwards [$i] [' a_id ']);
$flagA = $tranDb->table (' award ')->where ($where)->setdec (' A_count ', 1);
}
if ($flagAc && $flagU && $flagA)
{
$tranDb->commit ();
}
Else
{
$tranDb->rollback ();
}
}

http://www.bkjia.com/PHPjc/327670.html www.bkjia.com true http://www.bkjia.com/PHPjc/327670.html techarticle As follows : the copy Code code is as follows: function Makeacquire ($nUsers, $nAwards) {//update database $tranDb = new Model (); $tranDb-starttrans (); for ($i = 0; $i sizeof ($nUsers); $i ...

