<?php
try {

    $host = 'localhost';      
    $port = '5432';           
    $dbname = 'BookTracker';  
    $username = 'postgres';
    $password = '1';

    $conn = new PDO("pgsql:host=$host;port=$port;dbname=$dbname", $username, $password);

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


} catch (PDOException $e) {

    echo "Connection failed: " . $e->getMessage();
    exit();
}
?>