recover BD name of a mysql and php connection

Question

Good make the connection in my mysql so:

$mysqli = mysqli_connect('127.0.0.1', 'root', '123', 'teste');

I want to know how I can recover the name of the database through the variable that receives the connection '$mysqli'.

It is possible to do this?

Answer 1

Run an SQL select database() to return the Mysql database name, for example:

mysql> select database();
+--------------------+
| database()         |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)

mysql> 

Answer 2

Well the solution was this one:

$mysqli = mysqli_connect($ip_bd_mysql, $login_bd_mysql, $senha_bd_mysql, "CIDADES");


$result = $mysqli->query("SELECT DATABASE()");
$row = $result->fetch_row();
printf($row[0]);