Re: php_mysqli.dll setup error

[Ashley Sewell]

Bob Field wrote:
> I'm not familiar with IIS but I just installed a
> webserver this afternoon with Apache 2.0.58 and
> PHP 5.1.4, and I had to stop and restart the
> Apache service in order for PHP to respond to any
> changes in the php.ini file.

IIS seems instant with changes to php.ini, and I've been restarting services anyway and occasionally out of despiration rebooting the server, just in case.

Some outputs from phpinfo() might be useful...

The output of phpinfo() on the development machine (which works) is:

MysqlI Support | enabled
Client API library version | 5.0.21
Client API header version | 5.0.21

The only way to get an output for mysqli in phpinfo() on my production server is to use the php.net version of php_mysqli.dll. This gives an output of:

MysqlI Support | enabled
Client API library version | 5.0.22 (since I tried upgrading to mysql 5.0.22)
Client API header version | 4.1.7


Funny...now that I've done this I can use prepared statements that don't invoke the "bind_param" method, still not preferable as there are a few statements that insert into a mediumtext field and "bind_param" is able to parse the parameters much cleaner than embedding everything in the INSERT statement.