Prepared Statements And Error Handling

[masterlayouts]

The custom error handler function as defined in your book:

 

function my_error_handler($e_number, $e_message, $e_file, $e_line, $e_vars) {

$message = "An error occured in script '$e_file' on line $e_line: $e_message\n<br />";

$message .= "Date/Time: " . date('d-j-Y H:i:s') . "\n<br />";

$message .= "<pre>" . print_r($e_vars, 1) . "</pre>\n</p>";

 

if (!LIVE) {

echo $message;

}

else {

@mail(ADMINEMAIL, 'Site Error', $message);

 

if($e_number != E_NOTICE) {

echo "<div id=\"error\">A system error occurred.</div>";

}

}

}

 

set_error_handler('my_error_handler');

 

It may handle errors as they happen in something like this one:

 

$r = mysqli_query($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " .mysqli_error($dbc));

 

My question is: How about the prepared statments? Can be something like:

 

mysqli_stmt_execute($stmt) or trigger_error("Query: $q\n<br />MySQL Error: " .mysqli_error($dbc));

 

or should we use mysqli_stmt_error($stmt) and mysqli_stmt_errno($stmt)? Or maybe it is not necessary to do anything? Bottom line: how do we handle errors when using prepared statements?

 

Thank you.

[Larry]

The short answer is that you can use mysqli_error(), but I'll write something more formal up and share that with you in a couple of days.

[masterlayouts]

mysqli_stmt_execute($stmt) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_stmt_errno($stmt) . ": " . mysqli_stmt_error($stmt));

 

This seems to work fime. Do I have to modify something else in your function?

[Larry]

No, that looks fine, although the $q variable may not be too useful here.