[SOLVED] Customize error message?

[djfox]

I have this currently:

mysql_query("UPDATE userdata SET regions_loc='$loc', regions_url='$url', regid='$regid' WHERE id='$logged'")or die ( mysql_error());

 

Are there ways to customize the error message that would print out?

[waterssaz]

you can achieve this using something like

 

mysql_query($query) or die("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());

 

:-)

[djfox]

Great, thank you very much

[premiso]

It depends on how you want to "customize it"

 

In a production enviroment it is not good to display real errors to users.

 

In a case like that I would create my own function called "errorReport" or something similiar. This would email the admin the error and then display a friendly message like this:

 

function errorReport($msg, $mysql=false) {
    if ($mysql) {
        $msg .= " MySQL Error: " . mysql_error();
    }

    mail(ADMIN_EMAIL, "Error", $msg, HEADERS); // note ADMIN_EMAIL and HEADERS are constants that need to be defined.

    die("An error has occurred, the admin has been emailed. We apologize for this issue.");
}

 

That way you know about the error and the user is displayed a nice message letting them know about the error.

 

That is how I handle it (well in a similiar fashion just more robust).