On Wednesday 22 January 2003 19:11, Andy Clarke wrote:
> Is there a way to get a database query to fail gracefully, so that rather
> than calling Die(), it can work around the problem? In other words, to do
> something like:
>
> if (mssql_connect($sDBhostname,$sDBusername,$sDBpassword)) {
>     // connection ok - work with it
> } else {
>     // database down - work around it
> }
> // continue with rest of page
>
> Rather than using the following, which causes the page to quit in mid flow:
>
> mssql_connect($sDBhostname,$sDBusername,$sDBpassword) or die("DATABASE
> FAILED TO RESPOND.");

Obviously, quite simply, don't use die(). Instead call a function which can 
handle it:

It really depends on what your needs are and what the page does. The most 
simple case is print a message informing the user that "the database is down 
please try again later" (or words to that effect). At the same time you would 
log this failure (to a log file) and/or email someone responsible who can 
deal with it.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

/*
Traveling through hyperspace isn't like dusting crops, boy.
                -- Han Solo
*/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to