[RESOLVED] Simple MySQL Display just won't work.

Earnan

I have just installed MySQL (yes, the server is running) on my WindowsXP machine.

I have tried about 30 different code samples for how to display results from a MySQL query and it just won't work.

Here is the most recent one I tried:

I have checked and root is the user, there is no password.

All I get is a Cannot Find Server or DNS error.

<html>
<head>
<title>Connect Server</title>
</head>
<body> 
<?
$link = mysql_connect("localhost","root")or die("Connect Error: ".mysql_error());
print "Successfully connected.\n";
mysql_close($link);
?>
</body>
</html>

I am tearing my hair out over this...stayed up until 5am trying to get it to work.

Help would be appreciated.

Edit: Cleaned up the code display.

TheDefender

"All I get is a Cannot Find Server or DNS error."

This is not a php error, or a mysql error. This is an error in which your browser cannot find the server. This is a standard page in IE when it can't find the server itself (either through IP address, or domain name.)

How are you calling the page? What is the URL you are using?

Earnan

Ok. I think I may have just been dumb.

I need some sort of webserver installed on my computer, don't I?

Any suggestions for an easy free one for XP if there is such a beast? I just want something to develop and test on. I am actually hosted on another site.

Thanks.

TheDefender

LOL, it definitely makes it easier to host web pages on your PC when you run a web server.

XP has IIS with it. It doesn't work for all of your needs (especially if you use .htaccess), but it works very well for the "general test local before uploading" kind of stuff. Otherwise, you should be able to use Apache.

Earnan

Ok, calling it resolved and I'll open one in Windows.

I can't find any good info on how to set up the link using IIS, and Apache does NOT look user-friendly.

Thanks.

bubblenut

<condescending>Awww, check out the silly newb</condescending> 😉

Don't worry mate we've all been there, check out this thread I've just started on the subject. Like I say in the post, I consider myself quite the pro. 😃

TheDefender

Earnan,

Apache can be/is user friendly, but has a bit of a learning curve to it, as does IIS. There really is no "set it and forget it" option without doing some homework first. Don't get discouraged,a nd don't let yourself feel overwhelmed. The first time I set up IIS, it took me a few hours, and a lot of searching forums, but is worth it, when I am writing my scripts. I love being able to test things on my computer, not only for myself, but when I am helping others here at phpbuilder.

Good Luck, and let us know what you have decided.

phptrouble

Try looking for fireserver i use it for testing it has apache and php