MySQL and PHP

5.7.7 Collection::existsInDatabase

Copyright 1997-2019 the PHP Documentation Group.

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.

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?";
}
?>