Great. PHP has sqlite2 as you said. I could use it to create a db and add a
table. But when downloaded from the server to my pc couldn't get hold of it.
I have a command-line program for accessing and modifying SQLite3 databases
which seems not to recognise it. How do I get one for sqlite2?
Thanks a lot
----- Original Message -----
From: "John Stanton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "General Discussion of SQLite Database"
<sqlite-users@sqlite.org>
Sent: Sunday, March 09, 2008 6:48 PM
Subject: Re: [sqlite] Beginners bad luck
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
