Login

08-21-2013, 05:24 AM

[eluser]Katie1348[/eluser]
[quote author="darjap" date="1376071100"]Hi!

I tried to use this code, since i have to do a similar thing with my application, but i have a problem - when i use the database connection outside the module i have created it, it doesnt work - error: Severity: Notice Message: Undefined variable: CI

I would be really thankful for any help!

Code:
public function connect_company()

    {

     $config = array();

     $config['hostname'] = "localhost";

 $config['username'] = "company1";

 $config['password'] = "password";

 $config['database'] = "company1";

 $config['dbdriver'] = "mysql";

 $config['dbprefix'] = "";

 $config['pconnect'] = TRUE;

 $config['db_debug'] = TRUE;

 $config['cache_on'] = FALSE;

 $config['cachedir'] = "";

 $config['char_set'] = "utf8";

 $config['dbcollat'] = "utf8_general_ci";

 $CI =& get_instance();

 $CI->company_db = $CI->load->database($config, TRUE);

 $CI->company_db =& $CI->company_db;

 return TRUE;

    }

Simple usage of the database from another/same module - it works when it is in the same module, does not, when it is in another:

Code:
$query = $this->company_db->get('clients');

 foreach ($query->result() as $row)

 {

  echo $row->client_name;

 }

[/quote]

I think you might have an error in your code.

Code:
$CI->company_db =& $CI->company_db;

I think it should read

Code:
$this->company_db =& $CI->company_db;

That should as far as I can see fix your problem and let you use the company_db method of accessing the database connection etc.

Good luck.

kate