Checking a db-connection to mysql

Anon

Hi!

I want to protect surfers of our side from getting "mysql-conntection failed" errors...instead the php script should test, if the connection failed... if it failes the users should come to a side with "we will be back soon!" or something like this... but how can I check the connection??

Thanks for any help!

Jens!

[deleted]

Uhm... if ($connection=@mysql_connect())
{
#it worked
}
else
{
#it failed.
}

Anon

Well...Thanks! It was a good idea, but it doesnt work! :-(
I also tried with
if($connection==@mysql...

and with
if (@mysql_connect($host, $user, $password))
{...

but it is always "failed" or always "ok"... it should be "failed" when I use a wrong password, shouldnt it?

vincent wrote:

Uhm... if ($connection=@mysql_connect())

{

#it worked

}

else

{

#it failed.

}

[deleted]

it has to be a single "=" in the
if ($connection=mysql_connect())
remember, you are checking the value of whatever mysql_connect() puts into $connection.

yes it should fail if the password is incorrect.
Make sure that the host, username and password you enter into mysql_connect() are indeed what you think they are:
print them out right before you execute the mysql_connect()

Anon

Wow! It works! Seems that I had a spell error in the definition of my variables... as you guessed!

but now it works! Thanks a lot... and a happy new YEAR!

C.U. Jens...

vincent wrote:

it has to be a single "=" in the

if ($connection=mysql_connect())

remember, you are checking the value of whatever mysql_connect() puts into $connection.

yes it should fail if the password is incorrect.

Make sure that the host, username and password you enter into mysql_connect() are indeed what you think they are:

print them out right before you execute the mysql_connect()

Anon

Vincent
Thank you for helping me out with this one too
I've been trying to figure out how to do the error handling but you worked it all out for me. Thank you so much