如何仅在一个数组中从数据库返回值

Question

I was looking for a solution for a config/details file. I found this solution interesting, but instead of hardcode the values, I would like to retrieve them from a database.

I'm new to PDO as well, but my solution, for now, is as follow (config.php):

try {
    $db = new PDO('mysql:host=localhost;dbname=dbname;charset=utf8', 'user', 'pwd');
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $db->query("SELECT name, value FROM config");
    $configs = $stmt->fetchAll();

    return [
        array_column($configs, 'value', 'name')
    ];

} catch(PDOException $e) {
    echo "Error: ".$e->getMessage();
}

Then I get a response like this:

Array ( [0] => Array ( [SITENAME] => Pionérhytta [MAXGUESTS] => 5 ) )

And I would need to write like this to get value out (index.php):

<?php $config = include('../config/config.php'); ?>
...
<?=$config[0]['SITENAME']?>

This works, but I would like to remove the [0] and write $config['SITENAME'] to get the value.

Is there any solution for this?

In advance, thanks for the help

Answer 1

Your array_column() returns an associative array. It is not necessary to wrap it in another array:

return array_column($configs, 'value', 'name');