MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
CollectionFind::offset
Skip given number of elements to be returned
public mysql_xdevapi\CollectionFind mysql_xdevapi\CollectionFind::offset(int position);
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.
position
Number of elements to skip for the limit() operation.
A CollectionFind object that can be used for additional processing.
Example 5.38 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()); ?>
The above example will output something similar to:
array(1) { [0]=> array(4) { ["_id"]=> string(28) "00005b6b536100000000000000f3" ["age"]=> int(42) ["job"]=> string(6) "Butler" ["name"]=> string(8) "Reginald" } }