Page 1 of 1

Apache and PHP on one machine, MySQL server on another

Posted: Tue Jun 22, 2010 10:24 pm
by kww
I gave up trying to install MySQL on my Windows 7 machine. Hours of fiddling, and it never could install properly. So, I uninstalled it, and installed it on my Windows XP machine where it seems to be running happily, waiting for someone to connect to it.

On my main Windows 7 64-bit machine, I am running Apache Web Server and PHP. I would like to be able to connect to my remote SQL server. I just can't get the PHP interpreter on the Windows 7 machine to recognize the function calls related to SQL.

My php.ini file has

extension_dir="C:\Program Files (x86)\PHP\ext"

[PHP_MYSQLI]
extension=php_mysqli.dll

I've verified that php_mysqli.dll is in that directory, and I don't get any error messages starting PHP. It successfully does the basic "Hello World" level stuff. However, when trying to access the mysqli functions, I get:
Fatal error: Call to undefined function mysqli_init() in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\sqlconnect4.php on line 8

Most installation guides I find assume that I have MySQL installed locally. Is there something special I need to do to deal with the remote server?

Re: Apache and PHP on one machine, MySQL server on another

Posted: Tue Jun 22, 2010 11:03 pm
by kww
I've also copied the libmysql.dll file from the MySQL installation package into the PHP directory (and the extension directory). No luck.

Re: Apache and PHP on one machine, MySQL server on another

Posted: Wed Jun 23, 2010 2:22 am
by Doug G
I don't have any problems running a local php application on my workstation that uses my hosting company mysql db. As long as your code specifies the correct host (by IP, URL) and the mysql server allows remote access and you don't have any firewalls blocking the connection it should work ok.