How to query if database exists in php-PHP Problem-php.cn

How to query if database exists in php

藏色散人

Release： 2023-03-06 12:20:01

Original

4829 people have browsed it

How to query whether the database exists in php: 1. Use PDO to determine whether the database exists; 2. Use SQL statements to determine whether the database exists.

How to query if database exists in php

Recommended: "PHP Video Tutorial"

PHP determines whether the database exists

1. Two methods to determine whether the database exists:

1. Use PDO to determine whether the database exists

2. Use SQL statements to determine

2. Method 1 executes the code as follows:

//$config[&#39;dsn&#39;]的表示如下
$config["dsn"] => string(65) "mysql:host=127.0.0.1;port=3306;charset=utf8"
//$config[&#39;username&#39;]为数据库用户名， $config[&#39;password&#39;]：数据库密码

Copy after login

function isDBExist($config)
{
    $config[&#39;dsn&#39;] = $this->parseDsn($config);//转换组为DSN字符串
 
    $conn = new PDO($config[&#39;dsn&#39;], $config[&#39;username&#39;], $config[&#39;password&#39;]);
    // 设置 PDO 错误模式为异常
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "show databases;";
    // 使用 exec() ，因为没有结果返回
    $res = $conn->query($sql);
    $res = $res->fetchAll(PDO::FETCH_ASSOC);
    $database_list = [];
    foreach($res as $k => $v) {
        $database_list[] = $v[&#39;Database&#39;];
    }
    if (in_array($config[&#39;database&#39;],$database_list)) {
        return true; // 存在
    } else {
        return false;
    }
}
2. 方法二执行代码如下：
//$config[&#39;username&#39;]为数据库用户名

Copy after login

function isDBExist($config)
{
       try {
 
            $rs = Db::execute("use ".$db_config["database"]);
        }catch (Exception $e)
        {
            return false;//不存在
        }
        return true;
}

Copy after login

The above is the detailed content of How to query if database exists in php. For more information, please follow other related articles on the PHP Chinese website!