作者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