upsert脚本无效

Question

I'm trying to get upsert to work and getting no results

I have three variables I'm posting before this script. If I update, I get result, but I want to upsert and am getting no results.

Here is my code:

if(isset($_POST)){
    if($array){
        $doc = $collection->update(
            array(
                '$set' => array(
                    '_id' => new MongoId(),
                    'organization' => $mysql_org_name,
                    'purch_code' => $mysql_purch_code,
                    'contentname' => $mysql_order_item_name,
                    array('upsert' => true)
                )
            )
        );
    }
}

Answer 1

Update expects 3 argument arrays. You've only passed one.

First, you've included you options as part of the $set array. They should be passed as a separate argument after the update clause.

Also, you don't have a match criteria (i.e., a query statement to select which item(s) to update). When using upsert and $set, a new item would be created with the fields from both arrays(see the relevant documentation).

Finally, if you don't specify a value for _id, Mongo will generate one for you.

---

If, for instance, you wanted to match based on the organization field:

if(isset($_POST)){
    if($array){
        $doc = $collection->update(
            array('organization' => $mysql_org_name),
            array(
                '$set' => array(
                    'purch_code' => $mysql_purch_code,
                    'contentname' => $mysql_order_item_name,
                )
            ),
            array('upsert' => true)
        );
    }
}

If this matches one or more entries, only the purch_code and contentname fields will be updated on the first matching object (to update multiple entries, you'd have to specify 'multiple'=>true in your options array). If nothing matches, a new entry would be inserted with:

1. A generated _id
2. All of the match criteria values (i.e., organization)
3. All of the update operator values (i.e., purch_code and contentname)