How to access DB config in CodeIgniter?

Question

In my application, I need to know what values are assigned to the DB config items such as database, username, etc. How do I access those information?

Answer 1

I don't have enough rep to comment on Matt Browne's correct answer but just adding a bit incase anyone forgets...

load the db driver like so first:

$this->load->database();

then you can easily access what you need:

$this->db->hostname
$this->db->username
$this->db->password
$this->db->database

Answer 2

Pretty much all the config values are accessible via $this->db (take a look at system/database/DB_driver.php).

That's what worked for me...none of the other suggestions here did.

As an example

$config = [ 
     'host'     => $this->db->hostname,
     'port'     => '3306',
     'username' => $this->db->username,
     'password' => $this->db->password,
     'database' => $this->db->database
];

Answer 3

In case you have multiple database connection groups defined in config/database.php, for eg :

  $db['dbname']['hostname'] = "localhost";
  $db['dbname']['username'] = "root";
  $db['dbname']['password'] = "root";
  $db['dbname']['database'] = "web_dbname";

  $db['dbname_readonly']['hostname'] = "localhost";
  $db['dbname_readonly']['username'] = "root";
  $db['dbname_readonly']['password'] = "root";
  $db['dbname_readonly']['database'] = "web_dbname_readonly";

If you want to use the connection params of any particular db in a controller or model:

  $db = $this->load->database('dbname');

If you want to use in a helper or library :

  $ci = &get_instance();
  $db = $ci->load->database('dbname');

The connection params will be available as $db->hostname, $db->username etc.