connecting to mysql server with php

lainer

Hi, I need a bit of help connecting to the mysql data base from the apache host. All local host and servers.

I'm using the script below:
<?php
$conn = mysql_connect('localhost', 'root', 'password');

echo $conn;
?>

to connect to the mysql server (obviously with the username as 'root' and password changed to my own settings) but it doesnt seem to be working.

any advice?

thanks! 🙂

Piranha

Do you get any error message? You can see errors from mysql by adding the following:

$conn = mysql_connect('localhost', 'root', 'password') or die(mysql_error());

And you can see errors from php if you add the following first in the php file:

error_reporting(E_ALL);

lainer

thanks for the reply but no luck. nothing comes up on the browser screen and no errors come up. is there some configuration that needs to be done to the server?

Piranha

If there is no errors it means that it works.

lainer

but its not printing $conn (echo $conn😉

I have also tried it just printing a string using the code below but this doesnt work either.

<?php
$conn = mysql_connect('localhost', 'root', 'password');

echo $conn;

or die (mysql_error());

echo $conn;
echo "hello";
?>

this code below does print the string:

<?php

echo "hello";

$conn = mysql_connect('localhost', 'root', 'password');

echo $conn;

or die (mysql_error());

echo $conn;

Piranha

In the manual it says that it "Returns a MySQL link identifier on success, or FALSE on failure." It means that it doesn't return anything that is printable. Try the code example from the manual page to see if it works or not.

By the way, what version of PHP and MySQL do you have?

lainer

I tried that there but no joy.

Its php version 5.0.2 and mysql version 5.0

Piranha

Ok, then you should not use those functions anyway. It is much better to use mysqli_* functions. But just out of curiosity, what does "no joy" mean? Did you get any message or anything like it?

lainer

ha! no joy again ( no joy means it wasnt successful, you didn't succeed - an Irish saying). I tried both versions of code below in different instances but nothing comes back on the browser, neither error nor result????????

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/ check connection /
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

printf("Host information: %s\n", $mysqli->host_info);

/ close connection /
$mysqli->close();
?>

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/ check connection /
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

printf("Host information: %s\n", mysqli_get_host_info($link));

/ close connection /
mysqli_close($link);
?>

Piranha

Have you tried with error_reporting turned on?

<?php
error_reporting(E_ALL);
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

printf("Host information: %s\n", $mysqli->host_info);

/* close connection */
$mysqli->close();
?>

lainer

nope still not working. when I put

echo 'hello';

after the error reporting line, hello is returned but nothing else.

Piranha

Strange indeed. Try to move the hello line one line at a time, when you don't see it you know on what line the error is. But to be honest I have no idea what the error could be since you don't get any message at all.

lainer

i tried that there and it doesn't print when its after the first line so there lies my problem??? maybe it is something on the mysql side. Thanks for your help anyway!

SoulAssassin

I remember having this problem in the beginning, until I realized I'm using my FTP password, instead of the DB password.
Maybe create a new user with full permissions, and connect with that one.

bradgrafelman

Do a phpinfo() and tell us the value for display_errors as well as error_reporting.

lainer

I think I have found the problem. When I try and load the php_mysql.dll into the library and restart the server an error appears:

C:\php5\ext\php_mysql.dll - The specified procedure could not be found.

A colleague suggested that there could be a conflict caused by using php version 5.0.2 and apache 2 server. Any thoughts?

bradgrafelman

There should be a libmysql.dll file in the c:\php5\ directory - is there?

If so, did you add the c:\php5 directory to your system's PATH environment variable (like you were supposed to as instructed in: [man]install.windows.manual[/man])?

lainer

Yeh the libmysql.dll file is there alrite. I don't follow about adding the c:\php5 directory to your system's PATH environment variable. How would I do this? thanking you again for help received!

bradgrafelman

As per the manual page I linked to:

Read more about how to add your PHP directory to PATH in the corresponding FAQ entry (and then don't forget to restart the computer - logoff isn't enough).