Get autoincrement id after an insert query performed with a prepared statement

Question

If I execute an insert query with a stored procedure with php and the mysqli_* functions, is there a way to retrieve the value of an autoincrement id field?
mysqli->insert_id does not seem to work.

Answer 1

You could try to make a query to MySql like so:

SELECT LAST_INSERT_ID()

Not sure if it works with stored procedures though.

Answer 2

Are you sure the last query you preformed was an INSERT?

mysqli->insert_id seems the proper answer:

Return Values

The value of the AUTO_INCREMENT field that was updated by the previous query. Returns zero if there was no previous query on the connection or if the query did not update an AUTO_INCREMENT value.

Answer 3

Maybe you can post your table definition.

Or double-check that there is an auto_increment set.

Answer 4

You could add this statement in your stored procedure after the insert:

   SET @saved_id = LAST_INSERT_ID()

Then, execute this query after calling the procedure:

   SELECT @saved_id