How to Efficiently Fetch Associative Arrays from Database Key-Value Pairs Using PDO

Associative Array Fetching from Database Key-Value Pairs

This issue pertains to extracting data from a database where the query produces key-value pairs and the desired output is an associative array with the key and value as respective array entries.

The common approach involves fetching the data in a flat array using PDO::FETCH_ASSOC and then manually constructing the associative array using a loop. However, a more efficient solution exists.

Using PDO::FETCH_KEY_PAIR instead of PDO::FETCH_ASSOC directly accomplishes the desired result. This method groups the key-value pairs into an associative array, eliminating the need for manual array creation.

Example:

<code class="php">$q = $db->query("SELECT `name`, `value` FROM `settings`;");
$r  = $q->fetchAll(PDO::FETCH_KEY_PAIR);</code>

This approach is both efficient and concise, providing a convenient way to retrieve associative arrays from database queries.

The above is the detailed content of How to Efficiently Fetch Associative Arrays from Database Key-Value Pairs Using PDO. For more information, please follow other related articles on the PHP Chinese website!