dth34653
2014-03-23 18:50 阅读 18
已采纳

mysql_insert_id()返回0

I've looked through the various answers and none of them seem to be helping. I have a simple Insert Query that is working as expected. Nothing special

$user_account_query = mysqli_query($dbc,"
        INSERT INTO ACCOUNT (EMAIL, IS_OPEN)
        VALUES ('$email', 1)")
        or die ('Could not add user: '. mysql_error());

It is successfully inserting the record into my db

enter image description here

I also have an auto-incrementing column in the table being called enter image description here

However, when I call

$message = mysql_insert_id();

I get 0. Does anyone have any advice on how to get the correct ID?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    duanbai1974 duanbai1974 2014-03-23 18:51

    You're mixing up mysql and mysqli

    $message = mysql_insert_id();
    

    should be

    $message = mysqli_insert_id($dbc);
    
    点赞 评论 复制链接分享
  • duanbeng6709 duanbeng6709 2014-04-14 12:19

    Actually you are using myqli Libraray and then you are using other library function mysql_insert_id() you have to use mysqli_insert_id() that is why you getting 0

    点赞 评论 复制链接分享

相关推荐