php - recreate array?

Question

I've "inherited" some data, which I'm trying to clean up. The array is from a database which, apparently, had no keys.

The array itself, is pretty long, so I'm simplifying things for this post...

[0] => Array
        (
            [id] => 2
            [uid] => 130
            [eid] => 8
            [ename] => Standard
            [eaction] => Check
        )
[1] => Array
        (
            [id] => 2
            [uid] => 110
            [eid] => 8
            [ename] => Standard
            [eaction] => Check
        )
[2] => Array
        (
            [id] => 2
            [uid] => 200
            [eid] => 8
            [ename] => Standard
            [eaction] => Check
        )

I'm trying to shift things around so the array is multidimensional and is grouped by ename:

[0] => Array
        (
            [Standard] => Array
            (
                 [id] => 2
                 [uid] => 130
                 [eid] => 8
                 [eaction] => Check
             ) 
        )
[0] => Array
        (
            [Standard] => Array
            (
                 [id] => 2
                 [uid] => 130
                 [eid] => 8
                 [eaction] => Check
             ) 
        )
[0] => Array
        (
            [Standard] => Array
            (
                 [id] => 2
                 [uid] => 130
                 [eid] => 8
                 [eaction] => Check
             ) 
        )

Anyone know how to do something like this?

Can you explain further? What is "Standard" and when are there more of them? Do you want to know how to transform your current array into the new one or just create the new one? — philfreo
– philfreo, Commented Dec 23, 2009 at 3:24
Your second example doesn't really make sense. The IDs are repeated (all 0) and I wouldn't describe that as multi-dimensional. Please clarify. — cletus
– cletus, Commented Dec 23, 2009 at 3:29

cletus · Accepted Answer · 2009-12-23 03:28:24Z

1

You can use usort() to sort an array by a user-defined function. That function could compare the ename fields. Then it's just a simple transformation. Like:

usort($array, 'cmp_ename');

function cmp_ename($a, $b) {
  return strcmp($a['ename'], $b['ename']);
}

and then:

$output = array();
foreach ($array as $v) {
  $ename = $v['ename'];
  unset($v['ename']);
  $output[] = array($ename => $v);
}

answered Dec 23, 2009 at 3:28

cletus

627k169 gold badges922 silver badges945 bronze badges

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

Comments

Amber · Accepted Answer · 2009-12-23 03:24:49Z

1

$outputarray = array();

foreach($inputarray as $value) {
  $outputarray[] = array($value['ename'] => $value);
}

would accomplish what your examples seem to indicate (aside from the fact that your 'result' example has multiple things all with key 0... which isn't valid. I'm assuming you meant to number them 0,1,2 et cetera). However, I have to wonder what benefit you're getting from this, since all it appears to be doing is adding another dimension that serves no purpose. Perhaps you could clarify your example if there are other things to take into account?

answered Dec 23, 2009 at 3:24

Amber

532k89 gold badges643 silver badges558 bronze badges

Comments

philfreo · Accepted Answer · 2009-12-23 03:28:50Z

0

$outputarray = array();

foreach($inputarray as &$value) {
  $outputarray[][$value['ename']] = $value;
  unset($value['ename']);
} unset($value);

answered Dec 23, 2009 at 3:28

philfreo

44.2k27 gold badges131 silver badges142 bronze badges

Comments

troelskn · Accepted Answer · 2009-12-23 09:31:35Z

0

I'm guessing that this is what you're asking for:

function array_group_by($input, $field) {
  $out = array();
  foreach ($input as $row) {
    if (!isset($out[$row[$field]])) {
      $out[$row[$field]] = array();
    }
    $out[$row[$field]][] = $row;
  }
  return $out;
}

And usage:

var_dump(array_group_by($input, 'ename'));

answered Dec 23, 2009 at 9:31

troelskn

118k27 gold badges135 silver badges156 bronze badges

Comments

Jaimz · Accepted Answer · 2009-12-24 06:36:08Z

0

philfreo was right but he was also off a little. with his code every time you encounter an array element with an ['ename'] the same as one you've already gone through it will overwrite the data from the previous element with the same ['ename']

you might want to do something like this:

$output = array();
foreach ($YOURARRAY as $value) {
    $output[$value['ename']][] = $value;
}
var_dump($output); // to check out what you get

answered Dec 24, 2009 at 6:36

Jaimz

8409 silver badges12 bronze badges

Collectives™ on Stack Overflow

php - recreate array?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related