Collection::getOne
Get one document
Description
public Document mysql_xdevapi\Collection::getOne(string $id
)
This is a shortcut for:
Collection.find("_id = :id").bind("id", id).execute().fetchOne();
Parameters
-
id
-
The document _id in the collection.
Return Values
The collection object, or null
if the _id does not match a document.
Examples
Example #1 mysql_xdevapi\Collection::getOne 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": "Alfred", "age": 42, "job": "Butler"}')->execute();
// A unique _id is (by default, and recommended) generated by MySQL Server
// This retrieves the generated _id's; only one in this example, so $ids[0]
$ids = $result->getGeneratedIds();
$alfreds_id = $ids[0];
// ...
print_r($alfreds_id);
print_r($collection->getOne($alfreds_id));
?>
The above example will output
something similar to:
00005b6b536100000000000000b1
Array
(
[_id] => 00005b6b536100000000000000b1
[age] => 42
[job] => Butler
[name] => Alfred
)