How to obtain the last inserted auto increment id using PDO library?

Question

I have a table that of course has a unique id for each entry.

How can I retrieve that id when I do a simple insert using this query string:

"INSERT INTO lion_is_foob (id_user, title, url, domain, tag, favicon) VALUES (?, ?, ?, ?, ?, ?)"

The column name is called id for the auto increment.

Because an insert so commonly creates an auto ID can I retrieve this at the same time.

http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html — Cortright, Jun 13 '13 at 22:01
Do you want to retrieve the ID of the inserted row? Or the next available auto-incremented ID? — showdev, Jun 13 '13 at 22:03
What exactly is the question? Are you asking for getting the last inserted id, for example? — Lion, Jun 13 '13 at 22:05

score 1 · Accepted Answer · answered Jun 13 '13 at 22:03

1

Look at http://php.net/mysql_insert_id or http://php.net/mysqli_insert_id (depending on which set of MySQL functions you're using).

answered Jun 13 '13 at 22:03

Jan Krüger

Really? Yours is two function calls, mine is one. ;) – Jan Krüger Jun 13 '13 at 22:08
1

it's always two, you have to do the insert and you have to pull the id, you can't do both at once. – Jun 13 '13 at 22:14
It's three with the variant you suggested (in the comment you deleted): insert, select the last insert ID, fetch result of that. – Jan Krüger Jun 13 '13 at 22:21
I don't know PDO very well, but it probably has its own variation on `mysqli_insert_id`. – Jan Krüger Jun 13 '13 at 22:24
... snap ... that was in the duplicate. – Jun 14 '13 at 17:11

1 Answers1