Retrieve multiple IDs

Question

I have used $mysqli->insert_id;which returned a single ID. How can I retrieve IDs for multiple inserted rows in mysqli. Is there a solution?

Are you doing your INSERTs in a loop? If so, add the returned ID to an array on each iteration of the loop. — foxbeefly, May 25 '15 at 08:57
If you are using loop for inserting data then you can make an array from there only easily — Narendrasingh Sisodia, May 25 '15 at 09:08
@foxbeefly - No, I am not using loop for bulk insertion as I remember reading somewhere it slows down the performance. — Aaron, May 25 '15 at 09:46
Then how are you inserting multiple records? Post code please... — foxbeefly, May 25 '15 at 09:47

score 1 · Answer 1 · edited May 23 '17 at 12:14

1

Use the following query:

SELECT * FROM myTable WHERE myColumn IN ($ids);

Please refer to this answer and its thread for more info on the subject.

EDIT: Misinterpreted the question. @DevLakshman has got the right idea.

edited May 23 '17 at 12:14

Community

1
1

answered May 25 '15 at 08:59

D. Visser

875
2
12
19

Based on the inclusion of `$mysqli->insert_id;` I think @Aaron is trying to get the IDs of the records as they are inserted into the database, not return the records based on know IDs – foxbeefly May 25 '15 at 09:01
I just reread the question and I'm afraid I misinterpreted it. I will edit my answer. – D. Visser May 25 '15 at 09:02

score 0 · Answer 2 · answered May 25 '15 at 09:00

0

Your next ids will be the succession of generated $mysqli->insert_id + the next n (number of inserts rows) as your statement is doing it in one transaction.

answered May 25 '15 at 09:00

Afsar

3,104
2
25
35

what if there are multiple inserts (transactions) happening at the same time? – foxbeefly May 25 '15 at 09:03

score 0 · Answer 3 · answered May 25 '15 at 09:00

0

If you are executing your insert query in loop then get the ids by $mysqli->insert_id; by writing it in loop or if manually writing many queries then write $mysqli->insert_id; correspondingly...

answered May 25 '15 at 09:00

lakshman

656
4
18

Retrieve multiple IDs

3 Answers3