php原生操作mysql数据库，使用事务及排他锁

<?php
// 假定数据库用户名：root，密码：123456，数据库：RUNOOB
$con=mysqli_connect("localhost","root","root","saas");
if (mysqli_connect_errno($con))
{
    echo "连接 MySQL 失败: " . mysqli_connect_error();
}
mysqli_query($con,'start transaction');
// 执行查询
$result = mysqli_query($con,"SELECT count(*) as count FROM goods where product_id = 1 for update");
// 获取数据
$res = mysqli_fetch_assoc($result);
$count = $res['count'];
// echo $count;
if($count == 0){
    // file_put_contents("/tmp/log.txt","write",FILE_APPEND);
    mysqli_query($con,"INSERT INTO goods (product_id) VALUES (1)");
}
mysqli_query($con,'commit');//提交事务
mysqli_close($con);
?>

如有问题，可以QQ搜索群1028468525加入群聊，欢迎一起研究技术

有疑问联系站长，请联系QQ：