The mysqli extension is missing. Please check your PHP configuration

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: egami, macek, gesf

Post Reply
MySQLi
New php-forum User
New php-forum User
Posts: 3
Joined: Sun Apr 19, 2020 1:47 am

Sun Apr 19, 2020 3:49 am

HELLO,

* When I try http://localhost/phpMyAdmin/
* I am getting this Error messae wehn I run "phpMyAdmin" (picture attached)

phpMyAdmin - Error
The mysqli extension is missing. Please check your PHP configuration. See [a@doc/html/faq.html#faqmysql@documentation]our documentation for more information.


==> Why I am still getting this while the PHP.ini seems setup correctly (some settings down) and PHP.ini file attached.


=== I have installed: PHP, MySQL Server and PHP My Admin as follows
OS: Windows 10 Pro 64-bit
Web Server: IIS

1. Downloaded and Installed php-7.4.5-nts-Win32-vc15-x64.zip
from https://windows.php.net/download

2. Downloaed and Installed MySQL (Full Installation) --> mysql-8.0.19-winx64.zip
from https://dev.mysql.com/downloads/mysql/

3. Downloaded and Installed PHP My Admin 5.0.2 --> phpMyAdmin-5.0.2-all-languages.zip
from https://www.phpmyadmin.net/downloads/



=== THE PHP Driectory and PHP.ini Settings and IIS Driectory, as follows ==

c:\php\ext

IIS directory on Windows 10 Pro 64-bitu
c:\inetpub\wwwwroot



c:\php\php.ini

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
extension_dir = "ext"

; On windows:
extension_dir = "ext"

.....

; Notes for Windows environments :
;
; - Many DLL files are located in the extensions/ (PHP 4) or ext/ (PHP 5+)
; extension folders as well as the separate PECL DLL download (PHP 5+).
; Be sure to appropriately set the extension_dir directive.
;
extension=bz2
extension=curl
extension=ffi
extension=ftp
extension=fileinfo
extension=gd2
extension=gettext
extension=gmp
extension=intl
extension=imap
extension=ldap
extension=mbstring
extension=exif ; Must be after mbstring as it depends on it
extension=php_mysqli.dll
extension=oci8_12c ; Use with Oracle Database 12c Instant Client
extension=odbc
extension=openssl
extension=pdo_firebird
extension=pdo_mysql
extension=pdo_oci
extension=pdo_odbc
extension=pdo_pgsql
extension=pdo_sqlite
extension=pgsql
extension=shmop

; The MIBS data available in the PHP distribution must be installed.
; See http://www.php.net/manual/en/snmp.installation.php
;extension=snmp

extension=soap
extension=sockets
extension=sodium
extension=sqlite3
extension=tidy
extension=xmlrpc
extension=xsl



==============
LIST OF DLL Files in c:\php\ext Directory ... (picture attached)
===============

Directory of C:\PHP\ext

04/19/2020 03:47 PM <DIR> .
04/19/2020 03:47 PM <DIR> ..
04/19/2020 03:46 PM 92 dll
04/19/2020 03:47 PM 0 dll_Files
04/14/2020 09:28 PM 87,040 php_bz2.dll
04/14/2020 09:28 PM 87,552 php_com_dotnet.dll
04/14/2020 09:28 PM 551,936 php_curl.dll
04/14/2020 09:28 PM 147,968 php_dba.dll
04/14/2020 09:28 PM 24,064 php_enchant.dll
04/14/2020 09:29 PM 72,192 php_exif.dll
04/14/2020 09:28 PM 148,480 php_ffi.dll
04/14/2020 09:28 PM 5,708,800 php_fileinfo.dll
04/14/2020 09:28 PM 56,320 php_ftp.dll
04/14/2020 09:29 PM 1,695,232 php_gd2.dll
04/14/2020 09:29 PM 54,784 php_gettext.dll
04/14/2020 09:29 PM 343,040 php_gmp.dll
04/14/2020 09:29 PM 909,312 php_imap.dll
04/14/2020 09:29 PM 389,120 php_intl.dll
04/14/2020 09:29 PM 256,000 php_ldap.dll
04/14/2020 09:29 PM 1,425,920 php_mbstring.dll
04/14/2020 09:29 PM 108,032 php_mysqli.dll
04/14/2020 09:29 PM 139,776 php_oci8_12c.dll
04/14/2020 09:29 PM 61,440 php_odbc.dll
04/14/2020 09:29 PM 476,672 php_opcache.dll
04/14/2020 09:29 PM 126,976 php_openssl.dll
04/14/2020 09:29 PM 29,696 php_pdo_firebird.dll
04/14/2020 09:29 PM 30,720 php_pdo_mysql.dll
04/14/2020 09:29 PM 35,840 php_pdo_oci.dll
04/14/2020 09:29 PM 27,136 php_pdo_odbc.dll
04/14/2020 09:29 PM 39,424 php_pdo_pgsql.dll
04/14/2020 09:29 PM 28,672 php_pdo_sqlite.dll
04/14/2020 09:29 PM 98,304 php_pgsql.dll
04/14/2020 09:28 PM 17,920 php_phpdbg_webhelper.dll
04/14/2020 09:29 PM 16,896 php_shmop.dll
04/14/2020 09:29 PM 420,864 php_snmp.dll
04/14/2020 09:29 PM 239,104 php_soap.dll
04/14/2020 09:29 PM 73,728 php_sockets.dll
04/14/2020 09:29 PM 73,216 php_sodium.dll
04/14/2020 09:29 PM 45,056 php_sqlite3.dll
04/14/2020 09:29 PM 17,408 php_sysvshm.dll
04/14/2020 09:29 PM 570,368 php_tidy.dll
04/14/2020 09:29 PM 82,944 php_xmlrpc.dll
04/14/2020 09:29 PM 289,792 php_xsl.dll
04/14/2020 09:29 PM 17,408 php_zend_test.dll





_______________________________________
*** THANK YOU IN ADVANCE ***
Attachments
PHP DLL Files.PNG
PHP DLL Files.PNG (17.36 KiB) Viewed 813 times
phpMyAdmin - Error -  The MySQLi  extension is missing.PNG
phpMyAdmin - Error - The MySQLi extension is missing.PNG (20.71 KiB) Viewed 813 times
User avatar
hyper
php-forum GURU
php-forum GURU
Posts: 1192
Joined: Mon Feb 22, 2016 5:52 pm

Sun Apr 19, 2020 9:53 am

If memory serves (I don't use Windoze anymore), you should install MySQL first, then PHP. You need to find someway to let PHP know that there is MySQL available.

Although this does not fix your current problem, I would opt for PDO rather than MySQLi in any-case; you can google the above solution as well as I can :D
MySQLi
New php-forum User
New php-forum User
Posts: 3
Joined: Sun Apr 19, 2020 1:47 am

Sun Apr 19, 2020 12:06 pm

I have been searching for 2 days now, but no luck :(

Will keep trying for another a day, otherwise, will swtich to ASP with IIS, becuase nobdy on Google (earth) have a solution! :D
MySQLi
New php-forum User
New php-forum User
Posts: 3
Joined: Sun Apr 19, 2020 1:47 am

Sun Apr 19, 2020 1:21 pm

NO WORRIES, I managed to solve the problem 8)

The INI file was withouth an extention, I mean it was PHP only, so I have just renamed it to PHP.ini

becasue of Windows has the hiding extension feature, I could see that the INI files shipped by PHP that do not have the .INI extension :oops:
Post Reply