马克的足迹！ html, javascript, css, php, python develop and design

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(); 

// ...
?>