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

rypskar · Accepted Answer · 2016-06-13 11:06:34Z

1

You need to install the PDO sqlite driver. Try

sudo pecl install pdo
sudo pecl install pdo_sqlite

answered Jun 13, 2016 at 11:06

rypskar

2,08714 silver badges13 bronze badges

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

4 Comments

Shijin TR Over a year ago

I am using ubuntu,getting error sudo: pecl: command not found

Klemen Tusar Over a year ago

Then I guess sudo apt-get install php5-sqlite3 should do :P

Shijin TR Over a year ago

@techouse I have tried ,but Unable to locate package php5-sqlite3

rypskar Over a year ago

According to 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

Collectives™ on Stack Overflow

Connect to an SQLite database with PHP

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related