0

I'm writing a plugin where I need to save data in custom tables, function hits an API and then saves data for which I need bulk insert, but as wpdb doesn't support it out of the box I made a function for it using prepare and query.

But query doesn't return inserted row IDs. How can I get them? Any other way or anything besides using wpdb?

Improve this question

1 Answer 1

Reset to default
0

As described here:

If you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only. The reason for this is to make it possible to reproduce easily the same INSERT statement against some other server.

So if you need every inserted ID you should use single $wpdb->insert commands, then you have the ID available for each with $wpdb->insert_id. Docs here: https://codex.wordpress.org/Function_Reference/wpdb_Class#INSERT_row

If you insert many rows with a single query you can't get all the inserted ID's, unless you e.g. wanted to re-query for them if you are sure you can identify those rows uniquely.

Improve this answer
3
  • yes, I know that already, thing is single inserts impact database more as opposed to bulk inserts, and I will have multiple tables with datasets to insert so I can't rely on that, as it might break. Commented Jun 15, 2020 at 11:24
  • @ateebahmed you can't have it both ways ;-) so if you want to do a bulk insert then you need to SELECT again to find the ID's Commented Jun 15, 2020 at 11:34
  • yeah thanks, I'm doing it already, wanted to know if I can somehow bypass wpdb itself and call the underlying db class or if php provide any way to get all ids in an array Commented Jun 15, 2020 at 12:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.