Connecting SQLite with PHP code

Question

I created a database with one table using SQLite. However, I am trying to get the data using PHP code but it doesn't work. Any help?

My code:

if ($pdo == null) {
    $pdo = new PDO('sqlite:/db/attendance');
}

$result = $myPDO->query("SELECT * from Student");

You don't say anything about the version of PHP you're using, but it might not support it. Read up here: php.net/manual/en/ref.pdo-sqlite.php — junkfoodjunkie
– junkfoodjunkie, Commented Feb 26, 2017 at 3:48
I am using php 5.6, the SQLiteconnection connects successfully to the DB but I can run it from the php code — SMH
– SMH, Commented Feb 26, 2017 at 3:51
Actually, there is not result as the line gives an error: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [14] unable to open database file' in /Attendance/index.php:16 Stack trace: #0 /Attendance/index.php(16): PDO->__construct('sqlite:/db/atte...') #1 {main} thrown in /Attendance/index.php on line 16 — SMH
– SMH, Commented Feb 26, 2017 at 4:00

Chris · Accepted Answer · 2017-02-26 04:20:09Z

1

When you ask PHP to open /db/attendance you are specifying an absolute path: a file called attendance in a directory called db in the root of your filesystem.

You probably want to specify either a relative path, or an absolute path that is built from your script's location.

Try leaving the leading / off of the front of your path:

$pdo = new PDO('sqlite:db/attendance');

or, even better, building it from the __DIR__ magic constant:

$pdo = new PDO('sqlite:' . __DIR__ . '/db/attendance');

answered Feb 26, 2017 at 4:20

Chris

139k139 gold badges316 silver badges293 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connecting SQLite with PHP code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related