codeigniter多库

最新推荐文章于 2024-10-16 15:26:08 发布

森之树

最新推荐文章于 2024-10-16 15:26:08 发布

阅读量551

点赞数

分类专栏： codeigniter 文章标签： database query mysql include db2 function

本文链接：https://blog.csdn.net/li_star/article/details/7690178

版权

codeigniter 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

$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);
	}