disable MySql errors

Question

Is there any way to prevent MySql errors (if happened) from appearing to the client, and just log them somewhere ?

Note 1: Am not using any frameworks, just native PHP with PDO extinsion and MySql.

Note 2: This code will stop PHP errors, not MySql.

ini_set('display_errors', 0);
ini_set("display_startup_errors", 0);
error_reporting(0);

Example:

disabling errors like

SQLSTATE[HY000] [1045] Access denied for user ..

Use @ and errors will not show up but you should prevent errors from happening — Tom
– Tom, Commented Jul 11, 2018 at 18:54
That will only display if you echo mysqli_connect_error($link);, so don't do that. — AbraCadaver
– AbraCadaver, Commented Jul 11, 2018 at 18:54

AbraCadaver · Accepted Answer · 2018-07-11 19:18:31Z

0

For non-PHP errors, the application (programmer) is responsible for obtaining and displaying/logging the error. So for your specific example, don't display it, log it:

//instead of displaying
if (!$link) {
    die(mysqli_connect_error());
}

//log it
if (!$link) {
    error_log(mysqli_connect_error());
}

You could also us trigger_error that would respect your error reporting settings:

if (!$link) {
    trigger_error(mysqli_connect_error(), E_USER_ERROR);
}

edited Jul 11, 2018 at 19:18

answered Jul 11, 2018 at 19:09

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

shamaseen Over a year ago

So in the case of PDO there is "PDO::ATTR_ERRMODE", but i notice that give it PDO::ERRMODE_SILENT value still show sql errors when happens .. is there a way to stop it ?

AbraCadaver Over a year ago

PDO::ERRMODE_SILENT is default and does not display, you would need to set PDO::ERRMODE_WARNING or PDO::ERRMODE_EXCEPTION to have it display something. Somwhere the code is either displaying the error or telling PHP to generate one.

shamaseen Over a year ago

Yes, i found that I'm printing the error in try catch with getMessage() method. Thank you !

Collectives™ on Stack Overflow

disable MySql errors

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related