Connect to an SQLite database with PHP

Question

With the reference of the bellow link,I was tried to connect with an sqlite database using PHP.

How do I connect to an SQLite database with PHP?

<?php
$dir = 'sqlite:/var/www/html/shijin/brandz_db';
$dbh  = new PDO($dir) or die("cannot open the database");

But i am getting the following error,

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in /var/www/html/shijin/sqlite.php:3 Stack trace: #0 /var/www/html/shijin/sqlite.php(3): PDO->__construct('sqlite:/var/www...') #1 {main} thrown in /var/www/html/shijin/sqlite.php on line 3

score 0 · Answer 1 · answered Jun 13 '16 at 11:06

0

You need to install the PDO sqlite driver. Try

sudo pecl install pdo
sudo pecl install pdo_sqlite

answered Jun 13 '16 at 11:06

rypskar

2,012
13
13

I am using ubuntu,getting error sudo: pecl: command not found – Shijin TR Jun 13 '16 at 11:12
Then I guess `sudo apt-get install php5-sqlite3` should do :P – Klemen Tusar Jun 13 '16 at 11:15
@techouse I have tried ,but Unable to locate package php5-sqlite3 – Shijin TR Jun 13 '16 at 11:19
According to http://php.net/manual/en/ref.pdo-sqlite.php pecl have to be used on PHP >= 5.4 so depending on version you might have to first install pecl and try installing if from there if suggestion from @techouse didn't work – rypskar Jun 13 '16 at 11:21

Connect to an SQLite database with PHP

1 Answers1