How to Create an Associative Array from Database Rows in PHP?

Creating Associative Arrays from Data

When working with data from a database or other source, it can be necessary to create an associative array from a collection of rows. An associative array is a data structure that uses one column as keys and another column as values, allowing for easy retrieval of specific values based on the corresponding key.

To achieve this, we can utilize the array key-value assignment syntax in PHP. Consider the following MySQL result set:

To generate an associative array, we can loop through the result set and assign each row's 'id' value to be the array key, and the 'data' value to be the array value. Using the correct syntax:

This will result in the following associative array:

By using this approach, we can efficiently create associative arrays from data rows, providing an organized and flexible way to access values by their associated keys.

The above is the detailed content of How to Create an Associative Array from Database Rows in PHP?. For more information, please follow other related articles on the PHP Chinese website!