MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
CollectionModify::replace
Replace document field
public mysql_xdevapi\CollectionModify mysql_xdevapi\CollectionModify::replace(string collection_field,
string expression_or_literal);
Replace (update) a given field value with a new one.
collection_field
The document path of the item to set.
expression_or_literal
The value to set on the specified attribute.
A CollectionModify object.
Example 5.47 mysql_xdevapi\CollectionModify::replace
example
<?php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost"); $session->sql("DROP DATABASE IF EXISTS addressbook")->execute(); $session->sql("CREATE DATABASE addressbook")->execute(); $schema = $session->getSchema("addressbook"); $collection = $schema->createCollection("people"); $result = $collection ->add( '{"name": "Bernie", "traits": ["Friend", "Brother", "Human"]}') ->execute(); $collection ->modify("name = :name") ->bind(['name' => 'Bernie']) ->replace("name", "Bern") ->execute(); $result = $collection ->find() ->execute(); print_r($result->fetchAll()); ?>
The above example will output something similar to:
Array ( [0] => Array ( [_id] => 00005b6b5361000000000000011b [name] => Bern [traits] => Array ( [0] => Friend [1] => Brother [2] => Human ) ) )