Re-indexing an array by matching value

Question

I'm trying to manipulate the sorting order of an array. I would like to get the matching fruit - in this case the apple - as the third index on the array.

$array_fruit[] = array('fruit' => 'apple', 'color' => 'red');  
$array_fruit[] = array('fruit' => 'banana', 'color' => 'yellow');  
$array_fruit[] = array('fruit' => 'kiwi', 'color' => 'green');  
$array_fruit[] = array('fruit' => 'orange', 'color' => 'orange'); 
$array_fruit[] = array('fruit' => 'strawberry', 'color' => 'red'); 
$array_fruit[] = array('fruit' => 'lemon', 'color' => 'yellow');  

$i = 0;  

$array_inStock = array();  

foreach($array_fruit as $fruit)  
{  
    if($fruit['fruit'] == 'apple')  
    {  
        $array_inStock['3'] = array('fruit' => $fruit['fruit'], 'color' => $fruit['color']);  
    }  
    else  
    {  
        $array_inStock[$i] = array('fruit' => $fruit['fruit'], 'color' => $fruit['color']);  
    }  
    $i++;  
}  

asort($array_inStock);

print_r($array_inStock);

I don't understand what is going wrong here. Anybody an idea? Big regards.

Array ( [1] => Array ( [fruit] => banana [color] => yellow ) [2] => Array ( [fruit] => kiwi [color] => green ) [3] => Array ( [fruit] => orange [color] => orange ) ) — ian
– ian, Commented Apr 20, 2011 at 9:34

xkeshav · Accepted Answer · 2011-04-20 11:10:05Z

1

try this

although this is a lengthy way, but works perefect no matter where apple is currently

$array_stock =array();$i=0;
foreach($array_fruit as $k=>$v)
{
if($v['fruit'] =='apple')
    {
        $array_stock[3]=$v;
        if($k>3)
            array_push($array_stock,$array_fruit[3]);
        continue;
    }
if(array_key_exists($i,$array_stock))
{
    array_push($array_stock,$v);
}
else
{
    $array_stock[$i]=$v;
    $i++;
}
}

ksort($array_stock);
echo "<pre>";
print_r($array_stock);
echo "</pre>";

DEMO

edited Apr 20, 2011 at 11:10

answered Apr 20, 2011 at 10:49

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

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

2 Comments

ian Over a year ago

awesome, this solved the puzzle. Big thanks to all of you who have helped

xkeshav Over a year ago

@ian if apples come always on top [0] or before [3]`` then u can remove if($k>3) condition

boisvert · Accepted Answer · 2011-04-20 09:34:56Z

0

Am I misreading this or do your lines

$array_fruit[] = array('fruit' => 'apple', 'color' => 'red');  
$array_fruit[] = array('fruit' => 'banana', 'color' => 'yellow');
etc.

rewrite the contents of the array each time? Instead you want

$array_fruit[0] = array('fruit' => 'apple', 'color' => 'red');  
$array_fruit[1] = array('fruit' => 'banana', 'color' => 'yellow');
etc.

answered Apr 20, 2011 at 9:34

boisvert

3,7392 gold badges29 silver badges55 bronze badges

2 Comments

ian Over a year ago

No, the indexing adds up as your second example automatically

xkeshav Over a year ago

not necessary to assign index...it will automatically placed. read this : php.net/manual/en/language.types.array.php

Sanjay Mohnani · Accepted Answer · 2011-04-20 09:43:48Z

0

Try this :::

$array_fruit = array();  
$array_fruit[] = array('fruit' => 'apple', 'color' => 'red');  
$array_fruit[] = array('fruit' => 'banana', 'color' => 'yellow');  
$array_fruit[] = array('fruit' => 'kiwi', 'color' => 'green');  
$array_fruit[] = array('fruit' => 'orange', 'color' => 'orange');  

print_r($array_fruit);

$i = 0;  

$array_inStock = array();  

foreach($array_fruit as $fruit)  
{  
    if($fruit['fruit'] == 'apple')  
    {  
        $array_inStock['3'] = $fruit;  
    }  
    else  
    {  
        $array_inStock[$i] = $fruit;
        $i++;  
    }      
}  

asort($array_inStock);
print_r($array_inStock);

answered Apr 20, 2011 at 9:43

Sanjay Mohnani

1,0109 silver badges18 bronze badges

1 Comment

ian Over a year ago

the result is: Array ( [0] => Array ( [fruit] => banana [color] => yellow ) [1] => Array ( [fruit] => kiwi [color] => green ) [4] => Array ( [fruit] => lemon [color] => yellow ) [2] => Array ( [fruit] => orange [color] => orange ) [3] => Array ( [fruit] => strawberry [color] => red ) ) so there are no apples left

shadyyx · Accepted Answer · 2011-04-20 10:35:21Z

0

I suppose that going through the foreach loop has this events:

$i = 0, array('fruit' => 'apple', 'color' => 'red') is processed and $array_inStock['3'] = array('fruit' => 'apple', 'color' => 'red') is created
$i = 1, array('fruit' => 'banana', 'color' => 'yellow') is processed and $array_inStock['1'] = array('fruit' => 'banana', 'color' => 'yellow') is created
$i = 2, array('fruit' => 'kiwi', 'color' => 'green') is processed and $array_inStock['2'] = array('fruit' => 'kiwi', 'color' => 'green') is created
$i = 3 !!!, array('fruit' => 'orange', 'color' => 'orange') is processed and $array_inStock['3'] = array('fruit' => 'orange', 'color' => 'orange') is created that OVERWRITES the first processed array('fruit' => 'apple', 'color' => 'red')...

What You should do instead:

foreach($array_fruit as $fruit) {  
    if($fruit['fruit'] == 'apple') {  
        $array_inStock[3] = $fruit;
    } else if($i != 3) {
        $array_inStock[$i] = $fruit;
        $i++;
    }
}

This will end up with apple being the index 3...

edited Apr 20, 2011 at 10:35

answered Apr 20, 2011 at 9:43

shadyyx

16.1k7 gold badges62 silver badges98 bronze badges

11 Comments

ian Over a year ago

When there are more fruits the result ends up being this: Array ( [0] => Array ( [fruit] => banana [color] => yellow ) [1] => Array ( [fruit] => kiwi [color] => green ) [4] => Array ( [fruit] => lemon [color] => yellow ) [2] => Array ( [fruit] => orange [color] => orange ) [3] => Array ( [fruit] => strawberry [color] => red ) )

ian Over a year ago

so there will be no apple in the result

ian Over a year ago

This is great, but now apple has an index of 4 instead of 3 (I have added a few more fruit to the first array in my post)

shadyyx Over a year ago

Hmm, OK, so apple shouldn't be last, but has an index 3? Why do You need this?

ian Over a year ago

The matching fruit will be echoed to the screen as the 3rd result in the first row, so when I change the matching word to look for it will always end op the 3rd result and all the other results will go down (second row)

|

Collectives™ on Stack Overflow

Re-indexing an array by matching value

4 Answers 4

DEMO

2 Comments

2 Comments

1 Comment

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

1 Comment

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related