doulu4233 2014-02-08 17:39
浏览 20
已采纳

插入空行并获取最后一个id保存在php mysql中?

I have a registration form. If a user starts the form I insert a empty row in my mysql-table and get the last id like that:

$db=startConnection();
$query=" INSERT INTO form  VALUES ()";
$result=$db->query($query)
    or die($db->error);
$id=$db->insert_id;

But now I worry - isn't it possible that two users register at the same time and both get the same $id from the code above? For example, if two people hit the registration form at the same time and both "insert" queries are executed, and afterwards both people will get the same last insert_id?

  • 写回答

1条回答 默认 最新

  • dongzhi4498 2014-02-08 17:42
    关注

    PHP runs on the server and not on the clients side. Therefor once the first user submits the second submit will be executed after the first one has finise

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 delphi webbrowser组件网页下拉菜单自动选择问题
  • ¥15 linux驱动,linux应用,多线程
  • ¥20 我要一个分身加定位两个功能的安卓app
  • ¥15 基于FOC驱动器,如何实现卡丁车下坡无阻力的遛坡的效果
  • ¥15 IAR程序莫名变量多重定义
  • ¥15 (标签-UDP|关键词-client)
  • ¥15 关于库卡officelite无法与虚拟机通讯的问题
  • ¥15 目标检测项目无法读取视频
  • ¥15 GEO datasets中基因芯片数据仅仅提供了normalized signal如何进行差异分析
  • ¥100 求采集电商背景音乐的方法