PHP uses file locks to solve high concurrency problems

This time I will bring you Tphp's use of file locks to solve high concurrency problems. What are the precautions for PHP's use of file locks to solve high concurrency problems? The following is a practical case, let's take a look.

Create a new .txt file without writing anything in the file.

【一】.Blocking (waiting) mode: (As long as other processes have locked the file, the current process will wait for other processes to unlock the file)

  //连接数据库
 $con=mysqli_connect("192.168.2.186","root","root","test");
 //查询商品数量是否大于0,大于0才能下单,并减少库存
 $fp = fopen("lock.txt", "r");
 //加锁
 if(flock($fp,LOCK_EX))
{ 
 $res=mysqli_fetch_assoc(mysqli_query($con,'SELECT total FROM shop WHERE id=1 LIMIT 1')); 
 if($res['total']>0){mysqli_query($con,'UPDATE shop SET total=total-1 WHERE id=1');} //执行完成解锁
 flock($fp,LOCK_UN);
}
//关闭文件
fclose($fp);
unset($res);
mysqli_close($con);
?>

【二】.Non-blocking (waiting) mode: (As long as other processes have locked the file, the current process will not wait for other processes to unlock the file and return directly)

  //连接数据库
 $con=mysqli_connect("192.168.2.186","root","root","test");
 //查询商品数量是否大于0,大于0才能下单,并减少库存
 $fp = fopen("lock.txt", "r");
 //加锁if(flock($fp,LOCK_EX | LOCK_NB))
{ 
 $res=mysqli_fetch_assoc(mysqli_query($con,'SELECT total FROM shop WHERE id=1 LIMIT 1')); 
 if($res['total']>0){mysqli_query($con,'UPDATE shop SET total=total-1 WHERE id=1');} 
 //执行完成解锁
 flock($fp,LOCK_UN);
}//关闭文件
fclose($fp);
unset($res);
mysqli_close($con);
?>

If connecting to the database takes time, there is a simple demo below for a more intuitive understanding.

demo.php 
        

         Copy after login
        
       

Run two files at the same time, and then modify the locking mechanism in demo2, you can see thatblocking (waiting) modeandnon-blocking (waiting) ) mode
difference.

But this will cause the queue to be blocked. If 10 people write to the database at the same second, it will be blocked. The 10th person will wait for the first 9 to be executed before executing!

The above is the detailed content of PHP uses file locks to solve high concurrency problems. For more information, please follow other related articles on the PHP Chinese website!