Generating an array from a pair of columns

…By default, the PDO fetch and fetchAll methods return each row of…a result set as an array indexed both by column name and number.…But you can modify this behavior in interesting ways.…This is pdo_array.php, which you can find in the…chapter four, 04_01 folder of the exercise files.…On line 4, there's a simple select query…that selects name and meaning from the names table.…The query is then executed on the following line and on line 6,…the results are stored as an array called names using the fetchAll method.…

Let's inspect the content of the names array…with print_r to make it easier to read.…We'll start off with a pre tag, then print_r.…We'll pass it names, that array, and then a closing pre tag.…So if we save that page and then load it into a…browser, the result is a multidimensional array with each value listed twice.…Let's say you wanted to turn this into an associative array…using each name as the key and the meaning as the value.…

One way to do that would be to loop through each sub-array and use the…