[請益] codeigniter 跨資料庫查詢

看板PHP作者ireullin (raison detre)時間12年前 (2013/06/25 16:06)推噓1(1推 0噓 5→)

留言6則, 4人參與討論串1/1

請問一下各位 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