MYSQL error message posting by mail to the programmer

In different situations sql query can generate error message and display it along with error number. But most of the time develops is not the user of the script and for a normal user these error message or error number are of no use. The programmer can interpret meaning full reason of the error. So instead of displaying the error message to the visitor this script can post the error message and error number generated out of query to the email address of the programmer. We will use this small php mail script to post the error message to the programmer.

MySQL Error MySQL Error No Error Mail

First we will test if there is an error or not by checking mysql_query() function. This function will return true if query is successful and will return false in case of error. So we will use php if else condition to check the status of this mysql_query() function. Here is the small code.

$query = mysql_query("SELECT no_field FROM student");

if(!$query){ // condition to check in case of error only

$error_msg= "Erron No:".mysql_errno(). "<br>";
$error_msg .="Error message = ".mysql_error();

mail("programmer@sitename.com","error message",$error_msg,"");
}

PHP and PDO

If you are using PDO then we can collect error message and error code then post it by using PHP mail function.

require 'config-pdo.php'; // database connection string 
$pdo=$dbo->prepare('Select * from nonexistence_table');
if($pdo->execute()){
echo 'Success<br>';
}else{
$error_msg = "Error Code : ".$pdo->errorCode()."<br>";
$error_msg = $error_msg . "Error Message : ". print_r($pdo->errorInfo());
echo $error_msg;
mail("programmer@sitename.com","error message",$error_msg,""); 
}

PHP MySQL functions MySQL Error Number MySQL Error

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Ted	08-12-2010
What if the error is something other than a mysql error. Like a syntax error or something? Is there an error code or process for that? I have such an error and Dreamweaver does not tell me.

Query Error message posting to E-mail address

PHP and PDO

Subhendu Mohapatra