My PHP pages can't connect to MySQL.

shmony

Hey everyone, I've posted this thing before a long time ago, (some of you might remember me...), and I'm back with the same exact problem. None of my PHP pages can connect to MySQL! I have read every documentation, every tutorial out there, and I still can't understand this! I installed MySQL & the ODBC Driver that was on the mysql web site too, and I did everything every tutorial told me to do. So then, I get it installed and everything, I make a PHP page to see if it can connect to mysql, and this comes up:

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)in /nfs/cust/5/04/84/48405/web/PHP/Test.php3 on line 5

Please, if anyone can help me, then please post if you have ANY info on why this keeps popping up. At this point, I am desperate, b/c I have tried & tried this so many times, but every time I do, it can't connect to mysql. Thanks for any info posted.
-Anthony

P.S - I am using WinXP Pro

shmony

this is where I have the PHP page that I'm having problems connecting to MySQL: http://www.cultureshockpac.com/PHP/Test.php3 if you wanna see all the errors that appear.

foolguitardude

It would be much easier to help if you supplied the php code, or at least the section that is giving the error. If you post a snippet of the code, I'll be glad to help.

shmony

Here's the code that's giving the problem:

<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

$result = mysql_query("SELECT * FROM employees",$db);

printf("First Name: %s<br>\n", mysql_result($result,0,"first"));

printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));

printf("Address: %s<br>\n", mysql_result($result,0,"address"));

printf("Position: %s<br>\n", mysql_result($result,0,"position"));

shmony

Oh, and also (please don't think I'm an idiot...) I never installed Apache yet. I didn't think that was a neccesary thing to install, I thought that it was just a server to test pages on, so I never installed it. If not installing it has anything to do with this problem, please tell me.

foolguitardude

Well, you might be right. What server is installed? Does WinXP have IIS? Are you using it?

shmony

well, I don't have a personal server installed. I just use the server (my mother's web site's server) to practice on. I just wanna be able to connect mysql, and get data from it, put data into it, and update it.
I'm sorry that I can't really answer your questions exactly correct, I just started using server-side programming.

shmony

what do I have to do with Apache to get MySQL to connect with it?

shmony

I am so sorry for being so dumb about this. It's just that I dont have any idea even where to start looking for stuff to help me get this stuff working, so I come and ask people over at the forums.

foolguitardude

Originally posted by shmony
I just use the server (my mother's web site's server) to practice on.

Ok, so the server is running winXP, is this what you are saying?

I just wanna be able to connect mysql, and get data from it, put data into it, and update it.

Ok, does the database that you are trying to connect to actually exist?

I'm sorry that I can't really answer your questions exactly correct, I just started using server-side programming.

No problem, we all start out as beginners.

what do I have to do with Apache to get MySQL to connect with it?

If the server is already running, you don't need apache.

shmony

okay cool, yes, the server is running winXP...yes the database exists, and thanks for your patience.

foolguitardude

Alright, I'm sorry to leave you hanging but I need to work on something, so I'll need to go after this post. Is the mySQL serverr running?

I'll check back later when I have time. Good luck.

shmony

well, that's alright, and yes the mysql server is running.