Sort arrays within an array, by name

Question

Input:

$sql = array(

    array("id"=>"47", "name"=>"Jason", "device"=>"idevice"),
    array("id"=>"49", "name"=>"uniKornn", "device"=>"idevice"),
    array("id"=>"50", "name"=>"jacob", "device"=>"idevice")
)

Output:

$sql = array(

    array("id"=>"50", "name"=>"jacob", "device"=>"idevice"),
    array("id"=>"47", "name"=>"Jason", "device"=>"idevice"),
    array("id"=>"49", "name"=>"uniKornn", "device"=>"idevice")
)

I want to set the order of the array $sql, by name, and case-insensitive.

And what have you tried?

Crozin
– Crozin

2014-01-26 16:21:01 +00:00
Commented Jan 26, 2014 at 16:21 — Crozin
– Crozin, Commented Jan 26, 2014 at 16:21
I've tried using sort($sql) but that didn't work...

131
– 131

2014-01-26 16:21:41 +00:00
Commented Jan 26, 2014 at 16:21 — 131
– 131, Commented Jan 26, 2014 at 16:21
How about ksort($sql)

csharp newbie
– csharp newbie

2014-01-26 16:23:09 +00:00
Commented Jan 26, 2014 at 16:23 — csharp newbie
– csharp newbie, Commented Jan 26, 2014 at 16:23

gurudeb · Accepted Answer · 2014-01-26 16:34:14Z

5

function build_sorter($key) {
    return function ($a, $b) use ($key) {
        return strnatcmp($a[$key], $b[$key]);
    };
}

usort($sql, build_sorter('name'));

EDIT: For case-insensitive:

Option 1:

function build_sorter($key) {
    return function ($a, $b) use ($key) {
        return strnatcasecmp($a[$key], $b[$key]);
    };
}

usort($sql, build_sorter('name'));

Option 2:

function build_sorter($key) {
    return function ($a, $b) use ($key) {
        return strnatcmp(strtolower($a[$key]), strtolower($b[$key]));
    };
}

usort($sql, build_sorter('name'));

Full Code:

<?php

$sql = array(
    array("id"=>"47", "name"=>"Jason", "device"=>"idevice"),
    array("id"=>"49", "name"=>"uniKornn", "device"=>"idevice"),
    array("id"=>"50", "name"=>"jacob", "device"=>"idevice")
);

function build_sorter($key) {
    return function ($a, $b) use ($key) {
        return strnatcmp(strtolower($a[$key]), strtolower($b[$key]));
    };
}

usort($sql, build_sorter('name'));

foreach ($sql as $item) {
    echo $item['id'] . ', ' . $item['name'] .', ' . $item['device'] . "\n";
}

?>

edited Jan 26, 2014 at 16:34

answered Jan 26, 2014 at 16:22

gurudeb

1,87622 silver badges30 bronze badges

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

1 Comment

131 Over a year ago

This works, but it is case-sensitive. It orders by A-Z a-z. I want it to be case-insensitive

oleksii.svarychevskyi · Accepted Answer · 2014-01-26 16:25:20Z

-1

Or short version for strings

function cmp($a, $b)
{
     return strcmp($a["name"], $b["name"]);
 }

usort($array, "cmp");

answered Jan 26, 2014 at 16:25

oleksii.svarychevskyi

1,1068 silver badges13 bronze badges

Collectives™ on Stack Overflow

Sort arrays within an array, by name

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related