note 80190 added to ref.sqlite

From: Date: Thu, 03 Jan 2008 17:10:57 +0000
Subject: note 80190 added to ref.sqlite
Groups: php.notes 
Request: Send a blank email to php-notes+get-134718@lists.php.net to get a copy of this message
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. ---- Server IP: 64.71.164.2 Probable Submitter: 208.65.175.197 ---- Manual Page -- http://www.php.net/manual/en/ref.sqlite.php Edit -- https://master.php.net/note/edit/80190 Del: integrated -- https://master.php.net/note/delete/80190/integrated Del: useless -- https://master.php.net/note/delete/80190/useless Del: bad code -- https://master.php.net/note/delete/80190/bad+code Del: spam -- https://master.php.net/note/delete/80190/spam Del: non-english -- https://master.php.net/note/delete/80190/non-english Del: in docs -- https://master.php.net/note/delete/80190/in+docs Del: other reasons-- https://master.php.net/note/delete/80190 Reject -- https://master.php.net/note/reject/80190 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#134718) next »