How do I get the last inserted ID of a MySQL table in PHP

Question

I have a table into which new data is frequently inserted  I need to get the very last ID of the table  How can I do this   Is it similar to SELECT MAX id  FROM table

User · Answer

What you wrote would get you the greatest id assuming they were unique and auto-incremented that would be fine assuming you are okay with inviting concurrency issues.
Since you're using MySQL as your database, there is the specific function LAST_INSERT_ID() which only works on the current connection that did the insert.
PHP offers a specific function for that too called mysql_insert_id.

User · Answer

Clean and Simple -   selectquery  SELECT id FROM tableName ORDER BY id DESC LIMIT 1    result    mysqli- gt query  selectquery    row    result- gt fetch assoc    echo  row  id

User · Answer

To get last inserted id in codeigniter  After executing insert query just use one function called insert id   on database  it will return  last inserted id  Ex    this- gt db- gt insert  mytable   data   echo  this- gt db- gt insert id      returns last inserted id   in one line  echo  this- gt db- gt insert  mytable   data - gt insert id

User · Answer

NOTE  if you do multiple inserts with one statement mysqli  insert id will not be correct    The table   create table xyz  id int 11  auto increment  name varchar 255   primary key id     Now if you do   insert into xyz  name  values  one     two     three      The mysqli  insert id will be 1 not 3    To get the correct value do    mysqli  insert id   mysqli  affected rows  - 1  This has been document but it is a bit obscure

User · Answer

You can get the latest inserted id by the in built php function mysql insert id      id   mysql insert id      you an also get the latest id by   id   last insert id

User · Answer

Using MySQLi transaction I sometimes wasn t able to get mysqli   insert id  because it returned 0  Especially if I was using stored procedures  that executing INSERTs  So there is another way within transaction    lt  php  function getInsertId mysqli  amp  instance   enforceQuery   false       if   enforceQuery return  instance- gt insert id        result    instance- gt query  SELECT LAST INSERT ID            if  instance- gt errno return false       list  buffer     result- gt fetch row          result- gt free         unset  result        return  buffer       gt

User · Answer

I tried mysqli insert id  dbConnectionObj   This returns the current connection s last inserted id  so if you are managing your connections properly this should work  Worked for me at least

User · Answer

It s ok to use mysql insert id    but there is one specific note about using it  you must call it after executed INSERT query  means in the same script session   If you use it otherwise it wouldn t work correctly

User · Answer

It s ok  Also you can use LAST INSERT ID

User · Answer

If you re using PDO  use PDO  lastInsertId   If you re using Mysqli  use mysqli   insert id   If you re still using Mysql      Please  don t use mysql   functions in new code  They are no longer maintained and are officially deprecated  See the red box  Learn about prepared statements instead  and use PDO or MySQLi - this article will help you decide which  If you choose PDO  here is a good tutorial    But if you have to  use mysql insert id

User · Answer

Use mysqli as mysql is depricating    lt  php  mysqli   new mysqli  localhost    yourUsername    yourPassword    yourDB        check connection    if  mysqli connect errno          printf  Connect failed   s n   mysqli connect error         exit         Conside employee table with id name designation  query    INSERT INTO myCity VALUES  NULL   Ram    Developer      mysqli- gt query  query    printf   New Record has id  d  n    mysqli- gt insert id       close connection     mysqli- gt close      gt

User · Answer

With PDO    pdo- gt lastInsertId      With Mysqli    mysqli- gt insert id      Please  don t use mysql   functions in new code  They are no longer maintained and are officially deprecated  See the red box  Learn about prepared statements instead  and use PDO or MySQLi - this article will help you decide which  If you choose PDO  here is a good tutorial

User · Answer

I prefer use a pure MySQL syntax to get last auto increment id of the table I want   php mysql insert id   and mysql last insert id   give only last transaction ID   If you want last auto incremented ID of any table in your schema  not only last transaction one   you can use this query  SELECT AUTO INCREMENT FROM information schema TABLES     WHERE TABLE SCHEMA    my database       AND TABLE NAME    my table name     That s it

User · Answer

there is a function to know what was the last id inserted in the current connection  mysql query  INSERT INTO FOO a  VALUES   b        id   mysql insert id      plus using max is a bad idea because it could lead to problems if your code is used at same time in two different sessions   That function is called mysql insert id

User · Answer

It s sad not to see any answers with an example   Using Mysqli   insert id    sql  INSERT INTO table  col1  col2  col3  VALUES  val1  val2  val3     mysqli- gt query  sql    last inserted id  mysqli- gt insert id     returns last ID   Using PDO  lastInsertId    sql  INSERT INTO table  col1  col2  col3  VALUES  val1  val2  val3     database- gt query  sql    last inserted id  database- gt lastInsertId       returns last ID

User · Answer

Try this should work fine    link   mysqli connect  localhost    my user    my password    world      query    INSERT blah blah blah       result   mysqli query  link   query    echo mysqli insert id  link

[php] How do I get the last inserted ID of a MySQL table in PHP?

Examples related to php

Examples related to mysql