PHP + SQLite3

安装、配置PHP5+SQLite3

Posted on 2008-07-21 22:25 analyzer 阅读(930) 评论(1)  编辑 收藏 所属分类: PHP

今天搞PHP5＋SQLite3的组合，结果怎么也搞不出来，老是报
"PHP Fatal error:  Call to undefined function sqlite_open() in i:"AbyssWebServer"htdocs"script"Conn.php on line 46
"
怎么也搞不出来，我基本崩溃了在php.ini里调了半天，结果PHP的错越报越大，越报越多
"PHP Warning:  PHP Startup: Unable to load dynamic library './php_sqlite.dll' - 找不到指定的模块。"
"PHP Warning:  PHP Startup: Unable to load dynamic library 'I:/AbyssWebServer/php/ext"php_sqlite.dll' - 找不到指定的模块。"
如此这些，突然我看到PHP报了一个错
"PHP Warning:  PHP Startup: Unable to load dynamic library './php_pdo.dll' - 找不到指定的模块。"
觉得奇怪，我没配它啊并发现php/ext文件夹下许多数据库插件都有一个"php_pdo_*.dll"的版本，于是我顺藤摸瓜在网上找啊找，终于被我找到了
http://www.phpe.net/print.php?aid=417
PDO是一个PHP的数据对象抽象层，里面写到“如果想使用PDO就要在php.ini里加入extension=php_pdo.dll”我想刚才也是 报这个错，就试了一下，配置好extension_dir路径再在Windows Extensions列表的第一行加入extension=php_pdo.dll结果都好了，连php_sqlite.dll都可以用了，没想到 php_sqlite.dll也会用到php_pdo.dll，可连官方文档都没有具体写要怎么配置php.ini，真是的！

下面我把我的配置写出来方便大家参考。
============================================
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

extension=php_pdo.dll
;extension=php_mbstring.dll
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_mysql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll