Hey Jeff! Thanks for this neat episode I love setting up configuration files for my app.

I noticed that I get an error when I add an underscore in the associative array keys as in:

    'database' => [
        'host' => 'localhost',
        'port' => '3306',
        'db_name' => 'learnphp',
        'charset' => 'utf8mb4'
    ]

I would get the following error:

[500]: GET / - Uncaught PDOException: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in C:..\Database.php:25

Which point to the query execution line

$statement->execute();

Are there perhaps an http_build_query() alternative?

UPDATE: I fixed it by using str_replace() function like this:

$config = [
            'host' => 'localhost',
            'port' => '3306',
            'db_name' => 'learnphp',
            'charset' => 'utf8mb4'
        ];
        $dsn = 'mysql:' . http_build_query($config, '', ';');

        $dsn = str_replace('_', '', $dsn);

PS: I realized that it wouldn't work because it has to be dbname= for the dsn to work

Environments and Configuration Flexibility