php mysql错误处理在错误页面中显示错误

Question

$postQuery = $conn->query("SELECT * from table_name order by column desc")or die(mysql_error());

When there is error in query it ends the control and shows the error message in same page..

i want to redirect to an error page when error occurs and display the error in that page.

here is my Code :

$conn = new mysqli($host, $user, $password, $database);
    if ($conn->connect_error) {
        header("Location: ".SITEURL."/error.php?message=" . url_encode($conn->connect_error));
    } 

Any Suggestion.

Answer 1

When your mysql query fails, it returns a False, and the connection holds the error data, which you can reference as such:

if (!$conn->query("SELECT * from table_name order by column desc")) {
  header("Location: http://www.yoursite.com/error.php?errormessage=" . url_encode($conn->error));
}