CODEWITHSUNDEEP
phparraysmongodbmongodb-query
dgcoder
dgcoder

Reputation: 95

How to replace an element in an array

I have a COLLECTION collflokks in MongoDB, sample Document is :-

{   
    "_id" : "b_8AUL",   
    "f_name" : "Pizza. Hut",   
    "f_lat" : "22.7523513",   
    "f_lng" : "75.9225847",   
    "c_uid" : "33",   
    "f_type" : NumberLong(3),   
    "members" : [     
        "42",     
        "43"   
    ]   
}

Within the "members" array , I want to add Arrays like {id:42,name:Mark} , {id:43,name:Hughes} Currently i'm adding just ids(eg.42,43). I'm only concerned about the new data as it will have new ids .Please suggest.

Earlier I was using this code to push into the members Array:

$flokkCollection = 'collFlokks';
$flokkCollection->update(
       array("_id" => $f_handle), 
       array('$push' => array("members" => $u_id))
);

Upvotes: 1

Views: 220

Answers (1)

Blakes Seven
Blakes Seven

Reputation: 50406

Well if what you are asking here is "replacing your existing data" then you need to "loop" the results from the collection and "replace" the array content that exists with your new format.

There are likely smarter ways to approach this, but you are not really giving us all the required information in your question, so I can only answer in the basic terms.

Presuming you have:

$required = array(
   array(array("id" => "42"), array("name" => "Mark")),
   array(array("id" => "43"), array("name" => "Hughes"))
);

As input, then you do something like this:

function myMapper($v) {
    return $v["id"];
}

$mapped = array_map("myMapper",$required);

foreach( $mapped as $value) {

    $filtered = array_values(
        array_filter($required,function($k) {
            return $k["id"] == $value;
        })
    )[0];

    collection.update(array(
        array("members" => $value),
        array('$set' => array( 
            "members.$" => $filtered
        ))
    ));
}

Which should use the positional $ operator to find the matched "position" of the array element by the value used in the "query" portion of the update statement, then in the "update" portion of that statement $set that current array index to the new value at the "filtered" content index from the original input array.

Outside of PHP. We call these inner elements "objects" and not "arrays" which is a PHP notation trait. Key/value things are "objects" and "lists" are "arrays".

Upvotes: 1

Related Questions