<?php
$file="./a.lock";
$fp=fopen($file,'r');
mysql_connect('localhost','root','');
mysql_select_db('test');
if(flock($fp,LOCK_EX))
{
$result=mysql_query('select *from b');
$rst=mysql_fetch_assoc($result);
var_dump($rst);
$cur=(int)$rst['id'];
$cur=$cur%4+1;
$fp2=fopen($cur.'.lock','r');
if(flock($fp2,LOCK_EX))
{
mysql_query("update b set id=$cur");
flock($fp,LOCK_UN);
mysql_query("update a set num=num+1 where id=$cur");
sleep(1);
var_dump($cur);
flock($fp2, LOCK_UN);
}
fclose($fp2);
}
fclose($fp);