It should be noted that using mysqli_stmt->insert_id will not result in a unique ID being returned for each execution of a prepared insert statement. In practice, it appears that the first insertion ID is returned. If you are performing multiple inserts with the same prepared statement (one invocation of mysqli_stmt::prepare and multiple invocations of mysqli_stmt::execute() for a given statement), and need to keep the unique ID for each insert, use mysqli_connection->insert_id.
PHP - Manual: mysqli_stmt::$insert_id
2024-11-23
mysqli_stmt::$insert_id
mysqli_stmt_insert_id
(PHP 5, PHP 7, PHP 8)
mysqli_stmt::$insert_id -- mysqli_stmt_insert_id — Get the ID generated from the previous INSERT operation
add a note
User Contributed Notes 2 notes
hgernhardt at tcnewengland dot org ¶
11 years ago
Aurelien Marchand ¶
7 years ago
for those with zerofilled IDs beware as mysqli_stmt::$insert_id will return an integer. In other words, if the ID returned from your query was #000099, the value produced by mysqli_stmt::$insert_id is now #99.
I have not found a way to fix this beside using sprintf('%06d',$id) but this assumes you know in advance the size of the ID beforehand.
官方地址：https://www.php.net/manual/en/mysqli-stmt.insert-id.php
IT
PHP
编程语言
Linux
开发编程
科技
Elasticsearch
HTML/CSS/XML
网络
JAVA
NoSQL
数据库
面试
C/C++
Golang
Git
算法
操作系统
正则表达式
Redis
互联网
MySql
JavaScript
运维
软件
国际
架构设计
Mac OS
TCP/IP
Excel
Vim
Windows
Socket
Oracle
VR
MongoDB
Python
运营
MemCache
商业
硬件
电子
娱乐
设计
nginx
摄影
游戏
WordPress
HTTP
团建
数码电器
广告
--
php7 安装fileinfo扩展
preg_split — 通过一个正则表达式分隔字符串
php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题
[PHP] inet_pton/inet_ntop IP地址转换函数
array_multisort() 多字段排序
PHPMailer设置utf8 PHPMailer字符集CharSet
ADORecordSet对象
[鸟哥]PHP_INT_MIN 和 -9223372036854775808
PHP 8.1
adodb手册
opcache预加载
Composer的Packagist资源
mysql面试题
php扩展开发
支持php7的性能采集扩展
PHP7 mcrypt替代方案
Packagist / Composer 中国全量镜像
PHP mkdir()写出来的权限与mode值不符合
php上周一、本周一、下周一日期
php设置cookie为httponly防止xss攻击