The problem was solved by Shibu Narayanan that gave me a link to older versions of sqlite. Thanks to you all for the effort. I guess that beginners do have good luck after all. Aharon
----- Original Message ----- From: "Robert L Cochran" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Monday, March 10, 2008 2:42 AM Subject: Re: [sqlite] Beginners bad luck > When you call phpinfo(); do you see that the PDO functionality is enabled? > > Is SQLite listed as one of the databases? > > http://us.php.net/manual/en/function.phpinfo.php > > Also look at your /etc/php.ini file. Assuming your binary of php is > using extensions, are the extensions for sqlite being loaded? You have > to enable them from php.ini. > > Finally, you need to use the pdo syntax -- another poster pointed you to > that. > > Instead of PHP, you might want to try using the Catalyst framework to > help you get an SQLite-enabled website going. http://catalyst.perl.org/ > for further info, and be sure to follow the Catalyst tutorial. One > problem here is that Catalyst itself is very difficult to install and > the plugins needed for the Catlyst Tutorial are harder. In fact I think > PHP might be easier to compile, but then using Zend Framework is > terribly difficult. > > Best Regards > > Bob Cochran > Greenbelt, Maryland, USA > > > > Aharon (Rony) Shapira 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"); >> >> 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 >> >> >> > _______________________________________________ > 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
