note 80190 deleted from ref.sqlite by nlopess

From: Date: Thu, 03 Jan 2008 18:28:04 +0000
Subject: note 80190 deleted from ref.sqlite by nlopess
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-134719@lists.php.net to get a copy of this message
Note Submitter: jmsachs at gmail dot com ---- PLEASE make it more obvious in the above documentation that the procedural forms of sqlite function only work with SQLite2, and you need to use the object-oriented form to use SQLite3. I spent several hours figuring out why I couldn't interoperate databases between PHP and the command-line sqlite, until I saw these other comments: >papafox888 at hotmail dot com >01-Jun-2006 09:05 >If you get an error message: > > Warning: sqlite_open() [function.sqlite-open]: file is >encrypted or is not a database > >then most probably your code is accessing a SQLite3 >database. > >sqlite_open() only supports SQLite2. Use PDO to access >SQLite3. >Stephen Leaf >30-Jun-2005 05:58 >I think it would be good to point out that currently (as of >5.0.4) this extention does not >support SQLite 3 >databases. >So if your getting an error message like: >Error: file is encrypted or is not a database >That is why.

« previous php.notes (#134719) next »