Looping through arrays efficiently

Question

I have an array like this:

[1] => Array
        (
            [id] => 7
            [ticket_id] => 12
            [client_id] => 174
            [thread_name] => 
            [added_by] => 2
            [created_at] => 2015-07-28 23:24:07
            [updated_at] => 2015-07-28 23:24:07
            [notes] => Array
                (
                    [0] => Array
                        (
                            [id] => 21
                            [user_id] => 2
                            [notes] => Not all those who wander are lost!
                            [notes_attachment] => 
                            [deleted_at] => 
                            [created_at] => 2015-07-28 23:34:31
                            [updated_at] => 2015-07-28 23:34:31
                            [thread_id] => 7
                            [users] => Array
                                (
                                    [0] => Array
                                        (
                                            [user_id] => 1
                                        )

                                    [1] => Array
                                        (
                                            [user_id] => 2
                                        )

                                )

                        )

                )

        )

And I need to manipulate the users array in the notes array to something like this.

[users] => Array
(
[0] => 1
[1] => 2
)

So, basically, I need an array for ids in the users array.

I tried doing it, but it takes three loop to get into users.

How can I do that more efficiently ??

NOTE: This is just one of the structure from multiple arrays. Like, I have 4 threads and multiple notes in each of them.

Also, I need to manipulate the existing array and not just take the data from it.

My attempt:

$tmp = array();
        foreach($data as $value) {
            foreach($value['notes'] as $notes) {
                if(!empty($notes['users'])){
                    foreach($notes['users'] as $users) {
                        $tmp[] = $users['user_id'];
                        unset($notes['users']);
                        $notes['users'] = $tmp;
                    }
                }
            }
        }

There isn't really any faster way to do this unless you format your data differently or you know the id of the notes array you want. — Ethan22
– Ethan22, Commented Jul 29, 2015 at 4:59
This is the array I get using Eloquent in Laravel. It serves the purpose, but there's this little tweak I need to do for users. — nirvair
– nirvair, Commented Jul 29, 2015 at 5:08

Sougata Bose · Accepted Answer · 2015-07-29 05:16:24Z

1

Use array_column -

$new = array_column($a[notes][0]['users'], 'user_id');
var_dump($new);

Output

array(2) {
  [0]=>
  int(1)
  [1]=>
  int(2)
}

DEMO

Update

$new = array();
foreach($a as $value) {
    $new = array_merge($new, array_column($value[notes][0]['users'], 'user_id'));
}
var_dump($new);

edited Jul 29, 2015 at 5:16

answered Jul 29, 2015 at 5:00

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Ethan22 Over a year ago

From the question it sounds like he doesn't know the id of the users array, thus the need to loop through them

Sougata Bose Over a year ago

@Ethan22 If the array structure is this then no loop needed. You can check the demo.

nirvair Over a year ago

I don't this will work. I mean there are some 100's of entries having users in it.

Ethan22 Over a year ago

True, if it is like this. I just assumed from the ` [notes] => Array ( [0] => Array` that there was a possibility of a [1] etc.

Ethan22 Over a year ago

Ah, good point @b0s3. He could loop through using $a[notes][$i]

|

Collectives™ on Stack Overflow

Looping through arrays efficiently

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related