MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
Schema::getCollections
Get all schema collections
public array mysql_xdevapi\Schema::getCollections();Fetch a list of collections for this schema.
This function has no parameters.
Array of all collections in this schema, where each array element value is a Collection object with the collection name as the key.
Example 5.105 mysql_xdevapi\Schema::getCollections
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");
$collect = $schema->createCollection("people");
$collect->add('{"name": "Fred", "age": 21, "job": "Construction"}')->execute();
$collect->add('{"name": "Wilma", "age": 23, "job": "Teacher"}')->execute();
$collections = $schema->getCollections();
var_dump($collections);
?>
The above example will output something similar to:
array(1) {
["people"]=>
object(mysql_xdevapi\Collection)#4 (1) {
["name"]=>
string(6) "people"
}
}