database error handling using php

[jodunno]

Hello everyone,

quick description of 'error handling' so that everyone understands the solution i am seeking. let php and the database handle the error is not an appropriate answer here.

find out what i mean: using xampp, go to a login screen of your website, then turn off the database before submitting the login data. the connection will be attempted then fail. the browser will display its own error page which is white bg with a message. this is ridiculous. i made a custom handler that allows me to ignore this failure and show my own website with an error message.

now how can i detect an error with a select or update statement? i am not a db designer, so i really don't know how to do it. what say i fetch filed['testmyerror'] and it doesn't exist or there is a problem. how do i write php code that is used to ignore this problem and display my own message. naturally i will log the error and/or log and send email to myself.

anyone able to help? just a tip in the right direction?

Thank you very much, i appreciate this forum and its members always.

[benanamen]

You can use set_exception_handler to create a custom exemption function.

https://www.php.net/manual/en/function.set-exception-handler.php

 

 

 

[jodunno]

Hello benanamen,

Thank you very much. I didn't know that i could do custom handling. I should probably read the php manual a little closer. My apologies for this lack of knowledge.

Best wishes.

[benanamen]

3 hours ago, benanamen said:

custom exemption function

Ooops, meant exception.

[kicken]

Alternatively, configure your web server to show a particular page on error.  For apache you might do for example

ErrorDocument 500 /500.html

Exact configuration will depend on your server version and setup.