Search code examples
phpmysqlmysqliprepared-statementauto-increment

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

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.

Solution

  • 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.