Sort array according to first array

Question

I have this array $arr1

Array
(
    [0] =>  [col1]
    [1] =>  [col2]
    [2] =>  [col3]
)

I have another array $arr2 as

Array
(
    [0] => Array
        (
            [col3] => data1
            [col2] => data2
            [col1] => data3
        )

    [1] => Array
        (
            [col2] => data1
            [col3] => data2
            [col1] => data3
        )
)

I need to sort this $arr2 keys as col1, col2 and col3 like as it is on $arr1.

I tried with array_multisort($arr1,$arr2) and the other way. Nothing worked. any help on this ?

I think that you'll have to write your own sorting function, but i'm curious to know if there are better solutions — Mangiucugna
– Mangiucugna, Commented Jul 27, 2013 at 8:17
possible duplicate of Reference: all basic ways to sort arrays and data in PHP — deceze
– deceze ♦, Commented Jul 27, 2013 at 9:14

Shiplu Mokaddim · Accepted Answer · 2013-07-27 08:27:31Z

2

Using loop.

$keys = array_values($arr1);
$out = array();
foreach($arr2 as $ar){
    $outar = array();
    foreach($keys as $k){
        if(isset($ar[$k])){
            $outar[$k]=$ar[$k];
        }
    }
    $out[]=$outar;
}

The output array will be held in $out. See ideone.

edited Jul 27, 2013 at 8:27

answered Jul 27, 2013 at 8:18

Shiplu Mokaddim

57.5k20 gold badges147 silver badges193 bronze badges

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

3 Comments

smm Over a year ago

There is no foreach..in loop in php. It should be foreach..as

Shiplu Mokaddim Over a year ago

@smm right you are. Using too much python these days. Forgetting PHP. Added a ideone link that shows it works.

Orangepill Over a year ago

yours is considerably more efficient.

Orangepill · Accepted Answer · 2013-07-27 08:25:53Z

0

You can do this with uksort and a closure (PHP 5.3+)

foreach($arr2 as &$array){
    uksort($array,function($a,$b) use ($arr1){
        return array_search($a, $arr1) - array_search($b, $arr1);
    });
}

answered Jul 27, 2013 at 8:25

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

1 Comment

Shiplu Mokaddim Over a year ago

your algorithm has n*n*n*log(n) complexity. n is the length of first array.

Prasanth · Accepted Answer · 2013-07-27 08:29:36Z

0

foreach ( $arr2 as $k => &$arr ) {
    ksort($arr);
}
print_r($arr2);

Use ksort with a foreach loop with value passed by reference.

edited Jul 27, 2013 at 8:29

answered Jul 27, 2013 at 8:16

Prasanth

5,2962 gold badges31 silver badges62 bronze badges

4 Comments

Johnson Eddy Over a year ago

I need to sort $arr2 not $arr1.

Yoshi Over a year ago

ksort like any other in-place sorts in php will return a boolean indicating the success. Thus you're overwriting $arr.

Mangiucugna Over a year ago

and $arr2 needs to be ordered using information coming from $arr1

Johnson Eddy Over a year ago

@Prashanth, I don't see any comparison with $arr1 ?

vladkras · Accepted Answer · 2013-07-27 08:47:26Z

0

if first array values are exactly the same as indexes in second one, try

$resarr = array();
foreach ($arr2 as $somearr) {
    $i = 0;
    $newarr = array();
    foreach ($somearr as $value) {
        $newarr[$arr1[$i]] = $value;
        $i++;
    }
    $resarr[] = $newarr;
}
$arr1 = $resarr;

answered Jul 27, 2013 at 8:47

vladkras

17.2k4 gold badges50 silver badges55 bronze badges

Collectives™ on Stack Overflow

Sort array according to first array

4 Answers 4

3 Comments

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related