作者ireullin (raison detre)
看板PHP
標題[請益] codeigniter 跨資料庫查詢
時間Tue Jun 25 16:06:35 2013
請問一下各位
codeigniter 要如何跨資料庫查詢
我已經按照手冊
在在設定檔中加一個新的連線資訊account
然後在程式碼中使用
$db_account = $this->load->database('account'，TRUE);
$query = "SELECT DISTINCT * FROM `items` ORDER BY TYPE DESC ";
return $db_account->query( $query );
畫面完全跑不出來
連錯誤訊息也沒有
也試過將 pconnect 設為 FALSE
但是都不行
請問我有那裡遺漏了嗎
我的版本是 codeigniter 2.1.3
以下是我的設定檔內容
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'letmedie';
$db['default']['database'] = 'work';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$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['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
$db['account']['hostname'] = 'localhost';
$db['account']['username'] = 'root';
$db['account']['password'] = 'letmedie';
$db['account']['database'] = 'account';
$db['account']['dbdriver'] = 'mysql';
$db['account']['dbprefix'] = '';
$db['account']['pconnect'] = FALSE;
$db['account']['db_debug'] = TRUE;
$db['account']['cache_on'] = FALSE;
$db['account']['cachedir'] = '';
$db['account']['char_set'] = 'utf8';
$db['account']['dbcollat'] = 'utf8_general_ci';
$db['account']['swap_pre'] = '';
$db['account']['autoinit'] = TRUE;
$db['account']['stricton'] = FALSE;
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 219.84.62.191
1F：→ buganini:有echo嗎 06/25 22:30
2F：→ poi987poi987:資料庫可以`account`.`item` , 何必在開一各連線 06/25 23:57
3F：→ poi987poi987:設DB可以讓你預設不用打前面的account 06/25 23:58
4F：→ fri13:是不是錯誤跑到log檔去了？ 06/26 00:20
5F：推 marcoyan:$link_acc = $this->load->database('account'); 06/27 07:23
6F：→ marcoyan:不好意思看錯問題orz 06/27 07:23