Click here to get back home

sqlite with PDO and sqlite extension

 HomeNewsGroups | Search | About
 comp.lang.php    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
sqlite with PDO and sqlite extension Harris Kosmidhs 07-04-2008
Posted by Harris Kosmidhs on July 4, 2008, 6:24 am
Please log in for more thread options
Hello.

I started writing an application and used PDO to connect to an sqlite
file.The sqlite DB was created with the Sqllite extension of firefox.

Now I want to switch to CakePHP. I used the sqlite driver but since it
uses sqlite_popen my database canno't be open. Firefox sqlite extension
uses sqlite 3.x and sqlite_open is for 2.x databases. So I get: Warning:
sqlite_popen() [function.sqlite-popen]: file is encrypted or is not a
database

Is there a way to fix this?


Thanks
Harris

Posted by =?ISO-8859-1?Q?Une_B=E9v?= =?I on July 4, 2008, 6:30 am
Please log in for more thread options

>
> Is there a way to fix this?

there is an sqlite3-0.6 extension for php.

--
Une Bévue

Similar ThreadsPosted
SQLite DB using without SQLite Extension September 5, 2005, 12:40 pm
using sqlite 3 with php 5 November 18, 2005, 1:23 pm
sqlite/PHP under OS X June 19, 2008, 5:22 pm
Upgrading SQLite in PHP 5 January 24, 2005, 12:39 pm
New PHP Releases and PDO SQLite July 5, 2006, 8:55 am
SQLite Version 2.1? January 23, 2007, 8:26 am
Escaping SQLite October 1, 2007, 1:52 am
Best Practice -- PDO, SQLite? November 5, 2007, 10:50 pm
Using SQLite from PHP w/out recompiling? January 20, 2008, 3:42 pm
SQLite installation php4 OSX July 19, 2005, 3:54 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap