multiple database connectivity - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: multiple database connectivity (/showthread.php?tid=22094) |
multiple database connectivity - El Forum - 08-29-2009 [eluser]ranjitbd[/eluser] $DB1 = $this->load->database('holidaydb', TRUE); //where i have to add this line (within model class constructor) //and what i will write in the config/database.php file after the following line $db['default']['database'] = "tmartdb"; $DB1['database'] = "holidaydb"; //is it correct or $DB1['default']['database'] = "holidaydb";//this one is correct //$DB1 is it case sensitive //how i will get the data from that database $this->$DB1->query(); //is it correct? $DB1->query(); //is it correct? multiple database connectivity - El Forum - 08-29-2009 [eluser]ranjitbd[/eluser] [quote author="ranjitbd" date="1251561993"]$DB1 = $this->load->database('holidaydb', TRUE); //where i have to add this line (within model class constructor) //and what i will write in the config/database.php file after the following line $db['default']['database'] = "tmartdb"; $DB1['database'] = "holidaydb"; //is it correct or $DB1['default']['database'] = "holidaydb";//this one is correct //$DB1 is it case sensitive //how i will get the data from that database $this->$DB1->query(); //is it correct? $DB1->query(); //is it correct?[/quote] //config/autoload.php $autoload['core'] = array(database); //this line should be enabled for miltiple database.isn't it? multiple database connectivity - El Forum - 08-31-2009 [eluser]ranjitbd[/eluser] i followed the manual but but its not working |