php - MySQLi 在不指定数据库的情况下连接

Question

我正在使用许多数据库，我想知道是否可以连接 mysqli 并在 : example 之后指定数据库

$mysqli = new mysqli("localhost", "user", "password", "database");
$req = $mysqli->query("SELECT * FROM `table` WHERE id = '1' ");

会变成

$mysqli = new mysqli("localhost", "user", "password");
$req = $mysqli->query("SELECT * FROM `database`.`table` WHERE id = '1' ");

我可以添加 $mysqli->select_db("database"); 但如果有办法使用上面的查询，我想知道该怎么做。谢谢!

Answer 1

是的，其实方法很简单，就这样

$mysqli = new mysqli("localhost", "user", "password");
$res = $mysqli->query("SHOW DATABASES");

while ($row = $res->fetch_assoc()) {
    echo ($results, $row['Database'] . "\n");
}