MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
CollectionModify::set
Set document attribute
public mysql_xdevapi\CollectionModify mysql_xdevapi\CollectionModify::set(string collection_field,
string expression_or_literal);Sets or updates attributes on documents in a collection.
collection_field
The document path (name) of the item to set.
expression_or_literal
The value to set it to.
A CollectionModify object.
Example 5.48 mysql_xdevapi\CollectionModify::set
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'])
->set("name", "Bern")
->execute();
$result = $collection
->find()
->execute();
print_r($result->fetchAll());
?>
The above example will output something similar to:
Array
(
[0] => Array
(
[_id] => 00005b6b53610000000000000111
[name] => Bern
[traits] => Array
(
[0] => Friend
[1] => Brother
[2] => Human
)
)
)