How do I re-sort an array base on another array?

Question

Example:

$arr = array('willion','kevien','john','smith');

$orderedArr = array('anne','bold','hellen','john','kevien','polm','smith','willion');

And I want to resort the $arr order based on $orderdArr order. How do I do that?

The result I expect:

'john','kevien','smith','willion'

the $orderedArr may be changed in order,So I want the $arr's order to be the same as $orderedArr.

I am sorry for simplifed my question.I think my $arr is much more complexity,the $arr's strucuture is: I use print_r() to show the array.

array（ [0] => array（[id]=>1 [name]=>willion）
        [1] => array（[id]=>2 [name]=>kevien）
        [2] => array（[id]=>3 [name]=>join)
      )

Thank you very much!

What would be the expected result ....

Baba
– Baba

2013-06-06 08:55:50 +00:00
Commented Jun 6, 2013 at 8:55 — Baba
– Baba, Commented Jun 6, 2013 at 8:55

Baba · Accepted Answer · 2013-06-06 09:01:20Z

3

You can use usort

$order = array_flip($orderedArr);
usort($arr, function ($a, $b) use($order) {
    return $order[$a] - $order[$b];
});
print_r($arr);

Output

Array
(
    [0] => john
    [1] => kevien
    [2] => smith
    [3] => willion
)

See Live DEMO

answered Jun 6, 2013 at 9:01

Baba

95.3k29 gold badges172 silver badges222 bronze badges

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

Comments

George · Accepted Answer · 2013-06-06 09:00:40Z

1

use foreach() on the ordered array, append the values to a new array, but only if the exist in the original:

$arr = array('willion','kevien','john','smith');
$orderedArr = array('anne','bold','hellen','john','kevien','polm','smith','willion');

foreach($orderedArr as $key => $value){
    if(in_array($value, $arr)){
        $newArr[] = $value;
    }
}

Outputs:

Array ( [0] => john [1] => kevien [2] => smith [3] => willion )

answered Jun 6, 2013 at 9:00

George

36.8k9 gold badges70 silver badges109 bronze badges

Comments

cmbuckley · Accepted Answer · 2013-06-06 09:16:44Z

1

Assuming $arr is always a subset of $orderedArr, you can use array_intersect:

$arr = array_intersect($orderedArr, $arr);
// $arr is now ['john', 'kevien', 'smith', 'willion']

edited Jun 6, 2013 at 9:16

answered Jun 6, 2013 at 8:57

cmbuckley

43k10 gold badges83 silver badges95 bronze badges

4 Comments

qinHaiXiang Over a year ago

Yes, $arr always a subset of $orderedArr.

cmbuckley Over a year ago

Just a simple intersect then :)

qinHaiXiang Over a year ago

but the $arr is a multi-dimention array,so..not the same data structure of the $orderedArr

cmbuckley Over a year ago

@qinHaiXiang it wasn't in the original question :)

Bere · Accepted Answer · 2013-06-06 09:39:42Z

1

If you don't want the id->name association of the $arr array you can simply do this.

$to_be_sorted=array();
foreach($arr as $key=>$person)
{
    $to_be_sorted[]=$person['name'];
}

$sorted = array_intersect($orderedArr, $to_be_sorted);

echo implode(",",$sorted);

edited Jun 6, 2013 at 9:39

answered Jun 6, 2013 at 9:01

Bere

1,7472 gold badges17 silver badges23 bronze badges

Comments

Fabio · Accepted Answer · 2013-06-06 09:07:53Z

0

I think you can loop in your order array and comparing to your array using in_array to build a new array in required order

$arr = array('willion','kevien','john','smith');

$orderedArr = array('anne','bold','hellen','john','kevien','polm','smith','willion');

$orderedUsers = array();
foreach ($orderedArr as $data) {
    if(in_array($data,$arr))
    {
        $orderedUsers[] = $data;
    }
}

this will output

array (size=4)
  0 => string 'john' (length=4)
  1 => string 'kevien' (length=6)
  2 => string 'smith' (length=5)
  3 => string 'willion' (length=7)

Live Demo

edited Jun 6, 2013 at 9:07

answered Jun 6, 2013 at 9:01

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Collectives™ on Stack Overflow

How do I re-sort an array base on another array?

5 Answers 5

Comments

Comments

4 Comments

Comments

Live Demo

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related