gpt4 book ai didi

php - codeigniter连接两个数据库

转载 作者:行者123 更新时间:2023-12-03 20:37:21 25 4
gpt4 key购买 nike

我使用 codeigniter 2.1.4。我将我的 session 记录到我的 database1,并查询 database2 数据。但是 session 不会找到 database2 表。我不想将 session 记录到 database2

错误信息。

A Database Error Occurred

Error Number: 1146

Table 'database2.sessions' doesn't exist

SELECT * FROM (`sessions`) WHERE `session_id` = 'fd384ac44b1fe1c073cfc23185esdfda' AND `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.76 Safari/537.36'

Filename: libraries/Session.php

Line Number: 213

我的database.php

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'password';
$db['default']['database'] = 'database1';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$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['database2']['hostname'] = 'localhost';
$db['database2']['username'] = 'root';
$db['database2']['password'] = 'password';
$db['database2']['database'] = 'database2';
$db['database2']['dbdriver'] = 'mysql';
$db['database2']['dbprefix'] = '';
$db['database2']['pconnect'] = TRUE;
$db['database2']['db_debug'] = TRUE;
$db['database2']['cache_on'] = FALSE;
$db['database2']['cachedir'] = '';
$db['database2']['char_set'] = 'utf8';
$db['database2']['dbcollat'] = 'utf8_general_ci';
$db['database2']['swap_pre'] = '';
$db['database2']['autoinit'] = FALSE;
$db['database2']['stricton'] = FALSE;

我的config.php

$config['sess_cookie_name']     = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_expire_on_close'] = FALSE;
$config['sess_encrypt_cookie'] = TRUE;
$config['sess_use_database'] = TRUE;
$config['sess_table_name'] = 'sessions';
$config['sess_match_ip'] = FALSE;
$config['sess_match_useragent'] = TRUE;
$config['sess_time_to_update'] = 300;

那是我的查询database2代码。

  function ip_get($ip) {
$db_rentcar = $this->load->database('rent_car', TRUE);
$db_rentcar->from('ip');
$db_rentcar->where('ip_ip', $ip);
if($db_rentcar->count_all_results() == 1) {
$query = $db_rentcar->get_where('ip', array('ip_ip' => $ip));
return $query->row_array();
} else {
return array('ip_name' => 'user1', 'ip_type' => 1);
}
}

我尝试将此代码添加到 Session.php

$this->CI->load->database('database1', TRUE);

错误变成。如何解决问题?谢谢。

An Error Was Encountered

You have specified an invalid database connection group.

最佳答案

您的事件数据库是您在 database.php 中最后定义的最后一个要连接下一个,请手动连接它,或者如果您始终需要连接,请将其放在 My_Controller 中。

$this->db2 = $this->CI->load->database('db2', TRUE);  

供您引用,了解更多详情 here

关于php - codeigniter连接两个数据库,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/19063324/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com