Re: Trouble connecting to MySQL using mysqli extension on XP

Only thing I can think of off-hand is that maybe they want an IP address since 127.0.0.1 maps to localhost that might be worth a try. STay well Jacob Kruger Blind Biker Skype: BlindZA '...Fate had broken his body, but not his spirit...' ----- Original Message ----- From: "anonymous" <blockstack@gmail.com> To: <php-windows@lists.php.net> Sent: Wednesday, July 16, 2008 5:50 PM Subject: [PHP-WIN] Trouble connecting to MySQL using mysqli extension on XP

I had a tough time getting PHP to connect to MySQL using mysqli on XP. The following code from the php documentation on mysqli failed to work. $mysqli = new mysqli( "localhost", "user", "password", "database" ); Where localhost, user, password, and database were replaced with the appropriate values. I left the host parameter as "localhost" because that's what I wanted, however that did not work. So I changed it to NULL, which defaults to localhost as per the documentation, but this still did not work. After some googling, I found the answer on another forum, which stated that the host should be a dot ".", but no other explanation was given. Is there anyone that can shed some light on the situation? Everything works fine now, but I would really like to know why I can't use "localhost", and why this isn't documented. I've tried every mysqli option imaginable in the php.ini file. It seems that host must be a dot. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php