php mysql 系列函数执行事务

jcde098

1. $sql1 = "update User set ScoreCount = ScoreCount +10 where ID= '123456'";
   
2. $sql2 = "update ScoreDetail  set FScore = 300 where ID= '123456'";
   
3. $sql3 = "insert into  ScoreDetail ID,Score) values ('123456',60)";
   
4. $conn = mysql_connect('localhost','root','');
   
5. mysql_select_db('DB_Lib2Test');
   
6. 
   
7. mysql_query('start transaction');
   
8. //mysql_query('SET autocommit=0');
   
9. 
   
10. mysql_query($sql1);
    
11. mysql_query($sql2);
    
12. 
    
13. if(mysql_errno ()){
    
14.     mysql_query('rollback');
    
15.     echo 'err';
    
16. }else{
    
17.     mysql_query('commit');
    
18.     echo 'ok';
    
19. }
    
20. 
    
21. // mysql_query('SET autocommit=1');
    
22. // mysql_query($sql3);

复制代码

Mysqli:

1. <p>$sql1 = "update User set ScoreCount = ScoreCount +10 where ID= '123456'";
   
2. $sql2 = "update ScoreDetail  set FScore = 300 where ID= '123456'";
   
3. $sql3 = "insert into  ScoreDetail ID,Score) values ('123456',60)";</p><p>
   
4. $mysqli = new mysqli('localhost','root','','DB_Lib2Test');</p><p>
   
5. $mysqli->autocommit(false);//开始事物
   
6. $mysqli->query($sql1);
   
7. $mysqli->query($sql2);
   
8. if(!$mysqli->errno){
   
9.   $mysqli->commit();
   
10.   echo 'ok';
    
11. }else{
    
12. echo 'err';
    
13.   $mysqli->rollback();
    
14. }
    
15. </p><p> </p>

复制代码