php – mysqli最后插入的id_php教程

上一篇: php – 在xubuntu中安装pecl_htt... 下一篇:CakePHP如何用条件检索HABTM数据...

php – mysqli最后插入的id

发布时间：2022-04-30 发布网站：脚本宝典

脚本宝典收集整理的这篇文章主要介绍了php – mysqli最后插入的id，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

我想将图像与Firstname,lastname相关联…如何检索最后一行并使用它来插入到其他表？我试过$image = $ mysqli-> insert_id;然后绑定,但它不工作.有人可以帮我吗？

$image = $MysqLi->insert_id;//this should come From table2
 $stmt = $MysqLi->PRepare("
  insert into table1 (username,firstname,lastname,image) 
  select ?,?,image from table2 t2 where username = ? and  t2.id = ? 
   ");
 $stmt->bind_param('sssss',$username,$fname,$lname,$image);
 $stmt->execute();

MysqLi :: $insert_id – MysqLi_insert_id – 返回上次查询中使用的自动生成的ID,示例：

$MysqLi = new MysqLi("localhost","my_user","my_password","world");

/* check connection */
if (MysqLi_connect_errno()) {
    printf("Connect Failed: %s\n",MysqLi_connect_error());
    exIT();
}

$MysqLi->query("CREATE TABLE myCity LIKE City");

$query = "INSERT INTO myCity VALUES (NULL,'Stuttgart','DEU',617000)";
$MysqLi->query($query);

printf ("New Record has id %d.\n",$MysqLi->insert_id);

/* drop table */
$MysqLi->query("DROP TABLE myCity");

/* close connection */
$MysqLi->close();