PHP Redirect On Database Connect Fail

[CarpeCodice]

Hi!

I have the following code in admin/config/dbcon.php which establishes a connection to a database called "costing".

<?php

  $host = "localhost";
  $username = "root";
  $password = "";
  $database = "costing";

  $con = mysqli_connect("$host","$username","$password","$database");

  if(!$con) {
    header("Location: ../errors/dberror.php");
    die();
  }

?>

The admin/config/dbcon.php is called as an 'include' in the admin/index.php file:

<?php
  include('config/dbcon.php');
?>

If the connection fails, what I want to happen is to be redirected to ../errors/dberror.php - but it does not. Instead of redirecting, it simply gives me a fatal error message on the page (tested by changing the database name in the above code to something else): Fatal error: Uncaught mysqli_sql_exception: Unknown database 'costingblahblah'...

Below is the file structure where you can see the 3 files mentioned in this thread:



Any help would be greatly appreciated!

Thank you in advance.

 

[OldMan]

You might try the "set_error_handler"
Or use the try - catch method.
Never done them myself because I only had one DB and loss of it IS a fatal error and things should be shut down (in my case anyway).

 

[DaniWeb]

You have to redirect to a fully qualified URL. For example:

header("Location: https://www.example.com/error_page.php");
die();

Also, make sure that there are never any echo statements or content outputted to the browser anywhere in your code before this header(). You will get a PHP fatal error if you try to echo HTML to the web browser before all header() calls are done with.

 

[CarpeCodice]

You have to redirect to a fully qualified URL. For example:

header("Location: https://www.example.com/error_page.php");
die();

Also, make sure that there are never any echo statements or content outputted to the browser anywhere in your code before this header(). You will get a PHP fatal error if you try to echo HTML to the web browser before all header() calls are done with.

Thank you very much, and apologies for the late reply. It worked with a fully qualified URL as you suggested.