Php: getting database name from mysli native class

Question

i created a wrapper class for mysqli with the following syntax:

class mydb extends mysqli { .... } 

I create instances such as:

 $conn = new mydb($host $username , $pass, $dbname); 

I am wondering - how can I access $dbname from inside the class? I am looking for the mysqli equivalent for the mysql_db_name() function.

Answer 1

You can always create your own class with a field variable with reference to the mysqli object and the database name.

 class MyDatabase { public $dbi; public $dbname; function __construct($host, $user, $pass, $db) { $this->dbi = new mysqli($host, $user, $pass, $db); $this->dbname = $db; } } $mydb = new MyDatabase($host, $user, $pass, $db); //Access db name that was stored during connection echo $mydb->dbname; 

Answer 2

You can use this SQL query from your own class:

 SELECT database() AS the_db 

This should show you the database you selected.