|
- $sql1 = "update User set ScoreCount = ScoreCount +10 where ID= '123456'";
- $sql2 = "update ScoreDetail set FScore = 300 where ID= '123456'";
- $sql3 = "insert into ScoreDetail ID,Score) values ('123456',60)";
- $conn = mysql_connect('localhost','root','');
- mysql_select_db('DB_Lib2Test');
- mysql_query('start transaction');
- //mysql_query('SET autocommit=0');
- mysql_query($sql1);
- mysql_query($sql2);
- if(mysql_errno ()){
- mysql_query('rollback');
- echo 'err';
- }else{
- mysql_query('commit');
- echo 'ok';
- }
- // mysql_query('SET autocommit=1');
- // mysql_query($sql3);
复制代码
Mysqli:
- <p>$sql1 = "update User set ScoreCount = ScoreCount +10 where ID= '123456'";
- $sql2 = "update ScoreDetail set FScore = 300 where ID= '123456'";
- $sql3 = "insert into ScoreDetail ID,Score) values ('123456',60)";</p><p>
- $mysqli = new mysqli('localhost','root','','DB_Lib2Test');</p><p>
- $mysqli->autocommit(false);//开始事物
- $mysqli->query($sql1);
- $mysqli->query($sql2);
- if(!$mysqli->errno){
- $mysqli->commit();
- echo 'ok';
- }else{
- echo 'err';
- $mysqli->rollback();
- }
- </p><p> </p>
复制代码
|
|