Looks like you need to recompile PHP with the option. Aharon (Rony) Shapira wrote: > I tried using PDO as follows : > // create a SQLite3 database file with PDO and return a database handle > > try{ > > $dbHandle = new > PDO('sqlite:'.$_SERVER['DOCUMENT_ROOT'].'/../pdoTutorial.sqlite3'); > > }catch( PDOException $exception ){ > > die($exception->getMessage()); > > } > > > but got the following error message: > > Fatal error: Class 'PDO' not found in /home/zbfckla/public_html/Ocx.php on > line 14 > > > > ----- 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