PHP 8.4.2 Released!

CollectionModify::limit

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

CollectionModify::limitLimit number of modified documents

Опис

public mysql_xdevapi\CollectionModify::limit(int $rows): mysql_xdevapi\CollectionModify

Limit the number of documents modified by this operation. Optionally combine with skip() to define an offset value.

Параметри

rows

The maximum number of documents to modify.

Значення, що повертаються

A CollectionModify object.

Приклади

Приклад #1 mysql_xdevapi\CollectionModify::limit() 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");

$collection->add('{"name": "Fred", "age": 21, "job": "Construction"}')->execute();
$collection->add('{"name": "Wilma", "age": 23, "job": "Teacher"}')->execute();
$collection->add('{"name": "Betty", "age": 24, "job": "Teacher"}')->execute();

$collection
->modify("job = :job")
->
bind(['job' => 'Teacher'])
->
set('job', 'Principal')
->
limit(1)
->
execute();

$result = $collection
->find()
->
execute();

print_r($result->fetchAll());
?>

Поданий вище приклад виведе щось схоже на:

Array
(
    [0] => Array
        (
            [_id] => 00005b6b53610000000000000118
            [age] => 21
            [job] => Construction
            [name] => Fred
        )
    [1] => Array
        (
            [_id] => 00005b6b53610000000000000119
            [age] => 23
            [job] => Principal
            [name] => Wilma
        )
    [2] => Array
        (
            [_id] => 00005b6b5361000000000000011a
            [age] => 24
            [job] => Teacher
            [name] => Betty
        )
)
add a note

User Contributed Notes

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