双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒,抽取你的专属好礼

— 惊喜奖品抢先看 —

CI2.2.6 加载sqlite 能够链接,但是就是查不出表内数据,怎么回事

bighoneybadger bighoneybadger 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
--------------------------------------------------------------------sqlite 链接配置----------------------------------------------------------------------
$db['sqlite_db']['hostname'] = "sqlite:".realpath(FCPATH . '/db/prov_city.sqlite');
$db['sqlite_db']['username'] = '';
$db['sqlite_db']['password'] = '';
$db['sqlite_db']['database'] = '';
$db['sqlite_db']['dbdriver'] = 'pdo' ;
$db['sqlite_db']['dbprefix'] = '';
$db['sqlite_db']['pconnect'] = TRUE;
$db['sqlite_db']['db_debug'] = TRUE;
$db['sqlite_db']['cache_on'] = FALSE;
$db['sqlite_db']['cachedir'] = '';
$db['sqlite_db']['char_set'] = 'utf8';
$db['sqlite_db']['dbcollat'] = 'utf8_general_ci';
$db['sqlite_db']['swap_pre'] = '';
$db['sqlite_db']['autoinit'] = TRUE;
$db['sqlite_db']['stricton'] = FALSE;
--------------------------------------------------------------------数据查询-------------------------------------
$db = $this->load->database('sqlite_db', TRUE);
$a=$db->query("select * from T_City ");
print_r($a);
------------------------输出结果------------------------------
CI_DB_pdo_result Object
(
[num_rows] => 0
[conn_id] => PDO Object
( )
[result_id] => PDOStatement Object
(
[queryString] => select * from T_City
)
[result_array] => Array
( )
[result_object] => Array
( )
[custom_result_object] => Array
( )

[current_row] => 0
[row_data] =>
)
--------------------------------------------------------------------加入输入错误的表名称 数据查询-------------------------------------
$db = $this->load->database('sqlite_db', TRUE);
$a=$db->query("select * from T_City333 "); //表T_City333 不存在
print_r($a);
会提示数据库错误,表不存在。
...全文
评论
收藏 已收藏
分享
返回顶部
bighoneybadger
Framework 4,250 成员 4,522 内容