php中mysql的交易處理

<?php</p><p>$database = mysql_connect( "localhost","root", "helloworld" );<br />mysql_select_db( 'test', $database );<br />mysql_query( 'set names utf-8' );</p><p>mysql_query( 'START TRANSACTION' );<br />$sql = "update tbl_test set name=wuhuiran where id=1";// 這裡將執行失敗，因為name是varchar類型的<br />mysql_query( $sql );<br />if( mysql_errno() )<br />{<br />mysql_query( 'ROLLBACK' );<br />exit(mysql_error());<br />}</p><p>$sql = "insert into tbl_test (name) values ('psli')";<br />mysql_query( $sql );<br />if( mysql_errno() )<br />{<br />mysql_query( 'ROLLBACK' );<br />exit( mysql_error() );<br />}</p><p>mysql_query( 'COMMIT' ) or exit( mysql_error() );<br />mysql_close( $database );</p><p>?>