Posted by Jim Carlock on 01/23/07 13:26

I added the following lines to PHP.INI.

extension=php_pdo.dll
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll

specifically in that order. I noticed the extensions getting loaded
are alphabetally listed, so I'm thinking that the order of the load
doesn't matter.

Is that true?

And when I use the following statements to create a test.db file...


It creates a file with the following text as the first 48 characters
in the file...

** This file contains an SQLite 2.1 database **

Searching php.net for that string turned up the following link:

http://gcov.php.net/PHP_5_2/lcov_html/ext/sqlite/libsqlite/src/btree.c.gcov.php

It appears that PHP 5.2 mis-identifies the file. I took a look at
some other software found at SourceForge advertised as a
visual front end to access and create SQLite databases. However,
the SQLite Browser identifies the SQLite data file as NOT a 3.1
version (perhaps due to PHP's mis-tagging (?)).

http://sqlitebrowser.sourceforge.net
http://sourceforge.net/projects/sqlitebrowser

Can anyone else confirm this?

Thanks.

--
Jim Carlock
Post replies to the group.
http://www.microcosmotalk.com/tech/windows/php/sqlite

• Next in forum: PHP and DLL loaded into MTS: not working
• Prev in forum: Re: use virtual hosts to develop locally but upload throws error in source file references
• Thread view: SQLite Version 2.1?

[Reply to this message]