[CodeIgniter] 讀取 2 個資料庫

Reference: stack overflow https://stackoverflow.com/questions/8268853/codeigniter-multiple-database-connections#

同時連線2個資料庫

Database 1:

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

Database 2:

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

Use it:

function my_model_method()
{
  $otherdb = $this->load->database('otherdb', TRUE); // the TRUE paramater tells CI that you'd like to return the database object.

  $query = $otherdb->select('first_name, last_name')->get('person');
  var_dump($query);
}

Linux 桌面環境安裝

KDE	minimal:	sudo apt install plasma-desktop
	full:	sudo apt install kubuntu-desktop
Gnome	minimal:	sudo apt install gnome-shell
	full:	sudo apt install ubuntu-gnome-desktop
Cinnamon		sudo add-apt-repository ppa:embrosyn/cinnamon sudo apt update && sudo apt install cinnamon
Xfce	minimal:	sudo apt install xfce4
	full:	sudo apt install xubuntu-desktop
Unity	minimal:	sudo apt install unity
	full:	sudo apt install ubuntu-desktop
MATE	minimal:	sudo apt install mate-desktop-environment
	full:	sudo apt install ubuntu-mate-desktop
LXQt		sudo apt install lxqt
LXDE	minimal:	sudo apt install lxde
	full:	sudo apt install lubuntu-desktop
Enlightenment		sudo add-apt-repository ppa:niko2040/e19 sudo apt update && sudo apt install enlightenment terminology
Budgie		sudo add-apt-repository ppa:budgie-remix/ppa sudo apt update && sudo apt install budgie-desktop