Skip to main content
Home

connect 2 database

February 16, 2010 by cah_ajus

cah_ajus's picture

gmn caranya mengkoneksikan dua database di CI??
sbenernya aku dpet tutornya,disini:
http://codeigniter.com/user_guide/database/connecting.html
tapi msh bingung...ada yg bisa jelasin ngk??tolong bangedd...lagi butuh bwt skripsi.....

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

hiksz2..tdk ada

February 17, 2010 by cah_ajus, 1 year 12 weeks ago
Comment: 5929

cah_ajus's picture

hiksz2..tdk ada bantuan......stlh aku googling2....aku dapet tutor ini, smoga bisa membantu bagi kalian yg punya masalah dgn multiple db di CI

http://jedidiahreeser.com/blog/2009/07/accessing-multiple-databases-code...

Hahahaa... tanya tapi jawab

February 20, 2010 by mul14, 1 year 11 weeks ago
Comment: 5948

mul14's picture

Hahahaa... tanya tapi jawab sendiri... :D
btw link nya nggak bisa dibuka Bandwidth Limit Exceeded

Sebenernya udah ada info nya di file application/config/database.php

heehheee...abisnya tdk ad yg

February 20, 2010 by cah_ajus, 1 year 11 weeks ago
Comment: 5950

cah_ajus's picture

heehheee...abisnya tdk ad yg respons...pdhl aq lg bth bgt.....,
sbnernya di userguide-nya jg dh ad sh....,tp ane kagak ngerti
di link yg pertama aku kasih itu, lbh mudah diresapi coz berupa pidio...iya sh aku cba skr linknya udah ngk bisa lg......untung kemaren pas lg bth bisa...,hehehee

mau donk di share bos... ane

February 21, 2010 by luckymahrus, 1 year 11 weeks ago
Comment: 5953

luckymahrus's picture

mau donk di share bos... ane buka jg dah ga bs.. makasih..

pertama kamu buka pengaturan

February 22, 2010 by cah_ajus, 1 year 11 weeks ago
Comment: 5954

cah_ajus's picture

pertama kamu buka pengaturan database yg di system/app/config
temukan file berikut:
$active_group = "default";
$active_record = TRUE;
//kamu copy paste bagian ini,letakkan dibawahnya saja,spt cth saia,trus ganti nama default dan database yg diinginkan //
$db['default']['hostname'] = "localhost";
$db['default']['username'] = "root";
$db['default']['password'] = "";
$db['default']['database'] = "laboratorium";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
//.................//
$db['second_db']['hostname'] = "localhost";
$db['second_db']['username'] = "root";
$db['second_db']['password'] = "";
$db['second_db']['database'] = "kampus";
$db['second_db']['dbdriver'] = "mysql";
$db['second_db']['dbprefix'] = "";
$db['second_db']['pconnect'] = TRUE;
$db['second_db']['db_debug'] = TRUE;
$db['second_db']['cache_on'] = FALSE;
$db['second_db']['cachedir'] = "";
$db['second_db']['char_set'] = "utf8";
$db['second_db']['dbcollat'] = "utf8_general_ci";

trus contoh cara manggilnya di model seperti ini:
$this->second_db=$this->load->database('second_db',TRUE);
$this->second_db->where('nim', $nim);
$query = $this->second_db->getwhere('krs');
return $query;

smga bisa membantu broo..,

bagaimana kalau nama database nya berdasarkan isi variabel??

March 4, 2010 by ferrypey, 1 year 10 weeks ago
Comment: 6187

ferrypey's picture

saya punya kendala dengan di CI untuk koneksi ke beberapa DB dlm satu aplikasi.
bagaimana kalau nama database nya berdasarkan isi variabel??
saya punya beberapa DB dmn untuk konek ke salah satu DB sesuai dengan pilihan dari user??

thanks..

Premium Drupal Themes by Adaptivethemes