Using IF conditional statements with PDO

I have a connection to a database that looks something like this:

$data_source_name = "mysql:host=$db_host;dbname=$db_name";

$database_connection = new PDO($data_source_name, $db_username, $db_password);

The execution looks something like this:

$stmt= $database_connection->prepare($sql);

$stmt->execute([$name, $email]);

I’m trying to set up a condition like this:

if ( database connection fails ) {
   // error handling
}

But this code doesn’t work.

if ( !$database_connection ) {
     // error handling
} else {
    $stmt= $database_connection->prepare($sql);
    $stmt->execute([$name, $email]);
}

This if construct works in MySQL and MySQLi, but not PDO. Any guidance appreciated. Thanks.

>Solution :

new PDO raises an exception if the connection fails. Use an exception handler:

try {
    $database_connection = new PDO($data_source_name, $db_username, $db_password);
} catch (PDOException $e) {
    // error handling
}