CODEWITHSUNDEEP
phpmysqlwindowspdo
Artem
Artem

Reputation: 643

PHP - How to install PDO driver? (Windows)

I am setting up PHP and MySQL (Maria DB) on Windows 8.1. I edited php.ini file and uncommented the following lines:

extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_pdo_mysql.dll

But unfortunately I cannot connect to database because there are no pdo drivers shown in phpinfo output. So, when I try to establish database connection, an exception is thrown:

Fatal error: Uncaught exception 'PDOException' with message 'could not find driver'

How can this problem be solved?

Upvotes: 13

Views: 41934

Answers (5)

Mert Aksoy
Mert Aksoy

Reputation: 412

In my case (windows pc) the extension_dir folder was set default to ext. However i got the same error "could not find driver". So i replaced the path to extension directoy with absolute path as below, and it worked.

php.ini

;extension_dir = ext
extension_dir = "C:\dev\php-8.3.4-Win32-vs16-x64\ext"

Upvotes: 2

werber bang
werber bang

Reputation: 333

I just needed to locate the php.ini file for the version I am using, and uncomment the line extension=pdo_pgsql for my case as I would like to use postgres enter image description here

Upvotes: 2

Accuman Angel Mafuva
Accuman Angel Mafuva

Reputation: 83

In the php.ini file, just below ;On Windows, uncomment 'extension_dir = "ext"'

It worked for me. php in snippet screenshot

Upvotes: 1

Stark182
Stark182

Reputation: 11

Check the extension_dir of your current apache directory, i installed 2 php versions and apache, and the problem was in wamp\bin\apache\Apache2.4.23\bin\php.ini , the path of ext was incorrect

Upvotes: 1

Artem
Artem

Reputation: 643

Finaly I managed to settle this stuff. I corrected extension_dir entry (absolute file path was needed) in php.ini file and database connection began to work.

Upvotes: 11

Related Questions