Code Igniter

[emailroy2002]

Connecting to Multiple Databases

If you need to connect to more than one database simultaneously you can do so as follows:
$DB1 = $this->load->database('group_one', TRUE);
$DB2 = $this->load->database('group_two', TRUE);

Note: Change the words "group_one" and "group_two" to the specific group names you are connecting to (or you can pass the connection values as indicated above).

By setting the second parameter to TRUE (boolean) the function will return the database object.

When you connect this way, you will use your object name to issue commands rather than the syntax used throughout this guide. In other words, rather than issuing commands with:

$this->db->query();
$this->db->result();
etc...

You will instead use:

$DB1->query();
$DB1->result();
etc...

[emailroy2002]

Note: By setting the second parameter to TRUE (boolean) the function will return the database object.

Maon ni imong paramter kulang bro...

test lang....

cheers...!!!

[emailroy2002]

please check this! multiple database connection bug report from code igniter...


Bug Report - Multiple Databases Query | Bug Tracker | CodeIgniter

cheers!

[kimbou]

In CI, you can use this in your model "SELECT colA, colB FROM db.table1 tb1, db2.table2 tb2"

The unpopular posts:Articles and blog on practical approaches to web and supporting technologies.

[autumn]

bago ra ko nkadownload ug code igniter.. ingon sila nice daw au ni ug gusto ka mubuhat ug website. kaya lang galisod man ko ug unsaon paggamit sa code igniter. nisulay nko ug basa ug user guide pero dili man gud ko programmer jud so mao to wala au to nkatabang nko.. pwede patabang? salamat

[carmicael]

bago ra ko nkadownload ug code igniter.. ingon sila nice daw au ni ug gusto ka mubuhat ug website. kaya lang galisod man ko ug unsaon paggamit sa code igniter. nisulay nko ug basa ug user guide pero dili man gud ko programmer jud so mao to wala au to nkatabang nko.. pwede patabang? salamat

unless you know PHP(and/or SQL+Apache), you won't be able to use CI. have you configured Apache(or PHP)? have you installed CI using the instructions on the user guide? there are a lot of possibilities as to why you can't use CI yet.

"CodeIgniter is a powerful PHP framework with a very small footprint, built for PHP coders who need a simple and elegant toolkit to create full-featured web applications. If you're a developer who lives in the real world of shared hosting accounts and clients with deadlines, and if you're tired of ponderously large and thoroughly undocumented frameworks"

at least have a background on PHP, and webservers.

hope this helps.

cheers.