Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 247.6Kb
HTML Download (Zip) - 255.3Kb


MySQL PHP API  /  ...  /  Collection::existsInDatabase

5.7.7 Collection::existsInDatabase

Copyright 1997-2020 the PHP Documentation Group.

  • Collection::existsInDatabase

    Check if collection exists in database

Description

public bool mysql_xdevapi\Collection::existsInDatabase();

Checks if the Collection object refers to a collection in the database (schema).

Parameters

This function has no parameters.

Return Values

Returns TRUE if collection exists in the database, else FALSE if it does not.

A table defined with two columns (doc and _id) is considered a collection, and a third _json_schema column as of MySQL 8.0.21. Adding an additional column means existsInDatabase() will no longer see it as a collection.

Examples

Example 5.17 mysql_xdevapi\Collection::existsInDatabase 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");
$create = $schema->createCollection("people");

// ...

$collection = $schema->getCollection("people");

// ...

if (!$collection->existsInDatabase()) {
    echo "The collection no longer exists in the database named addressbook. What happened?";
}
?>