doumei8126 2013-05-26 23:28
浏览 48
已采纳

PHP MySQL - 如何在没有第二个查询的情况下获取最后一个Insert语句的结果的id?

How do I obtain the id of the result of the last Insert statement without a second query?

I am aware I could select the last row of the database to get what I'm looking for... sometimes. The issue is if two users are inserting at the same time I'm worried that they may get the wrong results.

Pseudo Example Code:

User 1 - Insert Record A
User 1 - Select last Record
User 1 - Record A Selected

Pseudo Multi-user Problem:

User 1 - Insert Record A
User 2 - Insert Record B
User 1 - Select last Record
**User 1 - Record B Selected**
User 2 - Select last Record
User 2 - Record B Selected
  • 写回答

2条回答 默认 最新

  • duanli0453 2013-05-28 12:12
    关注

    The problem does not occur, when the users use different connections. That should always be the case on different requests. But even within the same script, utilizing different connections, ensures the separation.

    Prove:

    $connection_for_user1 = new MySQLi('localhost', 'user', 'pass', 'test');
    $connection_for_user2 = new MySQLi('localhost', 'user', 'pass', 'test');
    
    $result_for_user1 = $connection_for_user1->query("INSERT INTO test_table (data) VALUES ('A')");
    $result_for_user2 = $connection_for_user2->query("INSERT INTO test_table (data) VALUES ('B')");
    
    $record_id_for_user1 = $connection_for_user1->insert_id;
    $record_id_for_user2 = $connection_for_user2->insert_id;
    
    echo "User 1: record $record_id_for_user1
    ";
    echo "User 2: record $record_id_for_user2
    ";
    

    Result:

    User 1: record 1
    User 2: record 2
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥50 汇编语言除法溢出问题
  • ¥65 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波