CollectionFind::offset
(No version information available, might only be in Git)
CollectionFind::offset — Skip given number of elements to be returned
Beschreibung
Skip (offset) these number of elements that otherwise would be returned by the find operation. Use with the limit() method.
Defining an offset larger than the result set size results in an empty set.
Parameter-Liste
-
position -
Number of elements to skip for the limit() operation.
Rückgabewerte
A CollectionFind object that can be used for additional processing.
Beispiele
Beispiel #1 mysql_xdevapi\CollectionFind::offset() 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");
$create = $schema->createCollection("people");
$create
->add('{"name": "Alfred", "age": 18, "job": "Butler"}')
->execute();
$create
->add('{"name": "Reginald", "age": 42, "job": "Butler"}')
->execute();
// ...
$collection = $schema->getCollection("people");
$result = $collection
->find()
->sort('age asc')
->offset(1)
->limit(1)
->execute();
var_dump($result->fetchAll());
?>
Das oben gezeigte Beispiel erzeugt eine ähnliche Ausgabe wie:
array(1) {
[0]=>
array(4) {
["_id"]=>
string(28) "00005b6b536100000000000000f3"
["age"]=>
int(42)
["job"]=>
string(6) "Butler"
["name"]=>
string(8) "Reginald"
}
}
Hier Kannst Du einen Kommentar verfassen
Es sind noch keine Kommentare vorhanden.
