Update of MongoDB document (php code example)-MongoDB-php.cn

Update of MongoDB document (php code example)

齐天大圣

Release： 2020-08-24 18:02:10

Original

2334 people have browsed it

MongoDB update documents are divided into two categories:

Document replacement, completely replace the old document with the new document
Modifier, Modify some documents

Document replacement

Using document replacement is very simple, let’s take a look at the demonstration:

$collect->insertOne([&#39;name&#39; => &#39;lakers&#39;, &#39;nums&#39;=> 16]);
$collect->replaceOne(
    [&#39;name&#39;=>&#39;lakers&#39;], 
    [&#39;name&#39; => &#39;heat&#39;, &#39;nums&#39;=>3]
);

Copy after login

Use modifiers to complete more complex update operations, such as modifying, adding, or deleting keys.

"$set" modifier

"$set" is used to specify the value of a field. If this field does not exist, create it.

$collect->insertOne([
    &#39;name&#39; => &#39;james&#39;,
    &#39;age&#39; => 35,
]);

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$set&#39; => [&#39;fruit&#39; => &#39;apple&#39;]]
);
// fruit字段不存在，则会创建该字段

Copy after login

If you don’t like apple now and want to change to strawberry

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$set&#39; => [&#39;fruit&#39; => &#39;strawberry&#39;]]
);

Copy after login

"$set" can also modify the key type.

# 不止喜欢草莓，还喜欢梨子、香蕉。
$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$set&#39; =>
        [&#39;fruit&#39; => 
            [&#39;strawberry&#39;, &#39;banana&#39;, &#39;pear&#39;] 
        ]
    ]
);

Copy after login

"$set" can also modify embedded documents

$collect->insertOne([
    &#39;name&#39; => &#39;james&#39;,
    &#39;age&#39; => 35,
    &#39;brothers&#39; => [&#39;name&#39; => &#39;wade&#39;, &#39;age&#39;=> 38]
]);

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$set&#39; =>
        [&#39;brothers.name&#39; => &#39;paul&#39;]
    ]
);

Copy after login

"$unset"Modifier

Use" The $unset" modifier can delete the specified field

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$unset&#39; =>
        [&#39;brothers&#39; => &#39;&#39;]
    ]
);

Copy after login

"$inc" modifier, increase or decrease the value

and "$set" Like the modifier, if the field does not exist, it will be automatically created. Note: This field value can only be numbers.

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$inc&#39; =>
        [&#39;scores&#39; => 61]
    ]
);
## 现有积分61

Copy after login

Now, 10 points have been obtained.

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
    [&#39;$inc&#39; =>
        [&#39;scores&#39; => 10]
    ]
);
## 现有积分71

Copy after login

Later, 50 points were used

$collect->updateOne([&#39;name&#39;=>&#39;james&#39;],
     [&#39;$inc&#39; =>[&#39;scores&#39; => -50]
 ] ); 
 ## 现有积分21

Copy after login

Array Modifier

MongoDB provides special modifications for arrays method.

"$push" adds elements

"$push" can add elements to the array. If the array does not exist, it will automatically Create an array. There is now a document used to save article data:

$collect->insertOne([
     &#39;_id&#39; => 1,      
     &#39;title&#39;=>&#39;study mongodb&#39;,      
     &#39;create_time&#39; => &#39;2020-08-24 12 :31&#39; 
]); 
$push = [&#39;$push&#39; => [&#39;comments&#39; => &#39;comments1&#39;] ]; 
$collect->updateOne([&#39;_id&#39; => 1 ], $push);

Copy after login

"$each" adds multiple elements

'$push' can be an array at once Element, if you want to add multiple elements at once, you need to use '$each' together.

$push = [    
     &#39;$push&#39; => 
         [&#39;comments&#39; => 
             [&#39;$each&#39; => [&#39;comment1&#39;, &#39;comment2&#39;, &#39;comment3&#39;]]
         ] 
      ]; 
$collect->updateOne([&#39;_id&#39; => 1 ], $push);

Copy after login

"$slice" retains n elements

'$push' is used together with '$slicet' to retain the latest n elements Data, the value of '$slice' can only be negative integers. For example, I only want to keep the latest 3 comments:

# 目前数据如下
 > db.users.find() 
{ "_id" : 1, "title" : "study mongodb", "create_time" : "2020-08-24 12:31", "comment" : [ "comment1", "comment2", "comment3", "comment4", "comment5", "comment6" ] }

Copy after login

$push = [
     &#39;$push&#39; => [ 
        &#39;comment&#39; => [ 
            &#39;$each&#39; => [&#39;comment7&#39;, &#39;comment8&#39;, &#39;comment9&#39;],                                &#39;$slice&#39; => -3 
        ],
     ], 
]; 
$collect->updateOne([&#39;_id&#39; => 1 ], $push);

Copy after login

# 现数据如下 
db.users.find() 
{ "_id" : 1, "title" : "study mongodb", "create_time" : "2020-08-24 12:31", "comment" : [ "comment7", "comment8", "comment9" ] }

Copy after login

"$sort" sorting

can also be used with '$sort' , keep the 3 comments with the most likes.

# 目前是集合内是空的，么有任何文档
$collect->insertOne([&#39;_id&#39; => 1, &#39;title&#39;=>&#39;study mongodb&#39;, &#39;create_time&#39; => &#39;2020-08-24 12:31&#39;]);
$push = [
    &#39;$push&#39; => [
        &#39;comment&#39; => [
            &#39;$each&#39; => [
                [&#39;comment&#39; => &#39;php&#39;, &#39;like&#39; => 100], 
                [&#39;comment&#39; => &#39;mysql&#39;, &#39;like&#39; => 10], 
                [&#39;comment&#39; => &#39;linux&#39;, &#39;like&#39; => 200], 
                [&#39;comment&#39; => &#39;java&#39;, &#39;like&#39; => 1000], 
                [&#39;comment&#39; => &#39;nginx&#39;, &#39;like&#39; => 300], 
                [&#39;comment&#39; => &#39;composer&#39;, &#39;like&#39; => 500], 
            ],
            &#39;$slice&#39; => -3,
            &#39;$sort&#39; => [&#39;like&#39; => 1]
        ],
    ],
];

Copy after login

Let’s take a look at what the data in the collection looks like:

> db.users.find()
{ "_id" : 1, "title" : "study mongodb", "create_time" : "2020-08-24 12:31", "comment" : [ { "comment" : "nginx", "like" : 300 }, { "comment" : "composer", "like" : 500 }, { "comment" : "java", "like" : 1000 } ] }

Copy after login

Note that you cannot only use "$slice" or "$sort" with "$push", and you must Use "$each".

"$addToSet" avoids inserting duplicate data

When using "$addToSet" to add new array elements, you can avoid adding duplicates Data, such as

$collect->insertOne([
    &#39;_id&#39; => 1,
    &#39;name&#39; => &#39;gwx&#39;, 
    &#39;age&#39; => 30, 
    &#39;fruits&#39; => [&#39;apple&#39;, &#39;pear&#39;]
]);

$update = [
    &#39;$addToSet&#39; => [
        &#39;fruits&#39; => &#39;apple&#39;
    ]
];

Copy after login

, the above modification will not succeed because apple already exists. '$addToSet' can also be used with "$each" to insert multiple array elements.

$update = [
    &#39;$addToSet&#39; => [
        &#39;fruits&#39; => [
            &#39;$each&#39; => [&#39;apple&#39;, &#39;banana&#39;, &#39;orange&#39;]
        ]
    ]
];
$collect->updateOne([&#39;_id&#39; => 1], $update);

Copy after login

Delete elements

You can delete the leftmost or rightmost element through "$pop".

$collect->insertOne([
    &#39;_id&#39; => 1,
    &#39;name&#39; => &#39;gwx&#39;, 
    &#39;age&#39; => 30, 
    &#39;fruits&#39; => [&#39;apple&#39;, &#39;pear&#39;]
]);

#从数组末删除1个元素
$update = [
    &#39;$pop&#39; => [
        &#39;fruits&#39; => 1
    ]
];
$collect->updateOne([&#39;_id&#39; => 1], $update);

# 从数组头删除一个元素
$update = [
    &#39;$pop&#39; => [
        &#39;fruits&#39; => -1
    ]
];
$collect->updateOne([&#39;_id&#39; => 1], $update);

Copy after login

You can also delete the specified element through '$pull'

$collect->insertOne([
    &#39;_id&#39; => 1,
    &#39;name&#39; => &#39;gwx&#39;, 
    &#39;age&#39; => 30, 
    &#39;fruits&#39; => [&#39;apple&#39;, &#39;pear&#39;, &#39;apple&#39;, &#39;banana&#39;, &#39;orange&#39;]
]);

#从数组末删除
$update = [
    &#39;$pull&#39; => [
        &#39;fruits&#39; => &#39;apple&#39;
    ]
];

Copy after login

All apple elements in the array have been deleted

upsert

upsert is a special kind of update. But if a set that meets the conditions is found, it will be the same as the previous modification. If a collection that meets the conditions is not found, it will be inserted into the collection as a new document using the query conditions and the modified document.

Below, take a scenario we often encounter as an example - recording the number of times each IP is viewed. If it is a new IP, it is added to the collection. If it already exists, the original collection is modified.

$collect->updateOne([&#39;ip&#39; => &#39;116.31.23.1&#39;], [
    &#39;$inc&#39; =>[
        &#39;views&#39; => 1
    ]
], [&#39;upsert&#39; => true]);

$collect->updateOne([&#39;ip&#39; => &#39;127.0.0.1&#39;], [
    &#39;$inc&#39; =>[
        &#39;views&#39; => 1
    ]
], [&#39;upsert&#39; => true]);


$collect->updateOne([&#39;ip&#39; => &#39;116.31.23.1&#39;], [
    &#39;$inc&#39; =>[
        &#39;views&#39; => 1
    ]
], [&#39;upsert&#39; => true]);

Copy after login

> db.users.find()
{ "_id" : ObjectId("5f4336f3a95f1a505db9a2df"), "ip" : "116.31.23.1", "views" : 2 }
{ "_id" : ObjectId("5f4336f3a95f1a505db9a2e1"), "ip" : "127.0.0.1", "views" : 1 }

Copy after login

Update multiple documents

Updating multiple documents requires the use of the updateMany() method, as demonstrated below:

$collect->insertMany([
    [&#39;name&#39; => &#39;gwx&#39;, &#39;age&#39; => 30],
    [&#39;name&#39; => &#39;gwx&#39;, &#39;age&#39; => 30],
    [&#39;name&#39; => &#39;gwx&#39;, &#39;age&#39; => 30],
]);

$collect->updateMany([
    &#39;name&#39; => &#39;gwx&#39;
],
    [&#39;$set&#39; =>[&#39;age&#39; => 18]]
);

Copy after login

The above is the detailed content of Update of MongoDB document (php code example). For more information, please follow other related articles on the PHP Chinese website!