CollectionModify::set

    (No version information available, might only be in Git)

    CollectionModify::set — Set document attribute

    Description

    public mysql_xdevapi\CollectionModify::set(string $collection_field, string $expression_or_literal): mysql_xdevapi\CollectionModify

    Sets or updates attributes on documents in a collection.

    Parameters

    collection_field

    The document path (name) of the item to set.

    expression_or_literal

    The value to set it to.

    Return Values

    A CollectionModify object.

    Examples

    Example #1 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
                )
        )
)

    Improve This Page

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top