PDO最后插入ID总是正确的吗? [英] PDO Last Insert ID always the right one?

问题描述

我有以下代码:

<?
$query =$db->prepare("INSERT INTO a_table (id, a_field) VALUES ('', (:a_field)");
$query->bindParam(":a_field", $a_value);
$query->execute();
$last_id = $db->lastInsertId('a_table');
?>

我想问的是这个.想象一下，当两个人完全同时加载页面时，是否有可能在检索最后一个ID之前将另一个人的查询插入，从而混淆了ID?

What I want to ask is this. Imagine when two people load the page at exactly the same time, is it a possible danger that the other persons query is inserted before the last ID is retrieved, mixing up the IDs?

推荐答案

否，这种情况是不可能的. 方法$ db-> lastInsertId()返回此DB连接的最后插入的ID.在其他页面中将是另一个连接和另一个最后插入的ID.

No, this situation is impossible. Method $db->lastInsertId() returns last inserted id for this DB conection. In other page will be another connection and another last inserted id.

这篇关于PDO最后插入ID总是正确的吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！