@ 2013-07-31T18:00:39Z <?php
// Everything you enter here will be executed by our servers. Try it!
$data = array(
array(
'id' => 1,
'name' => 'bob',
'product_id' => 1,
'product' => 'laptop',
'price' => 999,
),
array(
'id' => 1,
'name' => 'bob',
'product_id' => 2,
'product' => 'mouse',
'price' => 15,
),
array(
'id' => 1,
'name' => 'bob',
'product_id' => 3,
'product' => 'keyboard',
'price' => 25,
),
array(
'id' => 2,
'name' => 'steve',
'product_id' => 1,
'product' => 'book',
'price' => 5,
),
array(
'id' => 2,
'name' => 'steve',
'product_id' => 2,
'product' => 'mouse',
'price' => 15,
),
array(
'id' => 2,
'name' => 'steve',
'product_id' => 3,
'product' => 'keyboard',
'price' => 25,
)
);
$output = array();
$userColumnIntersect = array_flip(array(
'id',
'name',
));
$productColumnIntersect = array_flip(array(
'product',
'price',
));
foreach($data as $row){
$id = $row['id'];
if(!isset($output[$id])){
$output[$id] = array_intersect_keys($row, $userColumnIntersect);
$output[$id]['products'] = array();
}
$productId = $row['product_id'];
if(!isset($output[$id]['products'][$productId])){
$productDataRow = array_intersect_keys($row, $productColumnIntersect);
$output[$id]['products'][$productId] = $productDataRow;
}
}
echo '<pre>';
print_r($output);
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.20 , 7.1.0 - 7.1.33 , 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.6 Fatal error: Uncaught Error: Call to undefined function array_intersect_keys() in /in/P5AAI:68
Stack trace:
#0 {main}
thrown in /in/P5AAI on line 68
Process exited with code 255 . Output for 5.0.0 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.24 - 5.5.35 , 5.6.7 - 5.6.28 Fatal error: Call to undefined function array_intersect_keys() in /in/P5AAI on line 68
Process exited with code 255 . Output for 4.4.5 - 4.4.9 Fatal error: Call to undefined function: array_intersect_keys() in /in/P5AAI on line 68
Process exited with code 255 . Output for 4.3.2 - 4.3.11 , 4.4.0 - 4.4.4 Fatal error: Call to undefined function: array_intersect_keys() in /in/P5AAI on line 68
Process exited with code 255 . Output for 4.3.0 - 4.3.1 Fatal error: Call to undefined function: array_intersect_keys() in /in/P5AAI on line 68
preferences:dark mode live preview
331.23 ms | 401 KiB | 344 Q