When using phpmyadmin, we sometimes see this prompt that the mysqli extension cannot be loaded. Let me summarize the solution below.
mysqli is an enhanced version of PHP’s mysql extension. Its performance is much better than the mysql series of functions.
1. First install php.ini-dist in your php directory and copy it to C:WINNT (win2003, winxp, win98 should be the corresponding system directory)
2. Remove the "-dist" after the php.ini-dist just now, open it with Notepad, search for "php_mysqli.dll" and remove the ";" in front of it and save
3. Copy php_mysql.dll in the C:phpext (this should be your php directory) directory to the C:WINNT\system32 directory
4. Copy libmysql.dll into C:windows\system32
For php.ini file
Enter C:PHP, copy php.ini-dist to C:WINNT (C:Windows under Windows XP/2003), and rename it
php.ini, then open it with Notepad, use Notepad’s search function to search extension_dir = "./", and point its path to your PHP directory
's extensions directory, for example: extension_dir = "C:PHPext"; then search for register_globals = Off and change Off to On;
Find ;extension=php_mysql.dll and remove the quotation marks ";" in front.
2. For instructions on configuring IIS in the manual, change "PHPsapiphp4isapi.dll" to "php5isapi.dll" in the php directory
3. Important: After following the instructions in the manual, copy the dll files in the php directory and ext directory (in the manual, it is extension for php4x, here it should be ext) to
On the basis of system32, copy the libmysql.dll file in the php directory to system32.