Easiest way to make DB records as array keys

Question

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.

SajithNair · Accepted Answer · 2014-03-05T09:22:24.803

2

Use array_column()

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

edited Mar 05 '14 at 09:22

answered Mar 05 '14 at 09:11

SajithNair

3,867
1
17
23

3

Set the second parameter to NULL to keep the id in the result – Robin Webdev Mar 05 '14 at 09:13
No, then the `key` will be dropped and array will be zero indexed – SajithNair Mar 05 '14 at 09:15
He wants `id` to be used as key for the new array – SajithNair Mar 05 '14 at 09:15
Oops yes thats right, I will update my answer – SajithNair Mar 05 '14 at 09:21

score 1 · Answer 2 · answered Mar 05 '14 at 09:06

1

So construct the array by using the id as key.

$result = array();
while ($row = db_dummy_fetch_method($res)) {
    $result[$row['id']] = $row;
}

answered Mar 05 '14 at 09:06

xdazz

158,678
38
247
274

Easiest way to make DB records as array keys

2 Answers2