使用PHP连接到SQLite数据库

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

Answer 1

You need to install the PDO sqlite driver. Try

sudo pecl install pdo
sudo pecl install pdo_sqlite