Last Insert ID?

Question

Last Insert ID?

ritziyap opened this issue 5 years ago · 2 comments

ritziyap commented 5 years ago

Anyone knows how to get the LAST INSERT ID?

Answer 1 · 2020-03-10T18:47:52.000Z

$db->getPdo()->lastInsertId()

Answer 2 · 2020-03-15T09:21:15.000Z

You can short-circuit this by just saying $db->lastInsertId().

Alternatively, you can use insertGet() to select the auto-generated value for a given column at insert time in one API call. (Some database drivers don't support lastInsertId() correctly.)