MySQL\u3067ON DUPLICATE KEY UPDATE\u53e5\u6307\u5b9a\u3057\u3001\u30c7\u30fc\u30bf\u306e\u767b\u9332\u30fb\u66f4\u65b0\u3057\u305f\u5f8c\u306b\u300c$mysqli->insert_id\u300d\u3067ID\u3092\u53d6\u5f97\u3059\u308b\u3068\u7d50\u679c\u304c0\u306b\u306a\u308b\u3068\u3044\u3046\u30b1\u30fc\u30b9\u304c\u3042\u3063\u305f\u3002\u6bce\u56de\u306a\u308b\u308f\u3051\u3067\u306f\u306a\u304f\u540c\u3058\u30c7\u30fc\u30bf\u3092\u307b\u307c\u540c\u6642\u306b\u767b\u9332\u30fb\u66f4\u65b0\u3057\u305f\u969b\u306b\u767a\u751f\u3057\u3066\u3044\u308b\u3063\u307d\u3044\u3002\u4ee5\u4e0b\u306b\u539f\u56e0\u3068\u5bfe\u5fdc\u7b56\u3092\u30e1\u30e2\u3002<\/p>\n
<\/p>\n
\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u7528\u610f\u3057\u305f\u3002id\u306b\u4e3b\u30ad\u30fc\u3092\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u3002<\/p>\n
+----+-----------+-------+---------------------+---------------------+\r\n| id | name | point | regist_ymd | update_ymd |\r\n+----+-----------+-------+---------------------+---------------------+\r\n| 1 | \u9234\u6728 | 100 | 2023-11-02 18:00:54 | 2023-11-02\u00a018:00:54 |\r\n| 2 | \u5c71\u7530 | 50 | 2023-11-02 18:01:05 | 2023-11-02\u00a018:01:05 |\r\n| 3 | \u4f50\u3005\u6728 | 70 | 2023-11-02 18:01:22 | 2023-11-02\u00a018:01:22 |\r\n+----+-----------+-------+---------------------+---------------------+<\/pre>\n<\/p>\n
\u73fe\u8c61<\/h2>\n
$sql = '\r\n INSERT INTO `test_table` \r\n (\r\n `id`,\r\n `name`, \r\n `point`, \r\n `regist_ymd`, \r\n `update_ymd` \r\n ) \r\n VALUES\r\n (\r\n 2,\r\n \"\u9234\u6728\",\r\n 1000,\r\n now(), \r\n now() \r\n )\r\n ON DUPLICATE KEY UPDATE\r\n `name` = \"\u9234\u6728\u7de8\u96c6\", \r\n `point` = 2000, \r\n `update_ymd` = now()\r\n';\r\n\r\n$row = $mysqli->query($sql);\r\n$id = $mysqli->insert_id;\r\n\r\nvar_dump($id);\r\n#int(2)\u304c\u51fa\u529b\u3055\u308c\u308b\r\n\r\n$row = $mysqli->query($sql);\r\n$id = $mysqli->insert_id;\r\n\r\nvar_dump($id);\r\n#int(0)\u304c\u51fa\u529b\u3055\u308c\u308b<\/pre>\n\u611f\u899a\u7684\u306b\u306f2\u56de\u76ee\u306evar_dump\u30672\u304c\u51fa\u529b\u3055\u308c\u305d\u3046\u306a\u306e\u306b0\u304c\u51fa\u529b\u3055\u308c\u305f\u3002<\/p>\n
<\/p>\n
\u539f\u56e0<\/h2>\n
\u4ee5\u4e0b\u8a18\u4e8b\u3092\u898b\u305f\u611f\u3058\u30c7\u30fc\u30bf\u306e\u767b\u9332\u30fb\u66f4\u65b0\u304c\u7121\u3044\u5834\u5408\u3001\u3053\u306e\u3088\u3046\u306a\u6319\u52d5\u306b\u306a\u308b\u3063\u307d\u3044\u3002<\/p>\n
https:\/\/stackoverflow.com\/questions\/25195902\/php-mysqli-insert-id-0-after-insert-or-update-should-i-read-first<\/a><\/p>\n