PHP: A clean way of converting an array

Question

What is a clean way to convert an array that looks like this:

[584] => Array ( [link_id] => 1   [site_id] => 5     [COUNT(*)] => 2 )
[585] => Array ( [link_id] => 243 [site_id] => 5     [COUNT(*)] => 2 ) 
[586] => Array ( [link_id] => 522 [site_id] => 89223 [COUNT(*)] => 3 )

To an array where the key is the site_id from above, so for the above example the resulting array would be:

[5] => Array( 1, 2, 243, 2) //Even ones and 0 are link_id, odd ones are count(*)  
[89223] => Array(522, 3)

So, basically, group them by site_id. I still need to keep the relationship between link_id and count(*), in the case above I am doing it by the positions (so 0 and 1 are together, 2 and 3, etc) but I am open to a new structure as well.

Thanks!

Whatever you are doing looks incorrect. Rather than answering this, can you explain what you are trying to do? — Xeoncross
– Xeoncross, Commented Aug 9, 2011 at 16:32
Got that from a mysql query, and since the other table is in a non-federated table on another server, I need to get some values by hand; in this case, I am in need of grouping by site_id and keeping the relationship between link_id and count(*) in order to do operations with them. — luqita
– luqita, Commented Aug 9, 2011 at 16:45

hakre · Accepted Answer · 2011-08-09 16:37:06Z

3

You mean something like this? (Demo):

$out = array();
foreach($input as $v)
{
    $site_id = $v['site_id'];
    unset($v['site_id']);
    $out[$site_id][] = $v;
}

Or in case you prefer value pairs after each other (Demo):

    ...
    unset($v['site_id']);
    $out[$site_id][] = array_shift($v);
    $out[$site_id][] = array_shift($v);
} ...

edited Aug 9, 2011 at 16:37

answered Aug 9, 2011 at 16:31

hakre

200k55 gold badges454 silver badges865 bronze badges

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

Collectives™ on Stack Overflow

PHP: A clean way of converting an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related