connecting to MYSQL using PHP and Apache

jpk872

I trying to configure PHP to run MYSQL and it isn't working. I've spend many hours trying to figure this out. I've made changes to the php.ini file and the httpd.conf file and it no longer gives me an error, but it still doesn't connect to the database. It gets to right before the mysql_connect statement where it says "about to connect", and then instead of the error message, I get nothing. It just sits there.

Expand|Select|Wrap|Line Numbers

 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
 
<html>

<head>

<title>Insert to Database</title>

</head>

<body>
 
<?php
 
$username = "root";

$password = "krustyrules";

$database = "mysql";
 
echo 'about to connect';
 
$link = mysql_connect("localhost:3306",$username,$password);
 
if(!$link) {

      die('Could not connect: ' . mysql_error());

}

echo 'Connected Successfully';

mysql_select_db($database) or die( "Unable to select database");
 
$firstname = $_POST["fname"];

$lastname = $_POST["lname"];

$emailadd = $_POST["email"];
 
$query = "INSERT INTO contacts VALUES ('',$firstname, $lastname, $emailadd)";
 
mysql_query($query);
 
mysql_close($link);
 
?><br />

You are <?php echo $_POST["fname"]; ?>.<br/>
 
</body>

</html>

Atli

Have you checked the output of the phpinfo() function for the MySQL info?

jpk872

yes nothing there. could it be because I have windows XP and the phpinfo says I have windows NT???

Atli

No, Windows XP uses the NT kernel, so that's all normal.

Make sure you've done all the following:

Remove the ; from the line ';extension=php_mysql.dll' in php.ini
Add the file 'libmysql.dll', from your PHP root dir, to the PATH enviroment variable. Or just copy the file to your windows directory.
Restart the apache server.

If thats all complete MySQL should work.

jpk872

it still doesn't work......any suggestions?

Atli

Are you sure the MySQL server is running ok?

You can also try to follow the three steppes I posted earlyer, but this time add the line, 'extension=php_mysqli.dll' and copyt the file 'libmysqli.dll' to your windows dir.

jpk872

i've tried the three previous steps before, they didn't work. could it have anything to do with apache? when i test apache i get the screen "It works!", is that right or should i get the other screen?

Atli

That is the default screen apache puts up when it has been successfully installed. The apache setup should not have anything to do with MySQL. MySQL is loaded by PHP.

Try to following code and see what happens.

Expand|Select|Wrap|Line Numbers

 
<?php

  echo mysql_connect("localhost", "root", "YOURPWHERE");

?>

If MySQL works, this should print "resource# 1", or something similar. Else, is should print a message telling you that the mysql_connect function is invalid.

If something else happens, it is likely that the PHP connection to MySQL works, but that there is a problem with the MySQL server itself.

In any case, copy the output and show us.

jpk872

It shows a blank screen and "done" in the status bar. nothing on the screen at all. I have MySQL Administrator on and it says that MySQL server is running. I also print out the phpinfo page and there is nothing with MySQL on there either.

Quote:

Originally Posted by Atli

That is the default screen apache puts up when it has been successfully installed. The apache setup should not have anything to do with MySQL. MySQL is loaded by PHP.

Try to following code and see what happens.

Expand|Select|Wrap|Line Numbers

 
<?php

  echo mysql_connect("localhost", "root", "YOURPWHERE");

?>

If MySQL works, this should print "resource# 1", or something similar. Else, is should print a message telling you that the mysql_connect function is invalid.

If something else happens, it is likely that the PHP connection to MySQL works, but that there is a problem with the MySQL server itself.

In any case, copy the output and show us.

Atli

Ok, try this.
Find the line "extension_dir" in your php.ini and point it to the 'ext' directory in your PHP install dir. (In my case 'D:\Program Files\PHP\ext\')
And then restart you Apache server.

Then create a .php file containing the following, and run it.
If everything works you should get a resource #, if not give us the error.

Expand|Select|Wrap|Line Numbers

 
error_reporting(E_ALL);

echo mysql_connect("localhost", "root", "ROOTPWD") or die(mysql_error());

jpk872

Got it!!!! Thanks a lot! I didn't have the php.ini file in the C:\Windows dir. I also specified the location of the php.ini file in apache htppd.conf.

Atli

Quote:

Originally Posted by jpk872

Got it!!!! Thanks a lot! I didn't have the php.ini file in the C:\Windows dir. I also specified the location of the php.ini file in apache htppd.conf.

Ahh ok, glad it worked out.