pdo sqlite could not find driver... php file not processing

Question

Hi i'm received the could not find driver error when trying to connect to sqlite via a php file. I've set permission to 777... PHP Version 5.2.16, i have the module install. any reason why its not finding the driver, also php.ini is showing the extension pdo.so and pdo_mysql.so installed.

PDO

PDO support enabled PDO drivers mysql

pdo_mysql

PDO Driver for MySQL, client library version 5.0.92

try {
    // Connect to the SQLite Database.
    $db = new PDO('sqlite:.subscribers.db');
} catch(Exception $e) {
    die('connection_unsuccessful: ' . $e->getMessage());
}

[http://www.php.net/manual/en/ref.pdo-sqlite.php](http://www.php.net/manual/en/ref.pdo-sqlite.php) — clement, Jan 10 '12 at 13:24
On Windows, the only thing that helped me was to add "C:\Program Files\php" to the system PATH environment variables, although I cannot imagine why. — Uwe Keim, Apr 07 '23 at 12:20

score 38 · Answer 1 · answered Apr 13 '17 at 01:47

38

I had to actually install the extension, and this is how i did on Ubuntu 16 running PHP 7.1:

sudo apt install php7.1-sqlite3

answered Apr 13 '17 at 01:47

The Onin

5,068
2
38
55

2

`sudo apt-get install php5-sqlite` for php5 on Ubuntu server 14.04.5 LTS – Pete Jan 24 '18 at 23:33
10

or `sudo apt install php-sqlite3` for all variations of php7 – kramer65 Jun 13 '18 at 20:20
3

`sudo apt install php8.0-sqlite3` if you use PHP 8. – Vanity Slug - codidact.com Nov 03 '21 at 14:37

score 25 · Accepted Answer · edited Apr 07 '23 at 11:54

25

You need

[PDO_SQLITE]
extension=pdo_sqlite.so

to be enabled, for sqlite:.subscribers.db

or, for Windows:

[PHP_PDO_SQLITE]
extension=php_pdo_sqlite.dll

And of course this extension in your ext directory.

edited Apr 07 '23 at 11:54

Uwe Keim

39,551
56
175
291

answered Jan 10 '12 at 13:11

devdRew

4,393
3
24
33

do i have to recompile php to get the pdo_sqlite.so extension? – acctman Jan 10 '12 at 13:58
no, just add `*.so` file to `ext` dir, add few lines in `php.ini` and that's all – devdRew Jan 10 '12 at 14:03
1

ok i figured it out `sudo pecl install pdo_sqlite` did the trick i did pdo_mysql earlier sqlite did the trick. – acctman Jan 10 '12 at 14:06
3

Also, on ubuntu: http://stackoverflow.com/questions/8822209/pdo-sqlite-driver-not-present-what-to-do – dsummersl Jun 18 '13 at 11:56
I have edited /etc/php5/apache2/php.ini then i have restarted Apache (sudo service apache2 restart) – Spl2nky May 05 '15 at 22:09

score 11 · Answer 3 · answered May 15 '17 at 18:46

11

On archlinux i had to do two things:

first install php-sqlite

pacman -S php-sqlite

after that in my php.ini file for me in /etc/php/php.ini i had to uncomment this line:

;extension=pdo_sqlite.so

by removing semicolon.

Dont forget to restart server.

answered May 15 '17 at 18:46

JTC

3,344
3
28
46

1

Works perfectly for me! Thx. I just uncomment ;extension=pdo_sqlite.so as you said. – Guchelkaben Dec 28 '17 at 21:57

score 3 · Answer 4 · edited Sep 04 '19 at 13:58

I am using a portable version of PHP on windows, using the inbuilt web server. I found the following steps helped:

Renaming php.ini-development to php.ini
Uncommenting extension_dir = "ext" under [PHP] (around line 700)
making sure the following lines are in the php.ini:

[sqlite3]    
sqlite3.extension_dir = "ext"    
extension = sqlite3    
extension = pdo_sqlite

Running the php webserver with the following flag added on: - c C:\Path\to\PortablePHP\php.ini

So currently my php command is php -S localhost:8081 -c B:\Downloads\php-7.2.6\php.ini.

score 0 · Answer 5 · answered Jan 10 '23 at 08:43

0

Debian 11 (bullseye) provides php7.4-sqlite3:

apt install php7.4-sqlite3

answered Jan 10 '23 at 08:43

Abdull

26,371
26
130
172

pdo sqlite could not find driver... php file not processing

5 Answers5

Linked

Related