mysqli not working in xampp windows

问题:

By seeing suggestions throught the internet I tried to convert all my queries to mysqli.

But mysqli is not working in my xampp.I checked my php folder and there is an php_mysqli.dll file ... still it doesnt work

Thanks in advance

回答1:

Have you declare it to php.ini to load it? If no, try find this in php.ini and add php_mysqli.dll

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;

; If you wish to have an extension loaded automatically, use the following
; syntax:
;
;   extension=modulename.extension
;
; For example, on Windows:
;
;   extension=msql.dll
;
; ... or under UNIX:
;
;   extension=msql.so
;
; ... or with a path:
;
;   extension=/path/to/extension/msql.so
;
; If you only provide the name of the extension, PHP will look for it in its
; default extension directory.
;
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) 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= php_mysqli.dll

回答2:

Goto the directory phpMyAdmin, find there is a file with name config.inc.php, open the file and find a line there as:
$cfg['Servers'][$i]['extension'] = 'mysql';
just change mysql to mysqli.

回答3:

Another thing that might be blocking the msqli dll from loading could be user right issues on your local webserver, make sure the \User can read the ext folder, that was what worked for me

回答4:

I think you should use XAMPP 1.8.3-1, XAMPP 1.8.2-2, XAMPP 1.8.1. Because these xampp versions also support Mysqli by default.