Hey all,

I have been searching google and these forums for a good solution for handling mysql errors but I cant find a solid solution so here I am

Till now I have been using:
mysql_query()or die(mysql_error);

Which obviously isnt a great solution for the life environment.

What I wanted to do was replace "mysql_error" with either a function or with an include statement and then have the error emailed to me (no point of submitting it to a database if the database is down). So when I use a function or include statement it emails fine, but its still displaying the mysql error message and I dont know how to stop that.

I have read you can change the INI file to have it stop outputting error messages but I still want to be able to use mysql_error in the production environment.

Thanks all, any help would be really appreciated!

Hi,

Its bad practice to use error_display set to ON on Production environment.The other solution is you can make use of Exception.

read following for more details:

http://in2.php.net/manual/en/functio...or-handler.php
http://in2.php.net/manual/en/functio...on-handler.php

Hope these link help you.

Regards

Thanks so much! set_error_handler solved the problem of having the PHP errors displayed.

The problem I am having now is that it is calling the error function 17 times, but only providing error messages to the function on the first instance. So this means I am getting 17 emails alerting me to one error but only the first email actually has any of the variables included. This is ok I guess because I could just make an if statement and only recognize it if $errno!="" but that seems silly.

Ill show you what I have right now. Here is the file that is supposed to handle the error messages.

PHP Code:

<?php
$old_error_handler = set_error_handler("ErrorHandler");
function ErrorHandler($errno, $errstr, $errfile, $errline)
{
date_default_timezone_set('-O500');
$date=date('l jS \of F Y h:i:s A');;
$page=$_SERVER['PHP_SELF'];
$errno=mysql_errno();
mail("name@email.com","SQL ERROR:".$errno,"Error Number:".$errno."\n\n Error Message:".mysql_error()."\n\n Date (no daylight):".$date."\n\n Page:".$page); 
echo "submit<br />";
}
?>

Here is the test file that generates an error:

PHP Code:

<?php
include "error_submit.php";

mysql_query("INSERT INTO ecoprofs(invalid) VALUES ('$nothing')") or die();
?>

Any help would be great

Oh and I realize I am being redundant with my variables in the error email page, I just didnt change them after I made the changes you suggested.