php8.5
Home/ Manual/ mysql_xdevapi / collection/ Collection::__construct

Collection::__construct

PHP function Edit on GitHub ✎

Collection constructor

Description

mysql_xdevapi\Collection::__construct()

Construct a Collection object.

Parameters Parameters

Examples

mysql_xdevapi\Collection::getOne() example

php
<?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:

output
00005b6b536100000000000000b1

Array
(
    [_id] => 00005b6b536100000000000000b1
    [age] => 42
    [job] => Butler
    [name] => Alfred
)

Source: reference/mysql_xdevapi/mysql_xdevapi/collection/construct.xml · from the official PHP manual (php/doc-en)