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 it to recognize the function calls related to SQL.
My php.ini file has
extension_dir="C:\Program Files (x86)\PHP\ext"
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?