{"id":221,"title":"php+pdo+transaction(\u4e8b\u52a1)","good":0,"bad":0,"hit":1356,"created_at":"2016-04-26 00:08:34","content":"<p>\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff0cpdo\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u5e76\u542f\u7528\u4e8b\u52a1(\u8868\u5f15\u64ce\u5fc5\u987b\u4e3ainodb)<br\/><\/p><p>&lt;?php<br\/>$dsn = &quot;mysql:host=localhost;dbname=test&quot;;<br\/>$db = new PDO($dsn, &#39;root&#39;, &#39;&#39;);<br\/>$db-&gt;beginTransaction();<br\/>$ok1=$ok2=false;<br\/>$sql1=&quot;insert into t1(`orderid`) values(&#39;2222&#39;)&quot;;<br\/>$sql2=&quot;insert into t2(`orderid1`) values(&#39;2222&#39;)&quot;;<br\/>if($db-&gt;exec($sql1)){$ok1=true;};<br\/>if($db-&gt;exec($sql2)){$ok2=true;};<br\/>if($ok1&amp;&amp;$ok2){<br\/>&nbsp;&nbsp; &nbsp;$db-&gt;commit();<br\/>}else{<br\/>&nbsp;&nbsp; &nbsp;rizhi($sql1,$sql2);<br\/>&nbsp;&nbsp; &nbsp;$db-&gt;rollBack();<br\/>}<br\/>$sql3=&quot;insert into t1(`orderid`) values(&#39;3333&#39;)&quot;;<br\/>$sql4=&quot;insert into t2(`orderid2`) values(&#39;4444&#39;)&quot;;<br\/>$db-&gt;exec($sql3);<br\/>$db-&gt;exec($sql4);<br\/><br\/>function rizhi($sql1,$sql2){<br\/>&nbsp;&nbsp; &nbsp;$data=date(&#39;Ymd H:i:s&#39;).&quot;\\r\\n&quot;.$sql1.&quot;\\r\\n&quot;.$sql2.&quot;\\r\\n&quot;;<br\/>&nbsp;&nbsp; &nbsp;$fp=fopen(&#39;a.txt&#39;,&#39;a+&#39;);<br\/>&nbsp;&nbsp; &nbsp;fwrite($fp, $data);<br\/>&nbsp;&nbsp; &nbsp;fclose($fp);<br\/>}<br\/>?&gt;<\/p>"}