PHP事务的如何写?
PHP 的事务怎么写? 我现在是一条update,一条insert
代码如下,错误是,值类型发生了错误,事务没起作用.
$db = new DbManager();<br>
$conn = $db->getConnection();<br>
$conn->set_charset("utf8");<br>
<br>
if(mysqli_connect_errno())<br>
{<br>
echo 'error connect database! please content manager!';<br>
exit;<br>
}<br>
//echo connection_status();<br>
$tbNums = explode(',',$tbNum);<br>
<br>
$conn->autocommit(FALSE);<br>
$flag = true;<br>
$a=0;<br>
foreach($tbNums as $key => $value)<br>
{<br>
$updateBalance = "UPDATE T_SMS_TBNUM SET STATUS = 2 WHERE ID = ?";<br>
$insertRelate = "INSERT INTO T_SMS_TBNUMRELATE (TBID,OWNCLIENTID,REALFEE,CREATETIME) VALUES(?,?,?,?)";<br>
<br>
<br>
$stmtUpdateClient = $conn->prepare($updateBalance);<br>
$stmtUpdateClient->bind_param('i',$value);<br>
$ss = $stmtUpdateClient->execute();<br>
<br>
$stmt = $conn->prepare($insertRelate);<br>
$foura = 4;<br>
$a++;<br>
if($a!=0){<br>
$value = 's';<br>
}<br>
$stmt->bind_param('iids',$value,$clientId,$foura,date('Y-m-d H:i:s'));<br>
$boooo = $stmt->execute();<br>
echo $ss.'+'.$boooo;<br>
if($stmtUpdateClient->affected_rows <= 0 || $stmt->affected_rows <= 0)<br>
{<br>
echo $stmtUpdateClient->affected_rows.'|'.$stmt->affected_rows;<br>
$flag = false;<br>
break;<br>
}<br>
}<br>
if(!$flag)<br>
{<br>
$conn ->rollback();<br>
$conn -> autocommit(TRUE);<br>
$conn->close();<br>
return 'paylog false!';<br>
}else<br>
{<br>
$conn->commit();<br>
$conn -> autocommit(TRUE);<br>
$conn->close();<br>
return '1';<br>
}










