PHP has Sqlite V2 embedded. Use PDO to get Sqlite3.
P Kishor wrote:
> On 3/9/08, Aharon (Rony) Shapira <[EMAIL PROTECTED]> wrote:
>
>>Sorry. When I set $db and use $db the message I get is:
>>
>> Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a
>> database in /home/zbfckla/public_html/Ocx.php on line 49
>> Could not open database
>>
>
>
> again, no idea about PHP, but check once again if you can open the db
> ok from the command line. Also, confirm that the db is not on a
> network drive.
>
> If the db opens ok from the command line, it is some kind of PHP
> problem. Ask for help on the PHP forum unless a PHP user on this list
> can help. If the db does not open ok from the command line, the db is
> really fubar because of "unknown" reasons. Recreate the db and try
> again.
>
> Good luck.
>
>
>
>>
>>
>> ----- Original Message -----
>> From: "P Kishor" <[EMAIL PROTECTED]>
>> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
>> Sent: Sunday, March 09, 2008 5:02 PM
>> Subject: Re: [sqlite] Beginners bad luck
>>
>>
>> >I don't know how PHP's db connector works but...
>> >
>> > On 3/9/08, Aharon (Rony) Shapira <[EMAIL PROTECTED]> wrote:
>> >>
>> >> I created a simple table named "books" in "library.db".
>> >> After entering "select * from books" I saw the data that I put into it.
>> >>
>> >> When trying to access it through php:
>> >> $file = "library.db";
>> >> // open database file
>> >>
>> >> $handle = sqlite_open($db) or die("Could not open database");
>> >
>> > Is that a typo? You are setting $file, but trying to open $db.
>> >
>> >
>> >>
>> >> I got the following:
>> >>
>> >> "Could not open database"
>> >>
>> >>
>> >>
>> >> When I tried the following:
>> >>
>> >> $file = "library.db";
>> >>
>> >> // create database object
>> >>
>> >> $db = new SQLiteDatabase($file) or die("Could not open database");
>> >>
>> >> I got the following:
>> >>
>> >> Fatal error: Uncaught exception 'SQLiteException' with message
>> >> 'SQLiteDatabase::__construct() [<a
>> >> href='function.SQLiteDatabase---construct'>function.SQLiteDatabase---construct</a>]:
>> >> file is encrypted or is not a database' in
>> >> /home/zbfckla/public_html/Ocx.php:17 Stack trace: #0
>> >> /home/zbfckla/public_html/Ocx.php(17):
>> >> SQLiteDatabase->__construct('library.db') #1 {main} thrown in
>> >> /home/zbfckla/public_html/Ocx.php on line 17
>> >>
>> >>
>> >>
>> >> Once again I apologies for these silly questions.
>> >>
>> >> Aharon
>> >> _______________________________________________
>> >> sqlite-users mailing list
>> >> sqlite-users@sqlite.org
>> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >>
>> >
>> >
>> > --
>> > Puneet Kishor http://punkish.eidesis.org/
>> > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
>> > Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
>> > _______________________________________________
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
