How can PHP be used to check if a local database is online before redirecting to it?

To check if a local database is online before redirecting to it in PHP, you can use a try-catch block to establish a connection to the database. If the connection fails, you can handle the error and redirect the user to an error page or display a message indicating that the database is offline. 

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // Database is online, redirect to it
    header("Location: http://localhost/database");
} catch (PDOException $e) {
    // Database is offline, handle error
    header("Location: http://localhost/error");
}
?>

Keywords

PHP database connection server availability error handling redirection

Related Questions