sorting part of a multidimensional array

Question

I have an multi dimensional array:

$array[0] = array ( name => "Bob",
    position => "Chair",
    email => "[email protected]"
);
$array[1] = array ( name => "Al",
    position => "",
    email => "[email protected]"
);
//etc..

I want to sort it so that those whose position != "" are first, then the rest alphabetically by name... I'm not very familiar w/ sorting multidimensional arrays, could someone help me? Thanks!

And in what order do you want the ones with no position to be in? For example, alphabetical by email/name or in their original order? — salathe
– salathe, Commented Jul 21, 2010 at 19:55
possible duplicate of How do I sort a multi-dimensional array by value? — Wrikken
– Wrikken, Commented Jul 21, 2010 at 19:58

Wistar · Accepted Answer · 2014-02-07 17:39:53Z

4

<?php  
$array[0] = array ( name => "Bob", position => "Chair", email => "[email protected]");  
$array[1] = array ( name => "Al", position => "",email => "[email protected]");  
print_r($array);  

$idxPos = array();  
for ($i=0;$i<count($array);$i++)
{  
    $idxPos[$i] = $array[$i]["position"]; 
}  
arsort($idxPos);  

$arrayNew = array();  
$sortedKeys = array_keys($idxPos);  
for($p=0;$p<count($idxPos);$p++)
{
$arrayNew[] = $array[$sortedKeys[$p]];
}
$array = $arrayNew;  

print_r("<br />");  
print_r($array);  
?>

edited Feb 7, 2014 at 17:39

Wistar

3,7905 gold badges48 silver badges71 bronze badges

answered Jul 21, 2010 at 20:15

Irwin

12.9k12 gold badges73 silver badges97 bronze badges

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

1 Comment

Matchu Over a year ago

backticks are generally best for $small_bits, whereas indenting with 4 spaces is best for code blocks. Edited to make things look prettier :)

Daniel Egeberg · Accepted Answer · 2010-07-21 20:08:06Z

The usort function is probably your best bet for this:

usort($array, function($a, $b) {
    if (empty($a['position']) && !empty($b['position'])) {
        return 1; 
    }   
    else if (!empty($a['position']) && empty($b['position'])) {
        return -1;
    }   
    else {
        return strcmp($a['name'], $b['name']);
    }   
});

Anonymous functions were introduced in PHP 5.3.0. If you're using an earlier version you can just define a regular function instead:

function cmp($a, $b) {
    if (empty($a['position']) && !empty($b['position'])) {
        return 1; 
    }   
    else if (!empty($a['position']) && empty($b['position'])) {
        return -1;
    }   
    else {
        return strcmp($a['name'], $b['name']);
    }   
}

usort($array, 'cmp');

funwhilelost · Accepted Answer · 2010-07-21 19:55:49Z

0

You'll probably want to try usort so you can use a custom sorting function. In the sorting function you can check a["position"] vs b["position"] in the way you describe.

answered Jul 21, 2010 at 19:55

funwhilelost

2,01018 silver badges20 bronze badges

Collectives™ on Stack Overflow

sorting part of a multidimensional array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related