Update MongoDB field using value of another field in PHP

Question

In MongoDB PHP, is it possible to update the value of a field using the value from another field?

The below Mongo Shell Command is working fine. Value of a field "product_name" is updating to the field "product_name_copy".

db.products.update(
  {},
  [{ $set: {
    "product_name_copy": "$product_name"
  }}],
  { multi: true }
)

But, While Am using this code in PHP, PHP code :

$where = array();
$update = array('$set' => array("product_name_copy" => "$product_name"));
$options = array("multi" => true);
$bulkWrite = new MongoDB\Driver\BulkWrite;
$bulkWrite->update($where,$update,$options);
$updated    = $mongo->executeBulkWrite("$db_name.products", $bulkWrite);

Am getting this error

Notice: Undefined variable: product_name in C:\xampp\htdocs\mongo\mongo-update.php on line 10

If I used single quotes instead of double quotes,

$update = array('$set' => array("product_name_copy" => '$product_name'));

the same value $product_name is updating to the field "product_name_copy" like below.

{
        "_id" : ObjectId("602a291f0406011059006c15"),
        "product_id" : 15,
        "product_name" : "Test Product",
        "product_name_copy" : "$product_name"
}

Anyone know the solution for this problem.?

Nagaraj Juro · Accepted Answer · 2021-09-02 12:24:31Z

2

Finally I found the solution.

We need to put '$set' array into another one array for field value update.

PHP Code :

$where = array();
$update = array(array('$set' => array("product_name_copy" => '$product_name')));
$options = array("multi" => true);
$bulkWrite = new MongoDB\Driver\BulkWrite;
$bulkWrite->update($where,$update,$options);
$updated    = $mongo->executeBulkWrite("$db_name.products", $bulkWrite);

Output of the above code is

{
        "_id" : ObjectId("602a291f0406011059006c15"),
        "product_id" : 15,
        "product_name" : "Test Product",
        "product_name_copy" : "Test Product"
}

This is what I exactly wanted.

answered Sep 2, 2021 at 12:24

Nagaraj Juro

10911 bronze badges

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

2 Comments

Muneer Over a year ago

I tried this method and it is producing an error complaining wrong type array ` BSON field 'update.updates.u' is the wrong type 'array', expected type 'object', type: MongoDB\Driver\Exception\BulkWriteException`

Nagaraj Juro Over a year ago

Can you share your code for clear understanding of your issue.?

Collectives™ on Stack Overflow

Update MongoDB field using value of another field in PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related