SqLite3的驱动自主修改（不需要pdo）1.0.0

clarkso

基于近来需要用php连接sqlite3，搞了很久，PDO不行，sqlite版本更不行，所以自己写了这个：
使用范围：php 5.3以上版本
使用方法：放在\system\database\drivers下解压到本目录
修改config下的database.php：
$db['sqlite3']['hostname'] = '';
$db['sqlite3']['username'] = '';
$db['sqlite3']['password'] = '';
$db['sqlite3']['database'] = APPPATH.'db/sqlite3demo.sqlite';
$db['sqlite3']['dbdriver'] = 'sqlite3';
$db['sqlite3']['dbprefix'] = '';
$db['sqlite3']['pconnect'] = TRUE;
$db['sqlite3']['db_debug'] = TRUE;
$db['sqlite3']['cache_on'] = FALSE;
$db['sqlite3']['cachedir'] = '';
$db['sqlite3']['char_set'] = 'utf8';
$db['sqlite3']['dbcollat'] = 'utf8_general_ci';
$db['sqlite3']['swap_pre'] = '';
$db['sqlite3']['autoinit'] = TRUE;
$db['sqlite3']['stricton'] = FALSE;
完成！
如有疑问，与我联系：clarkso@qq.com

~[tthread=aq927927, 阿Q]http://app.qlogo.cn/mbloghead/5220faf75d8681d4982a[/tthread]

jinlongxx

居然加了try...catch进行异常处理，我还高兴了一下，结果只有两段用了，不过楼主真的辛苦了，谢谢分享，到目前为止，还正常使用。有点委屈的是我把PHP升到了5.3，又忙了好一会。非非常感谢楼主咯。

love.zy

报如下错误，求解答！

A PHP Error was encountered

Severity: Warning

Message: sqlite_last_error() expects parameter 1 to be resource, object given

Filename: sqlite3/sqlite3_driver.php

Line Number: 455
A PHP Error was encountered

Severity: Warning

Message: sqlite_last_error() expects parameter 1 to be resource, object given

Filename: sqlite3/sqlite3_driver.php

Line Number: 442
A Database Error Occurred

Error Number:

not an error

SELECT b.title,b.author,b.category_id,c.category,b.content,b.reg_date FROM t_blog b,t_category c WHERE b.category_id=c.sort_no AND b.del_flag = false AND c.del_flag = false ORDER BY reg_date DESC limit 10

Filename: D:\php\phpBlog\phpsrc\system\database\DB_driver.php

Line Number: 330

clarkso

love.zy 发表于 2013-3-2 12:57
**** 作者被禁止或删除 内容自动屏蔽 ****

缺少一个参数，不过估计现在ci自己官方已经支持了