CODEWITHSUNDEEP
phpcodeigniter
Thomas Makos
Thomas Makos

Reputation: 1686

Access database config variables from a helper in Codeigniter

Is it possible to get the database.php variables values from a helper in Codeigniter?

Upvotes: 14

Views: 24849

Answers (3)

Abel Callejo
Abel Callejo

Reputation: 14929

My easiest fix was

include_once APPPATH . 'config/database.php';
echo json_encode($db); // contains all the database configurations

Upvotes: 1

Muhammad Usman
Muhammad Usman

Reputation: 12503

Here is the way, normally you won't be able to use $this in helper, so you have to use get_instance(). I have given an example of 'hostname' you can use the config name you need.

   function test()
    {
        $CI =& get_instance();
        $CI->load->database();
        echo $CI->db->hostname; // give the config name here (hostname).
    }

Upvotes: 30

Tobias
Tobias

Reputation: 491

$ci=& get_instance();
$ci->config->load('database');
$ci->config->item('item name');

If you want to access the config file for the database when $this->config->load(); is not available, the solution could look like this: 

include(APPPATH.'config/database'.EXT);
$conn = mysql_connect($db['default']['hostname'], $db['default']['username'], $db['default']['password']);

mysql_select_db($db['default']['database'], $conn);

Upvotes: 11

Related Questions