将DB记录作为数组键的最简单方法[重复]

Question

This question already has an answer here:

• PHP - Make my query's array's key the ID 2 answers

What is the easiest and fastest way to get or manipulate the MySQL result with id values as keys in PHP? I know we can simply loop through the entire result set and so on. But what is the fastest and also the simplest way of doing this?

That is to convert,

Array
(
    [0] => Array
        (
            [id] => 1
            [user_name] => user1
        )

    [1] => Array
        (
            [id] => 3        
            [user_name] => user3
        )

)

to this.

Array
(
    [1] => Array
        (
            [id] => 1
            [user_name] => user1
        )

    [3] => Array
        (
            [id] => 3        
            [user_name] => user3
        )

)

This question may face some downvotes. But still, i think any answer on this would be helpfull to many.

</div>

Answer 1

Use array_column()

$new_array = array_column($old_array, NULL, 'id');
print_r($new_array);