codeigniter多库

来源：互联网发布：dateformat java 编辑：程序博客网时间：2024/05/22 14:54

$this->load->model('test_model','','soul_1');

$active_group = 'soul_1';$active_record = TRUE;$db['soul_1']['hostname'] = 'localhost';$db['soul_1']['username'] = 'root';$db['soul_1']['password'] = '123456';$db['soul_1']['database'] = '';$db['soul_1']['dbdriver'] = 'mysql';$db['soul_1']['dbprefix'] = '';$db['soul_1']['pconnect'] = TRUE;$db['soul_1']['db_debug'] = TRUE;$db['soul_1']['cache_on'] = FALSE;$db['soul_1']['cachedir'] = '';$db['soul_1']['char_set'] = 'utf8';$db['soul_1']['dbcollat'] = 'utf8_general_ci';$db['soul_1']['swap_pre'] = '';$db['soul_1']['autoinit'] = TRUE;$db['soul_1']['stricton'] = FALSE;

第一中是group

第二种是官方手册上的

$config['hostname'] = "localhost";$config['username'] = "root";$config['password'] = "123456";$config['database'] = "";$config['dbdriver'] = "mysql";$config['dbprefix'] = "";$config['pconnect'] = FALSE;$config['db_debug'] = TRUE;

$this->load->model('testtwo_model','',$config);

public function index(){$DB1=$this->load->database('default',TRUE);$query=$DB1->query("SELECT * FROM  `uc_admins` LIMIT 0 , 10");$data['db']=$query->result_array();//$query=$this->db->query("SELECT * FROM  `uc_admins` LIMIT 0 , 10");//$data['db']=$query->result_array();/*$DB2=$this->load->database('soul_1',TRUE);$query=$DB2->query("SELECT * FROM  `dili_admins` LIMIT 0 , 30");$data['dbtwo']=$query->result_array();*/$this->load->model('test_model','','soul_1');$data['dbtwo']=$this->test_model->get_user();if (file_exists(APPPATH."data/db_config".EXT)){include_once APPPATH."data/db_config".EXT;$this->load->model('testtwo_model','',$config);$data['type']=$this->testtwo_model->get_admintype();}$this->load->view('welcome_message',$data);}