Custom Error Messages?

Randy · 06-09-2009, 01:32 AM

Alright so i know the if and else features stuff but im trying to do something that is different, idk if this should go into the mysql area or not so i just put it here.

I am connecting to my database

PHP Code:


			
mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($databasename);

however I am curious how would i go about including like a dberror.html file for the error like vbulletin does. I was trying to find out how they do it but i cant find the file where they connect to the database.

Cheers,
Randy

Wildhoney · 06-09-2009, 01:38 AM

How about forwarding the user to a generic error page when an error occurs?
(Please excuse the laziness of adding an @)

php Code:

if (!@mysql_connect('Bad', 'connection', 'details'))
{
    header('location: databaseError.php');
}

Randy · 06-09-2009, 01:43 AM

It could work but im trying to use as little if statements as possible

Wildhoney · 06-09-2009, 02:09 AM

Okay

How about this one, amigo?

php Code:

mysql_connect('Bad', 'connection', 'details') or header('location: databaseError.php');

And what is wrong with if statements?

etoolbox · 06-09-2009, 02:55 AM

You can do something like this:

PHP Code:


			
@mysql_connect("localhost", "mysql_user", "mysql_password");
$error = mysql_error();
if($error) {
    // do something, including outputting error, logging it etc
}

$mysql_query("...");
$error = mysql_error();
if($error) {
    // do something, including outputting error, logging it etc
}

But of course you're best to either wrap all mysql calls into wrapper functions which check for errors with a common error handling function so you don't have to write mysql_error() all over the place, or use one of the many database abstraction libraries which usually have some form of common error handling function that you can set up.

Salathe · 06-09-2009, 11:14 AM

Why not use a wider error/exception handler and have that respond appropriately to these conditions? It'll help centralise all of your error/exception handling so there is no need for ifs and buts all throughout your code, as etookbox mentioned. Within your handler you can look for a database connection error specifically (if you desire) and respond however you like (logging, send an email, print error page, or all of the above).

Randy · 06-10-2009, 01:15 AM

Thanks, got it working much appreciated and nothing is wrong with them WildHoney i just have many of them already and yah i have been using that idea throughout my code that etoolbox mentioned to handle login errors etc.. has worked wonders :D