Dependências
Just to note with regards to SSL and compression. MySQLnd and thus extensions using mysqlnd such as mysqli... now supports SSL and compression. Both have been supported inside mysqlnd since PHP 5.3.3 - http://www.php.net/manual/en/mysqlnd.overview.php
Instalação
Para instalar a extensão mysqli para o PHP, use a opção de configuração --with-mysqli=mysql_config_path/mysql_config aonde mysql_config_path representa a localização do programa mysql_config que vem com versões do MySQL maiores do que 4.1.
Se você quiser instalar a extensão mysql junto com a extensão mysqli você tem que usar a mesma biblioteca de cliente para previnir quaisquer conflitos.
add a note
User Contributed Notes
Instalação
Mark F
14-Mar-2011 01:09
arekm
24-Aug-2010 05:49
"using the MySQL Native Driver results in improved performance and gives access to features not available when using the MySQL Client Library"
Of course there are also disadvantages:
- no SSL support (a nightmare!)
- no mysql < 4.1 support
So some people cannot use mysqlnd :(
josh dot ribakoff at gmail dot com
10-Nov-2009 10:21
I kept getting configure errors:
/tmp/cc4f2PKd.o: In function `main':
/usr/src/php-5.3.0/configure:14287: undefined reference to `yp_get_default_domain'
collect2: ld returned 1 exit status
configure: failed program was:
#line 14270 "configure"
#include "confdefs.h"
The solution was to configure with mysql native driver as outlined on this page.
David dot Kit dot Friedman at gmail dot com
19-Aug-2009 04:04
>On Windows, PHP is most commonly installed using the binary installer. Once PHP has been installed, some >configuration is required to enable mysqli and specify the client library you want it to use.
Basically, if you want to add extensions you can double-click again on the installer file. The installer will find the already installed PHP and will ask if you want to change the installation.
When you go through the prompts it will take you back to the list of extensions and you can pick which extensions you want to add.
For the mysqli extension the installer also edited php.ini so that the extension was enabled:
[PHP_MYSQLI]
extension=php_mysqli.dll
the installer added those lines to the end of the file.