PHP PDO - 如何检查数据库是否成功创建？ （MS SQL Server）

Question

I am executing a query that creates a database. I want to check if the query was successfull. The database is sql server. Thank you in advance for your help...

 $dbh = new \PDO("sqlsrv:Server=.\SQLEXPRESS;", "login", "password");
 $dbh = $dbh->exec("CREATE DATABASE some_name;");

Answer 1

After creation, you can look use SELECT DATABASES LIKE 'database_name' When the result contains one entry, you know it has been created.

Example code:

$dbh = new \PDO("sqlsrv:Server=.\SQLEXPRESS;", "login", "password");
$dbh->exec("CREATE DATABASE some_name;");
$db_check = $dbh->query("SHOW DATABSES LIKE 'some_name'");

if ($db_check->rowCount() > 0) {
  // CREATED 
} else {
  // NOT CREATED
}