adodb 事务，行锁定
Posted in 默认分类 on 二月 3rd, 2009 by admin – 评论关闭
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();
// ...
?>