• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database settings for Model

#1
[eluser]Webjema[/eluser]
As you know the Model can has different DB connections and hence other DB settings for these connections.
I need another DB connection for one of my Models. And I want to keep DB settings together in database.php
How can I send DB settings from database.php to Model?

I looked through database classes and found that database.php is being used once and data from that file is not being saved.
I suggest only one method - to include database.php before creating Model.
Do you have any other ideas?

#2
[eluser]InsiteFX[/eluser]
Hi,

First off you need to read the CodeIgniter Users Guide!
You will find almost everything you need there.

But here is the page from the Users Guide.

CodeIgniter Users Guide Database

Enjoy
InsiteFX

#3
[eluser]Webjema[/eluser]
http://ellislab.com/codeigniter/user-gui....html#conn
Do you understand?

#4
[eluser]Webjema[/eluser]
Or I have to go to Model __constructor and call $this->load->database('group_name'); ?

#5
[eluser]InsiteFX[/eluser]
Hi,

you can setup your config database.php like this.

Code:
$active_group = "default";
$active_record = TRUE;

// LOCALHOST SITE DEFAULT.
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "username";
$db['default']['password'] = "password";
$db['default']['database'] = "cms";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_unicode_ci";

// LIVE SITE PRODUCTION.
$db['production']['hostname'] = "localhost";
$db['production']['username'] = "username";
$db['production']['password'] = "password";
$db['production']['database'] = "myotherdatabase";
$db['production']['dbdriver'] = "mysql";
$db['production']['dbprefix'] = "";
$db['production']['pconnect'] = TRUE;
$db['production']['db_debug'] = FALSE;
$db['production']['cache_on'] = FALSE;
$db['production']['cachedir'] = "";
$db['production']['char_set'] = "utf8";
$db['production']['dbcollat'] = "utf8_unicode_ci";

Change production to your other own name then you can load the one you want.

Enjoy
InsiteFX


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.