Sample TextSample TextSample Text
<?php
$db = NewADOConnection('mysql'); //创建一个ADODB连接对象
$mysql_conn = $db->Connect("localhost","root","", "anna");
$db->BeginTrans();
$ok = $db->Execute("update user set user_name= '098'where id=3")or die("Error in query:".$db->ErrorMsg());
if($ok)
$ok=$db->Execute("update user set user_name= where id=2")or die("Error in query:".$db->ErrorMsg());
if ($ok) {$db->CommitTrans();}
else {$db->RollbackTrans(); }
?>
结果却是第一条语句成功了，第二条没有成功。
但是同样我用MYSQL自带的函数却可以实现我要的功能，代码如下：
<?php
mysql_query("SET AUTOCOMMIT=0");
$ok1 = $db->Execute("update user set user_name= '098'where id=3")or die("Error in query:".$db->ErrorMsg());
$ok2=$db->Execute("update user set user_name= where id=2")or die("Error in query:".$db->ErrorMsg());
if ($ok1 && $ok2 ){ mysql_query("COMMIT");}
else {mysql_query("ROLLBACK");}
?>
为什么啊？急救！！谢谢
