How to update MySQL db from two associative array in php

Question

I received two associative array and I want to update it's values in mysql db. So, I did this:

// for all other contacts
if(isset($_POST['otherAddress']) || isset($_POST['otherComments']))
{
    $otherAddress = $_POST['otherAddress'];
    $otherComments = $_POST['otherComments'];

    foreach (array_keys($otherAddress + $otherComments) as $key) 
    {
        $query = "UPDATE `boardcontacts` SET
        `address`='$otherAddress[$key]',`comments`='$otherComments[$key]'
        WHERE `memberID` = '$nID' AND `addressType`='other'";

        mysql_query($query);
    } // for end
} // if end

Problem is: It duplicate all updated rows with the last index of each array. Any help ?

can you please show your $otherAddress and $otherComments array . It will help us to resolve your problem. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Mar 16, 2015 at 8:38
@Asmaa your entire query emphasize on $nID. But in your query $nID not appear inside the loop. If it vary update unique row. — Navjot Singh
– Navjot Singh, Commented Mar 16, 2015 at 9:54
@anantkumarsingh ex: $otherAddress={@abc,@dfg} $otherAddress={twitter,instegram} — Learner
– Learner, Commented Mar 16, 2015 at 9:55

Ali Arshad · Accepted Answer · 2015-03-16 08:47:48Z

2

Just curious are you updating the value of $nID??
Because if the foreach executes without updating $nID the query will update the values in the same row every time because the where condition is same every time.

answered Mar 16, 2015 at 8:47

Ali Arshad

4362 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Learner Over a year ago

You are write this is the issue, Now my question is how to solve it ?

Ali Arshad Over a year ago

That depends on your logic... from where you want to get the memberID?

Learner Over a year ago

I guess the fastest way is to add a column "contactID" as an auto increment that differentiate each row in boardContact table and pass it along with the $nID will solve the problem ^^

Death-is-the-real-truth Over a year ago

Yes you are correct. But if you clearly post your exact array format of $otherAddress and $otherComments, then your above code will be also modified for desired result.

Learner Over a year ago

Thank You so much your answer is accepted and if you can plz help me here

Collectives™ on Stack Overflow

How to update MySQL db from two associative array in php

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related