为什么我CI2.2读不出SQLITE3的表数据啊
本帖最后由 qzzm 于 2015-3-3 12:41 编辑能链接上Sqlite 但是读表中的内容读不出 我表是有两条数据的 不是空表，请问大神是什么原因造成呢？
如果是配置成mysql 同样的表结构是可以读出数据的，sqlite就不行
相关代码如下
配置
$active_group = 'sqlite';
$active_record = TRUE;
$db['sqlite']['hostname'] = 'sqlite:' . FCPATH. 'qzzm\database\db.php';
$db['sqlite']['username'] = '';
$db['sqlite']['password'] = '';
$db['sqlite']['database'] = '';
$db['sqlite']['dbdriver'] = 'pdo';
$db['sqlite']['dbprefix'] = 'dt_';
$db['sqlite']['pconnect'] = TRUE;
$db['sqlite']['db_debug'] = TRUE;
$db['sqlite']['cache_on'] = FALSE;
$db['sqlite']['cachedir'] = '';
$db['sqlite']['char_set'] = 'utf8';
$db['sqlite']['dbcollat'] = 'utf8_general_ci';
$db['sqlite']['swap_pre'] = '';
$db['sqlite']['autoinit'] = TRUE;
$db['sqlite']['stricton'] = FALSE;
controllers\welcome.php中相关
public function index() {
$this->load->database();
$data = $this->db->select('*')->get('user');
echo '<pre>';
var_dump($this->db->last_query());
echo '<pre>';
var_dump($data);
echo '<pre>';
var_dump($data->result_array());
}
页面输出
string(21) "SELECT *
FROM dt_user"
object(CI_DB_pdo_result)#18 (8) {
["num_rows"]=>
int(0)
["conn_id"]=>
object(PDO)#14 (0) {
}
["result_id"]=>
object(PDOStatement)#17 (1) {
["queryString"]=>
string(21) "SELECT *
FROM dt_user"
}
["result_array"]=>
array(0) {
}
["result_object"]=>
array(0) {
}
["custom_result_object"]=>
array(0) {
}
["current_row"]=>
int(0)
["row_data"]=>
NULL
}
array(0) {
}
页:
[1]