Thanks, that helped. I got it to connect. ________________________________________ From: [email protected] [[email protected]] Sent: Tuesday, December 13, 2011 7:50 PM To: Bentley, Dain Cc: [email protected]; [email protected] Subject: Re: PHP SQLite connection in OpenBSD
Quoting [email protected]: > Quoting "Bentley, Dain" <[email protected]>: > > > Thanks for the help. I'm getting a different error now: > > SQLSTATE[HY000] [1] unable to open database: /path/to/db > > > > Can't seem to find much on this error. Something from the PHP website > > about > > having to recompile PHP from source but it's an old thread and I'd > > rather not > > use non-packaged third party tools if I can help it. > > > > And have you tried using the file from sqlite command line to check all > OK with > sqlite & the database file? > > $ sqlite /path/to/db > Got to be something you've done - works fine here for me ... Built a 4.9 i386 box, installed same packages as you ... No need to build anything or configure anything. # cd /tmp/ # sqlite test.db SQLite version 2.8.17 Enter ".help" for instructions sqlite> CREATE TABLE apple (apple_id INTEGER); sqlite> INSERT INTO apple (apple_id) VALUES(44); sqlite> SELECT * FROM apple; 44 sqlite> # php test.php Array ( [apple_id] => 44 [0] => 44 ) # cat /tmp/test.php <?php try { $dbh=new PDO("sqlite2:/tmp/test.db"); } catch (PDOException $e) { print_r($e); } $res=$dbh->query("SELECT * FROM apple"); foreach ($res as $r) { print_r($r); } ?> HTH. > > > > ________________________________________ > > From: joshua stein [[email protected]] > > Sent: Tuesday, December 13, 2011 6:08 PM > > To: Bentley, Dain > > Subject: Re: PHP SQLite connection in OpenBSD > > > > > PDO drivers sqlite2 > > > > > > Here is the code I am using to attempt to connect > > > <?php > > > try { > > > // connect to SQLite from PDO database > > > $dbh = new PDO("sqlite:/bandwith/stats.db"); > > > > you have sqlite2 installed, but the "sqlite" pdo prefix is for > > sqlite 3 databases. > > > > try opening "sqlite2:/bandwith/stats.db".
