PHP implements concurrent snap-up function through locking

This article uses locking based on the PHP language to implement the rush purchase function under concurrent circumstances. The rush purchase is open during a specific period of time and does not allow duplication of open codes. This article is very detailed, please refer to it if you need it. I hope to be helpful.

Requirements: code grabbing function

Requirements:

1. Code grabbing is only open during a specific time period;

2. The codes released in each time period are limited;

3. Each code is not allowed to be repeated;

Implementation:

1. Implementation without considering concurrency:

function get_code($len){
$CHAR_ARR = array('1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','X','Y','Z','W','S','R','T');
$CHAR_ARR_LEN = count($CHAR_ARR) - 1;
$code = '';
while(--$len > 0){ $code .= $CHAR_ARR[rand(0,$CHAR_ARR_LEN)]; }
return $code;
}
$pdo = new PDO('mysql:host=localhost;dbname=ci_test','root','root');
//查询当前时间已发放验证码数量
$code_num_rs = $pdo->query("SELECT COUNT(*) as sum FROM code_test");
$code_num_arr = $code_num_rs->fetch(PDO::FETCH_ASSOC);
$code_num = $code_num_arr['sum'];
if($code_num < 1){
　　 sleep(2); //暂停2秒
$code = get_code(6);
var_dump( $pdo->query("INSERT INTO code_test (code,create_time) VALUES ('$code',".time().")") );
}

The above code satisfies the current opening time by default, and the code is not repeated;

The process without considering concurrency:

1) Select to query the number of verification codes issued by the current database;

2) If there are still places, generate the verification code, insert it into the database, and return the verification code to Client;

　3) If it is full; it will return a prompt that there are no more places;

2. Implementation under concurrent circumstances:

Then take a look at the results obtained by the above code in a concurrent situation:

To test concurrency, you can use apache benchmark to test. apache benchmark is the performance evaluation tool of HTTP SERVER under APACHE. Enter through cmd In the bin directory of apche, call it through the ab command, such as: ab -c concurrent number -n total visits url

cb -c 100 -n 100 http://localhost/php_mulit.php

In this way, 100 user colleagues will grab 1 quota. When querying, each When users check that there is still a quota, they will generate a verification code, insert it into the database, and return the verification code; this will cause too many verification codes to be issued. In fact, after running this command, the database has 13 more records instead of one.

How to avoid this happening?

You can lock the process from judgment to insertion by adding an exclusive lock to ensure that only one process is running in this judgment process at any time. The implementation is as follows:

//生成码
function get_code($len){
$CHAR_ARR = array('1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','X','Y','Z','W','S','R','T');
$CHAR_ARR_LEN = count($CHAR_ARR) - 1;
$code = '';
while(--$len > 0){ $code .= $CHAR_ARR[rand(0,$CHAR_ARR_LEN)]; }
return $code;
}
$pdo = new PDO('mysql:host=localhost;dbname=ci_test','root','root');
$fp = fopen('lock.txt','r');
//通过排他锁 锁定该过程
if(flock($fp,LOCK_EX)){
//查询当前时间已发放验证码数量
$code_num_rs = $pdo->query("SELECT COUNT(*) as sum FROM code_test");
$code_num_arr = $code_num_rs->fetch(PDO::FETCH_ASSOC);
$code_num = $code_num_arr['sum'];
if($code_num < 1){
sleep(2);
$code = get_code(6);
var_dump( $pdo->query("INSERT INTO code_test (code,create_time) VALUES ('$code',".time().")") );
}
flock($fp,LOCK_UN);
fclose($fp);
}

Lock the process through flock function.

Run again

cb -c 100 -n 100 http://localhost/php_mulit.php

Only one record is added to the database, ensuring that the data is correct under concurrent conditions.

Related recommendations:

In-depth exploration of whether php will continue to execute after the browser exits

#Example of php implementing online address book

Comparison of examples of how PHP can efficiently read large files

The above is the detailed content of PHP implements concurrent snap-up function through locking. For more information, please follow other related articles on the PHP Chinese website!