using PDO class Uncaught Error

ThierryTrouillet

Fatal error
  Message=Uncaught Error: Class "PDO" not found in C:\Users\Trout\source\repos\PHPWebProject1\PHPWebProject1\index.php:34
Stack trace:
#0 {main}
  thrown
  Arborescence des appels de procédure :
#0 C:\Users\Trout\source\repos\PHPWebProject1\PHPWebProject1\index.php(34): {main}

Thanks for help me!

JakubMisek

Hello ThierryTrouillet

This error means that you don't have enabled "PDO" extension in your PHP installation.

Go to your Project Properties, tab Server/CLI, and open php.ini file:

Add or uncomment the following line (in case of MySQL database):

extension=php_pdo_mysql.dll
``

I hope it helps!

ThierryTrouillet

hello, really thanks for your help then I've been lookoing the location of the .ini file for 10 hours. Below the php.ini 😀

[ExtensionList]
extension=php_mysqli.dll
extension=php_mbstring.dll
extension=php_gd.dll
extension=php_gettext.dll
extension=php_curl.dll
extension=php_exif.dll
extension=php_openssl.dll
extension=php_soap.dll
extension=php_pdo_mysql.dll
extension=php_pdo_sqlite.dll
extension=php_imap.dll
extension=php_tidy.dll
extension=php_fileinfo.dll
extension=php_xsl.dll

JakubMisek

Looks good - that should work!

Can you check your phpinfo();, if there is a mention about PDO?

<?php
phpinfo();

ThierryTrouillet

I take a look...

ThierryTrouillet

Any information about PDO displayed excepted in the author section!

JakubMisek

please try the following command on the command line (inside the directory with PHP)

php -m

You should see something like:

C:\Program Files\IIS Express\PHP\v8.1>php -m
[PHP Modules]
bcmath
calendar
Core
ctype
curl
date
dom
exif
fileinfo
filter
gd
gettext
hash
iconv
imap
json
libxml
mbstring
mysqli
mysqlnd
openssl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
readline
Reflection
session
SimpleXML
soap
SPL
standard
tidy
tokenizer
xdebug
xml
xmlreader
xmlwriter
xsl
zip
zlib

[Zend Modules]
Xdebug

So far it seems that you SHOULD have PDO class ...

ThierryTrouillet

Windows 11

JakubMisek

try .\php -m in powershell

ThierryTrouillet

ok I get it but no PDO class listed!

JakubMisek

It means PDO extension is not loaded.

I see you're trying the development version of PHP 8.2. Can you check, if there actually exists the .\ext\php_pdo_mysql.dll file?

ThierryTrouillet

"C:\xampp\php\ext\php_pdo_mysql.dll" is only located in this directory on my computer

JakubMisek

ok, so the PHP 8.2-dev does not have PDO.

You can select a different PHP version in Project - Properties - Server (https://docs.devsense.com/en/vs/installation/install-php#select-or-install-php-version)

That should work ok :)

ThierryTrouillet

Yes it works with another version! Thanks you very much and bye bye Thierry

JakubMisek

good, thank you for reporting the problem and if there would be anything else, please let us know!

ThierryTrouillet

without problem!