Array Comparison and inserting unique value in PHP MySQL

Question

I Have an array with all the id's in my MySQL DB. In second array, have ID's which I need to insert into the same table. I need to check if the Id's which I am going to insert are present in first array or not and then insert it into the DB.

Help me out in finding the unique values.

why don't you refer php.net http://php.net/manual/en/function.array-diff.php — shanavascet, Jul 11 '13 at 10:41

score 0 · Answer 1 · edited May 23 '17 at 10:32

0

If the ids are PKs, you can use insert on duplicate update (here is a stack question that might help you; unrelated, but for syntax) On duplicate key ignore?.

edited May 23 '17 at 10:32

Community

1
1

answered Jul 11 '13 at 10:42

zozo

8,230
19
79
134

score 0 · Accepted Answer · answered Jul 11 '13 at 10:43

0

Use array_intersect() function to find out whether two arrays satisfy your conditions and then make a decision whether data can be inserted to DB

answered Jul 11 '13 at 10:43

Trogvar

856
6
17

Array Comparison and inserting unique value in PHP MySQL

2 Answers2