php mysql error handling display in error in error page

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.

Yes @Ghost. but how can i send error information to another page.? — Snopzer
– Snopzer, Commented Oct 4, 2016 at 11:22

Rohith K N · Accepted Answer · 2016-10-04 07:54:31Z

2

This is a very general error handler, suitable for any type of errors

Add this in the page where error is being generated

 //error handler function
 function customError($errno, $errstr) {
       $errorpage= "Location:error.php?&err=".$eerrno." ". $errstr;
 }

 //set error handler
 set_error_handler("customError");

Now make the page to display your error,

error.php

<?php
$err=$_GET['err'];
echo $err;
?>

answered Oct 4, 2016 at 7:54

Rohith K N

8916 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Henrik · Accepted Answer · 2016-10-04 07:08:04Z

1

try {
    $postQuery = $conn->query("SELECT * from table_name order by column desc")or die(mysql_error());
} catch (MySQLException $e) {
    header("Location: http://example.com/");
}

If you get another error than MySQLException, then just replace that exception.

answered Oct 4, 2016 at 7:08

Henrik

1895 bronze badges

Comments

Caleb · Accepted Answer · 2016-10-04 07:07:37Z

0

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));
}

answered Oct 4, 2016 at 7:07

Caleb

2,3082 gold badges17 silver badges16 bronze badges

Collectives™ on Stack Overflow

php mysql error handling display in error in error page

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related