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 > > -- 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