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


MySQL PHP API  /  ...  /  Table::existsInDatabase

5.31.4 Table::existsInDatabase

Copyright 1997-2019 the PHP Documentation Group.

  • Table::existsInDatabase

    Check if table exists in database

Description

public bool mysql_xdevapi\Table::existsInDatabase();

Verifies if this table exists in the database.

Parameters

This function has no parameters.

Return Values

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

Examples

Example 5.155 mysql_xdevapi\Table::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();
$session->sql("CREATE TABLE addressbook.names(name text, age int)")->execute();
$session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();

$schema = $session->getSchema("addressbook");
$table  = $schema->getTable("names");

if ($table->existsInDatabase()) {
  echo "Yes, this table still exists in the session's schema.";
}
?>

The above example will output something similar to:

Yes, this table still exists in the session's schema.