query array into multi-dimensional array

Question

So I'm trying to run a query and when I get the array, I want to reorganize it. Or can I possibly run a query to get the result that I want? Basically how can I get this array:

array() {
 [0] => array() {
  UID    => 1,
  gameid => 334613
 },
 [1] => array() {
  UID    => 2,
  gameid => 704234
 },
 [2] => array() {
  UID => 3,
  gameid => 704234
 }
}

to become this:

$array = array (
    (334613) => array (
        [0] => 1
    ),
    (704234) => array (
        [0] => 2,
        [1] => 3
    )
);

add your code here

Jalpesh Patel
– Jalpesh Patel

2018-05-22 05:17:32 +00:00
Commented May 22, 2018 at 5:17 — Jalpesh Patel
– Jalpesh Patel, Commented May 22, 2018 at 5:17

Eddie · Accepted Answer · 2018-05-22 05:28:12Z

2

You can use array_reduce

$arr = array(
    array(
      "UID"    => 1,
      "gameid" => 334613
    ),
    array(
      "UID"    => 2,
      "gameid" => 704234
    ),
    array(
      "UID" => 3,
      "gameid" => 704234
    )
);


$result = array_reduce($arr, function($c, $v){
    if( !isset( $c[ $v["gameid"] ] ) ) $c[ $v["gameid"] ] = array(); //Will also work without this line. 
    $c[ $v["gameid"] ][] = $v["UID"];       
    return $c;
}, array());

print_r( $result );

This will result to:

Array
(
    [334613] => Array
        (
            [0] => 1
        )

    [704234] => Array
        (
            [0] => 2
            [1] => 3
        )

)

Doc: array_reduce()

You can also use the classic foreach

$result = array();
foreach( $arr as $key => $val ) {
    $result[ $val["gameid"] ][] = $val["UID"];  
}

answered May 22, 2018 at 5:28

Eddie

26.8k6 gold badges39 silver badges59 bronze badges

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

Comments

Luffy · Accepted Answer · 2018-05-22 05:30:17Z

1

Simple foreach loop will do

$array = [ ... ]; // your array
$result = [];
foreach ($array as $game) {
    $result[ $game['gameid'] ][] = $game['UID'];
}

var_dump($result);

answered May 22, 2018 at 5:30

Luffy

1,0265 silver badges13 bronze badges

Collectives™ on Stack Overflow

query array into multi-dimensional array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related