Hey everyone!
I'm building a webapp in PHP that uses a MySql DB. What I want to do is for example when someone tries to access to a page, but the DB throws an error, to display a HTML (or redirect) page with the HTTP code 500. Something like the "fail whale" in Twitter.
Is that possible?
views:
39answers:
2
+2
A:
You could use the die function in PHP to do this like so.
mysql_connect("details go here")or die(require("failed.php"));
That will attempt to connect to your database and if it fails will require another file, you could also create a function that redirects users and stick that inside the die() function and simply redirect them to another page, either way that's how you would send users away upon an error with the connection.
Tom Walters
2010-10-26 16:46:24
But If I do this, and the failed.php has the `header("Location /path/to/anything"); ` it outputs "Cannot modify header information - headers already sent"
Francesc
2010-10-26 16:59:10
Well you could redirect using JavaScript or a meta tag instead, so put a function name inside the brackets and then do the following - function redirect(){ echo '<meta http-equiv="refresh" content="0;url=http://example.com/failed.php">' }
Tom Walters
2010-10-26 17:01:29
at first output php generates headers and sends them to the client. if ou make any output and afterwards try to do a header() then you will get the error you just got
ITroubs
2010-10-26 17:10:03
A:
If there is an error in mysql it will return FALSE instead of a resource. You can then do the following to test and conditionally redirect:
// This also works for mysql_connect( ... ); and all other <dbtype>_<command>
// functions, including MySQLi, Oracle, and PSQL extensions.
$cond = mysql_query( $resource, $query );
if( $cond === FALSE )
{
// You can replace this with any other error handling you'd like.
header( "Location: url/of/error/page" );
die();
}
Christopher W. Allen-Poole
2010-10-26 16:47:10
SELECT * FROM pages WHERE name='Bunny' won't be an error as far as i know and so will return true. i think OP want's to know how to redirect if there are no matching lines in his database
ITroubs
2010-10-26 16:50:49
@ITroubs If he has another condition where the DB isn't throwing an error (and that is the OP's question), then he can replace <code>$cond === FALSE</code> with something like <code>mysql_count_rows( $cond ) == 0</code>. But, that is not the question he asked.
Christopher W. Allen-Poole
2010-10-26 16:57:47