[RESOLVED] Confirm database connection

Jon12345

I have this code:

$db=mysql_connect("mysite.net","abc","zzz");

How can I confirm that I am connected to the database?

Thanks,

Jon

NogDog

$db=mysql_connect("mysite.net","abc","zzz");
if(!$db)
{
  // you are not connected to MySQL
}

Jon12345

That's strange. I added that code and if I alter any of the info in the mysql_connect string, I never get the echo "you are not connected";

Any ideas why?

NogDog

It's a comment, not an echo (just to show the basic logic). I was leaving it up to you whether to use an echo statement within the if block, or do a user_error(), a die(), or whatever else you'd like to do to handle the error condition.

NogDog

PS: If you just want to echo something, I'd suggest code along these lines:

if(!$db)
{
  echo "DB Connection failed: " . mysql_error();
}

Jon12345

I added an echo where you comment was. But the echo doesn't appear.

 $db=mysql_connect("mysite.net","abc","zzz");
if(!$db)
{
  echo "not connected";
}

I changed the site name so it couldn't connect. Then I tried changing the username. I never get the echo.

NogDog

Are you sure this block of code is being reached? (For instance, is it inside an if condition that isn't evaluating as true?) To be really thorough, you could try:

$db = mysql_connect('xxxxx','yyyyy','zzzzz');
if($db != FALSE)
{
  echo "<pre>Connected to DB\n".var_dump($db)."</pre>\n";
}
else
{
  echo "DB Connection failed: " .mysql_error();
}

If neither of the above messages get output, then my only explanation would be that the code is not getting executed at all for some reason.

Jon12345

Oh that did it thank you. Can I ask, is there a limit to the length of a mysql database name?

NogDog

Jon12345 wrote:
Oh that did it thank you. Can I ask, is there a limit to the length of a mysql database name?

64 characters

Jon12345

Thanks.