PHP MySQLi insert ids from multi_query()

Question

Is there a way to get the last generated auto_increment IDs after inserting several rows with mysqli multi_query function?

EDIT:

I managed to get it work by adding SELECT LAST_INSERT_ID(); after each INSERT query in the multi query and then use the mysqli_use_result to get all ids, and I think this is the best way.

Answer 1

If you can't, you can have a new column created which is DATETIME. Simply set its value to NOW().

Then you can get the last inserted rows by doing

SELECT MAX(`created`) AS `last_inserted_id`
  FROM `your_table` 

Of course, MAX(id) will probably also work, but it is a bit hacky, and I do not recommend doing it that way.

Update

If you wanted the last 3 inserted rows, something like this would work.

  SELECT `id`
    FROM `your_table`
ORDER BY `created` DESC
   LIMIT 3