I haven't tried to get it but I understand the Sqlite.org CVS server has
it archived. You should also be able to create the DB from PHP. Sqlite
open creates a DB if the file does not exist.
Aharon (Rony) Shapira wrote:
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
