If there is a sql error redirect to a page

[Vivid Lust]

If there is a sql error redirect to a page...

 

Anyway to do this???

 

such that:

 

<?php
if(SQL ERROR){
header('location:http://foo.com');
}

 

Thanks if you know if there is anyway to do this.

[phoenixx]

// Here is the function. This function must be placed before any HTML code or

// else the redirect will not work. You could place it in a separate file and

// use include.

function dbconnect($hostname, $username, $password, $database) {

$conn = @mysql_pconnect($hostname, $username, $password); // "@" is

necessary.

if(!$conn) header("Location: error.html");

if(!mysql_select_db($database, $conn)) header("Location: error.html");

}

 

 

[Vivid Lust]

I just have clarified a specific error, the error is when an illegal character is trying to be added as a table name and there is an error ... any ideas on how to redirect that?

[revraz]

When you do your query, use a result and if there is an error send them to a error page.

[obsidian]

The best way to handle specific errors is to use PHP5 and take advantage of Exception handling. This makes your life incredibly easier. Here is a very simplistic example of error handling to do what you are after:

<?php
/**
* Define your DBException class to trap DB errors
*/
class DBException extends Exception {}

try {
  if (mysql_connect(/* your connection info */) === FALSE)
  {
    throw new DBException('connection_error.php');
  }
} catch (DBException $e) {
  $file = $e->getMessage();
  header("Location: $file");
  exit;
} catch (Exception $e) {
  die('Unexpected error encountered: ' . $e->getMessage());
}
?>

 

Of course, a much better way to handle things would be to assign the error numbers to anything you wish and handle all the exceptions by error number rather than passing the filename through the message string, but this at least gives you the principle of exception handling.