Warning: mysql_connect() [Is if possible to redirect if error message?]

[montgomery]

Once in a while when our hosting company has problems out site breaks and shows some ugly error messages:

 

"Warning: mysql_connect(): Too many connections in ./settings.inc.php on line 90"

 

This of course looks very unprofessional.

 

What can I do to redirect the user to an "under maintenance" page, every time the problem occurs?

 

Thanks a lot!!

 

Montgomery

[wildteen88]

What you could do is do the following when mysql_connect returns an error

@mysql_connect('lcoalhost', 'username', 'passsword') or die('maintenance message here');

[pocobueno1388]

You could do something like this:

 

<?php

if ($conn = mysql_connect("....")){
   //connection made
} else {
   //need to redirect
   header("Location: www.sample.php");
}

?>

[montgomery]

I found the line 90 in settings.inc.php where the error occurs:

 

if(!mysql_connect($DbHost,$DbUser,$DbPassword)) {
$NOTCONNECTED = TRUE;
}

 

could I just change it to:

 

if(!mysql_connect($DbHost,$DbUser,$DbPassword)) {
$NOTCONNECTED = TRUE;
        header("Location: www.sample.php");
}

[pocobueno1388]

  Quote

could I just change it to:

 

if(!mysql_connect($DbHost,$DbUser,$DbPassword)) {
$NOTCONNECTED = TRUE;
        header("Location: www.sample.php");
}

 

Yes, although the variable $NOTCONNECTED will be linked somewhere else in the script, so I would check that out to see what it does.