(No version information available, might only be in Git)
Collection::__construct — Collection constructor
Construct a Collection object.
This function has no parameters.
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 )
Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!
Check out: eBank.nz (Art Generator) |
Netwrck.com (AI Tools) |
Text-Generator.io (AI API) |
BitBank.nz (Crypto AI) |
ReadingTime (Kids Reading) |
RewordGame |
BigMultiplayerChess |
WebFiddle |
How.nz |
Helix AI Assistant