CI 使用连接 sql 2008 的写法

Question

database.php 配置

$db['hbpos']['hostname'] = '192.168.1.222'; 
$db['hbpos']['username'] = 'sa';
$db['hbpos']['password'] = 'sa';
$db['hbpos']['database'] = 'testdatabase';
$db['hbpos']['dbdriver'] = 'sqlsrv';
$db['hbpos']['dbprefix'] = 'hsh_';
$db['hbpos']['pconnect'] = TRUE;
$db['hbpos']['db_debug'] = TRUE;
$db['hbpos']['cache_on'] = FALSE;
$db['hbpos']['cachedir'] = '';
$db['hbpos']['char_set'] = 'utf8';
$db['hbpos']['dbcollat'] = 'utf8_general_ci';

不知道在model里面怎么调用？
最要是我这边配置了多个链接信息！

Answer 1

class Your_Model extends MY_Model{

    public function __construct() {
        parent::__construct();
        $this->hbpos_db = $this->load->database('hbpos', true);
    }

    public function getSome($id)
    {
        return $this->hbpos_db->where('id',$id)->get('table')->result();
    }
}