PHP PDO - 如何检查数据库是否创建成功?(MS SQL Server） - PHP PDO - How to check if database created successfully ? (MS SQL Server)

PHP PDO - How to check if database created successfully ? (MS SQL Server)

我正在执行一个创建数据库的查询。我想检查查询是否成功。数据库是 sql 服务器。提前感谢您的帮助...

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

创建后，您可以使用SELECT DATABASES LIKE 'database_name'当结果包含一个条目时，您就知道它已创建。

示例代码：

$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
}

try {
    $dbh->exec("CREATE DATABASE some_name;");
   } catch (PDOException $e) {
    $e.getMessage();
}

或者你可以做一些类似的事情

if($db->query("CREATE DATABASE some_name")){
     echo "database created";
}else{
     echo "there was a problem creating database";
}