MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
Collection::getOne
Get one document
public Document mysql_xdevapi\Collection::getOne(string id);
Fetches one document from the collection.
This is a shortcut for: Collection.find("_id =
:id").bind("id", id).execute().fetchOne();
id
The document _id in the collection.
The collection object, or null
if the _id
does not match a document.
Example 5.20 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 )