use array_multisort in multidimensional array

Question

I have an array A with these value

array(
  0 => 'D003',
  1 => 'P001',
  2 => 'P002',
  3 => 'D001'
);

and I have another multidimensional array B with these values

 array(
      0 => 
        array(
          'waypoint_id' => 'D001',
          'count' => '5'),
      1 => 
        array(
          'waypoint_id' => 'D003',
          'count' => '1'),
      2 => 
        array(
          'waypoint_id' => 'P001',
          'count' => '2'),
      3 => 
        array(
          'waypoint_id' => 'P002',
          'count' => '1')
    );

how to use array_multisort so that I can get my array B to be like these (same order as array B)

  array(
      0 => 
        array(
          'waypoint_id' => 'D003',
          'count' => '1'),
      1 => 
        array(
          'waypoint_id' => 'P001',
          'count' => '2'),
      2 => 
        array(
          'waypoint_id' => 'P002',
          'count' => '1'),
      3 => 
        array(
          'waypoint_id' => 'D001',
          'count' => '5')
    );

George Brighton · Accepted Answer · 2014-02-21 22:16:30Z

2

I'm not sure array_multisort() can help you here, as the contents of A aren't in any obvious order.

I'd do it by indexing B by waypoint purely for efficiency, and then creating a new $ordered array from A:

$indexed = array();
foreach($b as $array) {
    $indexed[$array['waypoint_id']] = $array;
}

$ordered = array();
foreach($a as $waypoint) {
    $ordered[] = $indexed[$waypoint];
}

answered Feb 21, 2014 at 22:16

George Brighton

5,1719 gold badges30 silver badges36 bronze badges

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

2 Comments

od3n Over a year ago

yeah this works. i thought array_multisort can be used to solve this. many thanks

Amal Over a year ago

I like this approach. +1

user21926 · Accepted Answer · 2014-02-21 22:16:53Z

0

$result = array();

foreach ($A as $search) {
    foreach ($B as $elt) {
        if ($elt['waypoint_id'] === $search) {
            array_push($result, $B);
            break;
        }
    }
}

var_dump($result);

answered Feb 21, 2014 at 22:16

user21926

Collectives™ on Stack Overflow

use array_multisort in multidimensional array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related