adodb 事务，行锁定
startTrans();
//实际，getOne所调用的查询也可以直接放到rowLock来进行，这里只是为了演示效果能更明显些。
$adodb->rowLock('book', 'book_id = 123');
$bookNumber = $adodb->getOne("SELECT book_number FROM book WHERE book_id = 123");
$adodb->execute("UPDATE book SET book_number = book_number - 1 WHERE book_id = 123");
$adodb->completeTrans();
// ...
?>
Tags: adodb, rowlock
This entry was posted
on 星期二, 二月 3rd, 2009 at 09:52 and is filed under 默认分类.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.