How to get id of just-executed sql query (in php)

Question

In php I have an INSERT query to database. This query add some issue to database. I want to check if issue was added fine (there are some cases when issue doesn't added - without any mistake reporting). How to check this?

I have an idea, that after i make INSERT query i should make a query, for example: SELECT ..... WHERE id=last_id. But how to get the last_id - how to get id of last INSERT query? (id is autoincrementing sql field)

Thank you

Which database (MySQL / SQL / PostgreSQL / SQLite / etc.)? And what functions are you using? — Wrikken, Apr 03 '11 at 20:12
possible duplicate of [SQL - INSERT and catch the id auto-increment value](http://stackoverflow.com/questions/621369/sql-insert-and-catch-the-id-auto-increment-value) — Maerlyn, Apr 03 '11 at 20:27
Thanks to everybody. I've found and answer in that topic. Sorry for duplicate — Larry Foobar, Apr 03 '11 at 20:39

score 5 · Answer 1 · answered Apr 03 '11 at 20:12

5

mysql_insert_id();

answered Apr 03 '11 at 20:12

bensiu

24,660
56
77
117

score 2 · Answer 2 · answered Apr 03 '11 at 20:12

2

mysql_insert_id()

More info at http://php.net/manual/en/function.mysql-insert-id.php and http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html

answered Apr 03 '11 at 20:12

Sameer Parwani

309
1
7

score 2 · Accepted Answer · edited May 23 '17 at 12:26

2

You may find the answer to this StackOverflow question useful:

SQL - INSERT and catch the id auto-increment value

edited May 23 '17 at 12:26

Community

1
1

answered Apr 03 '11 at 20:17

Tim

1,344
1
11
12

Thank you. Sorry for duplicate question. I've used search but it was uneffective. I found answer there – Larry Foobar Apr 03 '11 at 20:38

score 1 · Answer 4 · answered Apr 03 '11 at 20:14

1

mysql_insert_id function returns id of previously inserted record.

I assume you're working with MySQL

answered Apr 03 '11 at 20:14

Piotr Ratajczak

296
1
3

How to get id of just-executed sql query (in php)

4 Answers4