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 /> }
